CHP4 Flashcards
1
Q
Candidate key
A
- A candidate key can be any column or a combination of columns that is qualified as unique key
1
Q
Primary key
A
- An attribute that uniquely identifies any given entity (row)
- Unchangeable
2
Q
Foreign key
A
- Primary key that becomes a foreign key after being placed into another table to create a common attribute
3
Q
Entity integrity
A
- ensuring each row of a table has a unique and non-null primary key value
4
Q
Referential integrity
A
- Foreign key contains a null (0) or valid in the PK of the related tables
5
Q
Data dictionary
A
- Provides detailed accounting of all tables found within created tables.
- Contains all attribute names and characteristics
- Contains metadata
