FIT2094 Study Guide - Final Guide: Candidate Key, Foreign Key, Unique Key

• School: Monash University
• Department: Information Technology
• Course: FIT2094
• Professor: Mr Lindsay Smith

Document Summary

Relational heading is the names of column headings. Relational body is the set of data rows. Superkey is all the set of attributes that uniquely identify each row. Candidate key is all the minimal set of attributes that uniquely identify each row. Primary key is a chosen designed candidate key. Foreign key is a key that is a primary key in another table. Entity integrity primary key must be unique and cannot be null. Referential integrity foreign keys must be null or the exact same as the primary key value. Column/domain integrity all values in the column must be in the domain set. Functional dependency is when a set of attributes x determines an attribute y. Total dependency is when attribute a determines attribute b and attribute b determines attribute a. Transitive dependency is when attribute b depends on attribute a, and attribute c depends on attribute b.