Subscribe

RSS Feed (xml)

Powered By

Skin Design:
Free Blogger Skins

Powered by Blogger


Thursday, September 15, 2011

Database design Keys

Primary key enforce entity integrity by uniquely identifying entity instances

Foreign key enforce referential integrity by completing an association between two entities

Candidate key is an attribute that can be uniquely used to identify a database record (Ex. Social security number in employee table)

Composite Key is combination of more than one attribute which uniquely identify a database record

Unique key is an attribute which can be used to identify a single record

No comments:

Post a Comment