Megan Taylor

front-end dev, volunteacher, news & data junkie, bibliophile, Flyers fan, sci-fi geek and kitteh servant

Intro to Databases, Video Lecture 2: Relational Databases, The Relational Model

-used by all commercial db systems
-very simple model
-query with high-level languages: simple yet expressive
-efficient implementations

Database = set named relations (or tables)
Each relation has a set of named attributes (or columns)
Each tuple (or row) has a value for each attribute
Each attribute has a type (or domain)

Schema – structural description of relations in database
Instance – actual contents at given point in time
NULL – unknown or undefined
Key – attribute whose value is unique in each tuple or set of attributes whose combined values are unique

Creating relations (tables) in SQL:
Create Table Student(ID, name, GPA, photo)
Create Table College(name string, state char(2), enrollment integer)

October 13, 2011 | Comments Off on Intro to Databases, Video Lecture 2: Relational Databases, The Relational Model | Categories: Posts | Permalink

Comments are closed.

%d bloggers like this: