Help shape GoConqr. What should we add next?

Notes

Domain 4-Maintain database (Primary and Foreign Keys)

mbattl15 English 1 page

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

Feedback

What is it about?

What should we add next?