Competency 10, Primary Key, Foreign Key, Entity, Entity Integrity, and Referential Integrity.

1. Primary Key-- A field which contains a unique ID Code only assigned to that specific record. It is used to link tables and create relationships

2. Foreign Key-- Is the Primary Key field in another table. The Foreign Key is what the Primary Key links to in order to access data from other tables.

3. Entity--

4. Entity Integrity--

5. Referential Integrity-- Creating permanent relationships via Primary Key, Foreign Key... also provides you with Referential Integrity. It provides you with a type of cross-checking & validity of data when entering new records. It also provides you with the option of Cascade Updates & Deletes. Which will automatically update all related fields when updating. The Cascade Delete will delete all assocoated records preventing orphan records in other tables.