Intro to Database

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

Author

slightlytwizted

248180

Card Set

Intro to Database

Description

Cumulative exam terms and information for Intro to Database/ Database Systems CS21503

Updated

2013-11-21T03:05:13Z