Assignment 3 1 Shruthi Ramesh Nayak sxn145130 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 Entity Relationship 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
Unlocking...