ITSW 1407 - Introduction to Database
Content:    Data Modeling
.  Overview
.  E-R Model
.  Database Design
.  Data Objects
.  Basic Schema
.  Refining the E-R
.  Primary Keys
.  Attributes
.  Hierarchies
.  Integrity Rules
.  Bibliography
   Relational Model
.  Overview
.  Data Structure
.  Notation
.  Relational Table
.  Relationships
.  Data Integrity
.  Relational Data
.  Normalization
.  Advanced


.  Notation

CSIT Dept.,  Del Mar College

Notation

Relational tables can be expressed concisely by eliminating the sample data and showing just the table name and the column names. For example,

AUTHOR (au_id, au_lname, au_fname, address, city, state, zip)
TITLE(title_id, title, type, price, pub_id)
PUBLISHER (pub_id, pub_name, city)
AUTHOR_TITLE (au_id, title_id)


Next we will look at the properties of a Relational Table.