![]() |
Database Systems and Structures Lecture Outline |
Classroom: AQ 3003
Lecture: Wednesdays 17:30 – 20:20
* This schedule is subject to change at the discretion of the instructor.
|
|
|
|
|
Jan 12 | Overview, Web Resources
Chapter 1: Introduction |
|
|
Jan 19 | Chapter 2: Entity – Relationship Model | |
|
Jan 26 | Chapter 2: E-R Model, Tables and Keys
Chapter 3: Relational Model |
Assignment 1 distributed |
|
Feb 2 | Chapter 3: Relational Model
Chapter 4: Structured Query Language |
Assignment 1 due |
|
Feb 9 | Chapter 4: Structured Query Language
Chapter 5: Other Commercial Languages |
Assignments 2 & 4 distributed |
|
Feb 16 | Chapter 6: Integrity Constraints | Assignment 2 due |
|
Feb 23 | Relational DB Design | Overview: SQL-Server & SQL in C |
|
Mar 1 | Midterm Exam
Chapter 8: Object Oriented Databases |
Assignment 3 distributed |
|
Mar 8 | Chapter 10: Storage and File Structure | |
|
Mar 15 | Chapter 11: Indexing and Hashing | Assignment 3 due |
|
Mar 22 | Chapter 12: Query Processing I | Assignment 4 due |
|
Mar 29 | Chapter 12: Query Processing II | |
Apr 10, 2000 | Final Exam: 19:00 – 22:00, Location AQ 3181 |