Reference no: EM133218369
Question: EER diagram include all appropriate details including cardinality, participation constraints, candidate keys, disjoint or overlap
-Schools have a unique id. Also have a name and have an address
-Schools may be Elementary or High School but cannot be both
-Elementary schools have principal
-High school have multiple clubs offered
-Some High school are are Day care and have multiple pricing offered
-Library have a unique ISBN #, name, and can have multiple authors
-World wide Web have unique URL and a description
-Library and World wide Web are considered to be course material. Schools must buy at least one item of course material and course material can be bought by many schools. Quantity of a particular course material bought by each school is tracked