CS/SE 6360.004- Assignment 3Due Date: March 11, 2016Solution1. 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.Assumptions:• A borrower can either be Student, faculty or other.• One member can borrow N books. • A book should be published only by one publisher. 2. Following is the data requirements for an art museum:( in the assignment)a. Draw an EER diagram for this application. Discuss any assumptions you make.b. Map the designed EER diagram to relational schema.3. Mapping of the given conceptual schema to relational database schema.4. Mapping of the given EER diagram. a. Using 8a:b. Using 8b:c. Using 8c:d. Using
View Full Document