CS 3743 -- Fall 1993 Homepage

CS 3743 -- Fall 1993
Database Management Systems

This course was an undergraduate requirement. It emphasized the relational model.

The unusual feature of the course was the main programming assignment:

Programming project: Implement a relational database management system. (Pages 5-15 below.)

Features:

Based on the relational algebra, rather than a language like SQL, which would have been too difficult to be feasible for this course.
The students used a scanner for the relational algebra language which I supplied, because they hadn't yet had the programming languages course.
First they implemented CREATE and INSERT commands. With these, no other external form of the database would be required. Also implemented were the simple commands DROP (a relation), PRINT (a relation), and HALT.
As the final step, they were to implement SELECT, PROJECT, and JOIN, along with set operations.

Students were surprised that they could actually implement a usable system, at least allowing the creation of databases of the complexity of examples in class.

Section	Pages
Syllabus	Page 1: small, large Page 2: small, large
Example	Page 3: small, large Page 4: small, large
Project: Relational Database Management System	Page 5: small, large Page 6: small, large Page 7: small, large Page 8: small, large Page 9: small, large Page 10: small, large Page 11: small, large Page 12: small, large Page 13: small, large Page 14: small, large Page 15: small, large
E-R Diagram Assignment, Answer	Page 16: small, large Page 17: small, large Page 18: small, large
Prolog Assignment	Page 19: small, large Page 20: small, large
SQL Assign	Page 21: small, large
Mid-term Exam	Page 22: small, large Page 23: small, large
Topics for Final Exam	Page 24: small, large Page 25: small, large
Final Exam	Page 26: small, large Page 27: small, large

CS 3743 -- Fall 1993 Database Management Systems

CS 3743 -- Fall 1993
Database Management Systems