It203 Study Guide

A. Data redundancy-Data is appears in two different places B. Primary Key- a column or place 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 actors line E. Database Entity- person, place, or thing that the database is about. Corresponds to control panels F. Database requirement- backing need that the database must insure 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 set down word- column or columns that could serve as primary keys K. Natural key- Keys that occur degree or habitually as part of the regular data L. alternate key- Key you provide artificiall y to the database M. Composite Key- A key that is made up of more than one column. N. flair to one relationship- each entity or table that matches to entity in other table. O. One to more relationship- one record in the promote table corresponds to the umteen records in the child table, but the many in the child corresponds to one record in the parent. P.

umpteen 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 entity- Main entitys that is in th at location for tracking training about. ! S. Lookup entity- a list of choices of the tables. T. weakly entity- depends on a parent table for its meaning. U. prescriptization- removes redundancies V. First normal form- removes all iterate groups or arrays W. Second Normal Form- pg 87. Removes practicable 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, target it on our website: OrderCustomPaper.com

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