CS348 Study Guide - Flat File Database

• School: University of Waterloo
• Department: Computer Science
• Course: CS348
• Professor: Ahmed A Ataullah

Document Summary

In this assignment you have to draw an eer diagram that captures the situation described in the scenarios. You can use the example given in the course notes as a good starting point. Remember to state all constraints (including cardinality) in your diagram. Hint: words in italics are important terms to consider and think about when drawing out the eer. The university of dystopia currently stores information about its employees (instructors and support staff) and students in flat text files. You have to draw an er diagram such that it can then be given to a database programmer or dba to ensure that the university"s record keeping requirements can be met in a modern relational database system. All individuals at the university are uniquely identified by their university id (uid) but students are given unique student ids (sid) as well.