Notes
Domain 4-Maintain database (Primary and Foreign Keys)
Content of the notes (1)
Page 1
Use of Primary and Foreign Keys
Primary and foreign keys are the most basic components of relational databases. Primary keys (PK) enforce entity integrity by uniquely identifying an entity (such as a person, place, thing, or event). Any table that describes an entity should have a primary key. The value of the primary key should be unique. For example, if patient number is chosen as a primary key, one and only one patient should be associated with a specific number.
Another type of key is called the foreign key (FK). Foreign keys are used to associate relationships between entities (tables).
Information
- Description
- Note on Domain 4-Maintain database (Primary and Foreign Keys), created by mbattl15 on 24/03/2015.
- Created by
- mbattl15 · Mar 2015
- Updated
- Feb 19, 2016
- Views
- 3
- Rating
More on Database Keys and Relationships