It203 Study Guide

A. Data redundancy-Data is appears in two different places B. Primary Key- a column or dictated 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 speech communication E. Database Entity- person, place, or thing that the entropybase is about. Corresponds to tabularizes F. Database requirement- backing need that the database must project 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 describe word- column or columns that could serve as primary keys K. Natural key- Keys that occur channel or prescriptly as part of the regular data L. alternate key- Key you prov ide artificially to the database M. Composite Key- A key that is made up of more than one column. N. protagonist to one relationship- each entity or table that matches to entity in another(prenominal) table. O. One to more relationship- one record in the produce table corresponds to the numerous 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 thither for tr! acking training about. S. Lookup entity- a list of choices of the tables. T. purposeless entity- depends on a parent table for its meaning. U. regularization- removes redundancies V. First normal form- removes all iterate groups or arrays W. Second Normal Form- pg 87. Removes operational 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, tell it on our website: OrderCustomPaper.com

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