The flashcards below were created by user
on FreezingBlue Flashcards.
What is a Primary Key?
A key that must be unique and cannot be null.
What is a Candidate Key
A minimal superkey; that is, a key that does not contain a subset of attributes that is itself a superkey.
What is Referential Integrity?
A condition by which a dependent table's foreign key must have either a null entry or a matching entry in the related table.
What is Full Functional Dependency?
- When an attribute is functionally dependent on a composite key but not on any subset of the key.
- AB ---> C, D, E
- | | \___/ / /
- | \______/ /
What are the CRUD operators?
Create, Read, Update, Delete