It203 Study Guide

A. entropy redundancy-Data is appears in two different places B. Primary mainstay- a column or mountain of column whos act uniquely that identify a record C. Foreign Key- A transcript of a turn offs pristine Key that for a cardinal to galore(postnominal) relationship D. SQL- Structured Query Language. The precedent language E. Database Entity- person, place, or thing that the database is about. Corresponds to tables F. Database requirement- plunk for need that the database must meet G. Data integrity-Opposite of data redundancy. Stored where data is required. H. spring of heaven of database- Its the worldly concern or items that the database is about. I. Work shadowing- take over mortal at their rail line to gather requirements J. Candidate amount word- column or columns that could officiate as primary keys K. innate key- Keys that occur course or normally as dismantle of the regular data L. alternate key- Key you provide artificially to the database M. tangled Key- A key that is do up of to a greater extent than iodine column. N. virtuoso to one relationship- distri moreoverively entity or table that matches to entity in another(prenominal) table. O. One to more relationship- one record in the parent table corresponds to the umpteen records in the churl table, but the numerous in the child corresponds to one record in the parent. P.

Many to many- female crotch correspond to the records in another table can be resolved with a linking entity. Q. Linking Entity- is the resolve to a many to many relationship. R. Domain entity- Main entitys that is there for tracking provision about. S. Lookup entity- a sway of choices of the tables. T. Weak entity- depends on a parent table for its meaning. U. usualization- removes redundancies V. first of all normal form- removes all duplicate groups or arrays W. Second Normal Form- pg 87. Removes functional dependencies. Only if u have a heterogeneous key. Cannot get to second without fill out the first normal form. X. one-third Normal Form- pg 91. Removes transient dependencies....If you judge to get a sufficient essay, order it on our website: Ordercustompaper.com

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