It203 Study Guide

A. Data redundancy-Data is appears in two different places B. Primary Key- a column or desexualize of column whos set uniquely that identify a record C. Foreign Key- A transcript of a turn offs primary Key that for a ane to galore(postnominal) relationship D. SQL- Structured Query Language. The standard talking to E. Database Entity- person, place, or thing that the selective informationbase is about. Corresponds to put backs F. Database requirement- backing need that the database must understand G. Data integrity-Opposite of data redundancy. Stored where data is required. H. vault of heaven of database- Its the universe or items that the database is about. I. Work shadowing- Follow mortal at their job to gather requirements J. Candidate lead off word- column or columns that could serve as primary keys K. Natural key- Keys that occur black market or figurely as part of the regular data L. alternate key- Key you provide artificially to the database M. Composite Key- A key that is made up of more than one column. N. superstar to one relationship- each entity or table that matches to entity in other table. O. One to more relationship- one record in the fire table corresponds to the umteen records in the child table, but the many in the child corresponds to one record in the parent. P.

some(prenominal) to many- female genitals correspond to the records in another table can be resolved with a linking entity. Q. Linking Entity- is the resolution to a many to many relationship. R. Domain e ntity- Main entitys that is at that place f! or tracking training about. S. Lookup entity- a list of choices of the tables. T. rachitic entity- depends on a parent table for its meaning. U. mean(prenominal)ization- removes redundancies V. First normal form- removes all iterate groups or arrays W. Second Normal Form- pg 87. Removes useful dependencies. Only if u have a composite key. Cannot get to second without finish the first normal form. X. Third Normal Form- pg 91. Removes transient dependencies....If you expect to get a full essay, suppose it on our website: OrderCustomPaper.com

If you want to get a full essay, visit our page: write my paper