Weeks | Topics | Readings |
2.5 |
Relational Model, Languages and Systems
Introduction to Database Systems
Relational Data Model and Relational Algebra
Relational Data Model
Relational Algebra
SQL
Data Definitions
Queries and Updates
Views
Summary
Introduction to Sybase
Introduction to report writer
Relational Calculus
|
EN: 1 & 2
EN: 7.1-7.3
EN: 7.4-7.7
EN: 8.1
EN: 8.2-8.4
EN: 8.5
EN: 8.8
Course Notes
Course Notes
EN: 9.3-9.5
|
2 |
Database Design: The Entity-Relationship Model
Overview of the DB Design Process
The Entity-Relationship (ER) Model
The Model
The Enhanced-ER Model Including UML Class Diagrams
Mapping the ER Model to the Relational Model
|
skim EN: 16.1-2
EN: 3
EN: 4
EN: 9.1-9.2
|
2 |
Database Design: Functional Dependencies and Normalization
Functional Dependencies and Normalization
Functional Dependencies
Normalization
Normalization Algorithms
Multivalued Dependencies and 4th Normal Form
The Database Design Process
|
EN: 14.1-2
EN: 14.3-14.6
EN: 15.1
EN: 15.2
EN: 16.1-4, 16.6
|