Notizen
Domain 4-Maintain database (Primary and Foreign Keys)
Inhalt der Notizen (1)
Seite 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).
Informationen
- Beschreibung
- Notiz am Domain 4-Maintain database (Primary and Foreign Keys), erstellt von mbattl15 am 24/03/2015.
- Erstellt von
- mbattl15
- Aufrufe
- 3
- Bewertung
Mehr zu Database Keys and Relationships