Chapter 3 Flashcards
Superpkey
Any key that uniquely identifies each row
Candidate key
A superkey without unnecessary attributes
Entity Integrity
When each row in a table is uniquely identified by a primary key
Referential Integrity
When a foreign key contains a value that corresponds to an existing tuple in another relation
Secondary key
A key that is used strictly for data retrieving purposes
Natural join
links tables by selecting only the rows with common values in their common attributes
Data dictionary
Detailed description of all tables found within the user/designer-created database
System catalog
Contains metadata. Can be described as a detailed system data dictionary that describes all objects within the database
Composite entity AKA bridge entity and associative entity
Used to linked tables that originally had a many to many relationship
Attribute domain
A specific range of values in a column