Shared Flashcard Set

Details

Relational Database basics
into to relational databases
9
Computer Science
Undergraduate 1
01/25/2012
Click here to study/print these flashcards.

Create your own flash cards! Sign up here.

Additional Computer Science Flashcards

 

 

Cards

Term
Database
 Definition
set of named relations or (tables)
Term
Columns
 Definition
a set of named atributes
Term
tuple (or row)
Definition

value for each attribute

each attribute has a type or domain

Term
Schema
 Definition
structural description of relations in the database
Term
Instance
 Definition
actual contents at a given point in time
Term
NULL
 Definition
special value for "unknown" or "undefined"
Term
Key
 Definition

 

attribute whose value is unique in each tuple

or

set of attributes whose combined values are unique

 

 
Supporting users have an ad free experience!