CS SE 6360 004 Assignment 3 Due Date March 11 2016 Solution 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 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 8d
View Full Document
Unlocking...