Intro to Database

Card Set Information

Author:
slightlytwizted
ID:
248180
Filename:
Intro to Database
Updated:
2013-11-20 22:05:13
Tags:
Exam terms Database CS21503 Systems
Folders:

Description:
Cumulative exam terms and information for Intro to Database/ Database Systems CS21503
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user slightlytwizted on FreezingBlue Flashcards. What would you like to do?


  1. What is a Primary Key?
    A key that must be unique and cannot be null.
  2. 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.
  3. 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.
  4. 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
    • | | \___/   /   /
    • | \______/   /
    •  \________/
  5. What are the CRUD operators?
    Create, Read, Update, Delete

What would you like to do?

Home > Flashcards > Print Preview