Apuntes
Domain 4-Maintain database (Primary and Foreign Keys)
Contenido del apunte (1)
Página 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).
Información
- Descripción
- Apunte sobre Domain 4-Maintain database (Primary and Foreign Keys), creado por mbattl15 el 24/03/2015.
- Creado por
- mbattl15 · mar 2015
- Actualizado
- 19 feb 2016
- Visitas
- 3
- Valoración
Más sobre Database Keys and Relationships