Introduction to Data Management
(a.k.a. Computer Applications in Business: Databases)
CS 338 Waterloo, Fall '03
Instructor: David Toman (firstname.lastname@example.org)
Office: DC 3128 (Tue 2-3pm or by appointment)
Lectures: Tue-Thu 8:30-10 am MC 4061
Class Info: http://db.uwaterloo.ca/~david/cs338
Hashemian, Seyyed Vahid email@example.com MC4019F 12:00-1:00 Mon
Kaastra, Mike firstname.lastname@example.org DC3324 2:00-3:00 Thu
Zhang, Jie (Jane) email@example.com MC4024 11:00-12:00 Wed
Synopsis and Overview
The lectures try to give an answer the following three questions:
Assignments will be collected in class on due date (often an
electronic submission will be required). As the solutions may (and
often will) be discussed on the due date in class, no late assignments
will be accepted.
Lecture Schedule and notes (by week of classes):
- Introduction to Databases
- Data Models and
Basic ER modeling (.pdf)
- Relational Model (.pdf),
ER to relational
- Relational Algebra
DB2 tutorial (.pdf)
SQL Queries I (.pdf)
- SQL Queries II (.pdf),
SQL Queries III (.pdf)
- SQL Updates (.pdf),
Sample Database copy-to-your-account file,
Static Embedded SQL
- review for midterm and MIDTERM (10/23 in class))
- More on Application Development:
Dymamic Embedded SQL
- More on Schema design:
Integrity Constraints and Normal Forms
Integrity Constraints and Normal Forms, Part II
- Query Processing in Relational Systems
- Transaction Management
- slack and review for final
The lectures do not assume any prior knowledge of databases. However,
you must brush up your skills in the following three areas:
||Fundamentals of Database Systems (3rd or 4th ed.)
Elmasri and Navathe, Addison Wesley. |
||Database and Knowledge-Base Systems I., II.
Jeff Ullman. Comp. Sci. Press, 1988.|
||Database Management Systems.
Raghu Ramakrishnan. McGraw Hill, 1997.|
||Foundations of Databases.
S. Abiteboul, R. Hull, V. Vianu, Addison-Wesley, 1995.|
The lectures do not follow the textbook to the letter.
||Final Exam |
|CS 338:|| 20% || 35%
|| 45% |
To pass the course, you must pass the final examination.
Fine print: the usual university policies on academic honesty, fair
use of computing facilities, etc., apply by default.