Notas
Domain 4-Maintain database (Primary and Foreign Keys)
Conteúdo das notas (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).
Informações
- Descrição
- Notas sobre Domain 4-Maintain database (Primary and Foreign Keys), criado por mbattl15 em 24-03-2015.
- Criado por
- mbattl15 · mar 2015
- Atualizado
- 19 fev 2016
- Visualizações
- 3
- Avaliação
Mais sobre Database Keys and Relationships