Shared Flashcard Set

Details

Relational Database basics
into to relational databases
9
Computer Science
Undergraduate 1
01/25/2012

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!