Assignment 3 Shruthi Ramesh Nayak sxn145130 1. Draw an ER diagram for university library system. Specify key attributes of each entity type and structural constraints on each relationship type (cardinality ratios and participation constraints). State any assumptions you make. It is assumed that a member can borrow at most of 2 books at a time. 2. Consider a grade book database in which instructors within an academic department maintain scores/points obtained by individual students in their classes. a. Design an Enhanced EntityRelationship diagram for the grade book database. b. Map the designed EER diagram to relational schema. 3. Consider the ER diagram in Figure 1. Map the given conceptual schema to relational database schema. 4. Consider the EER diagram in Figure 2 for a car dealer. Map the EER schema into a set of relations. For the VEHICLE to CAR/TRUCK/SUV generalization, consider the four options (8A, 8B, 8C, 8D) and show the relational schema design under each of those options. 8a. 8b. 8c. 8d.
View Full Document