Following is the data requirements for an art museum: The museum has a collection of ART_OBJECTS .

Following is the data requirements for an art museum:

The museum has a collection of ART_OBJECTS .  Each art object has a unique IDNo, and Artist, if known, a Year (when created, if known) a Title and a Description.  The art objects are categorized in several ways, as discussed below.

ART_OBJECTS are categorized based on types.  There are three main types, Painting, Sculpture and  Statue, plus an ‘Other’ category for those that don’t fit into one of the main types.

A PAINTING has a PaintType (oil, watercolor, etc) a material on which it is CrawnOn (paper, canvas, wood) and Style (modern, abstract etc)

A SCULPTURE or a STATUE has a Material from which it was created (wood, stone, etc) Height, Weight and Style.

An art object in the OTHER category has a Type(print, photo, etc) and Style.

ART_OBJECTS are also categorized as PERMANENT_COLLECTION, which are owned by the museum (DateAcquired, whether it is OnDisplay or Stored and Cost) or BORROWED, which has information on the Collection (where it was borrowed from), DateBorrowed, and DateReturned.

ART_OBJECTS also have information describing their country-culture using information on country/culture of Origin (Italian, Egyptian, American, Indian etc) and Period(Renaissance, Modern, Ancient)

The museum keeps track of ARTISTS’s information, if known: Name, DateBorn, DateDied, CountryOfOrigin, Period, MainStyle and Description.  The name is assumed unique.

Different EXHIBITIONS occur, each having a Name, StartDate and EndDate.  EXHIBITIONS are related to all the art objects that were on display during the exhibition.

Information is kept on other COLLECTIONS with which the museum interacts, including Name (unique), Type (museum, personnel etc), Description, Address, Phone and ContactPerson.

a. Draw an EER diagram for this application.  Discuss any assumptions you make.

b. Map the designed EER diagram to relational schema.

2. Consider the following set of requirements for a pharmacy database. Draw an ER or EER diagram that captures the details specified below. State your assumptions if any.

The pharmacy has several pharmacists, and many customers. Each customer has a unique account number. Any of the pharmacists may fill a prescription of a customer. Each person (customer or pharmacist) has SSN, name, address, phone. Each person has a unique SSN. 


Each medicine has a name and a company that manufactures it. Medicines are manufactured in batches, where each batch of a medicine has a batch number and an expiry date associated with it. 


Each customer’s history of prescription medicines dispensed is recorded. Each prescription has a unique prescription number, the name of a doctor who wrote that prescription, the day it is filled by the pharmacy, the pharmacist who dispensed the medicines, and a list of one or more medicines. Each prescribed medicine has a name and quantity. 


It is possible that a customer may get different batches of the same medicine within a single prescription. For each medicine dispensed within each prescription, the system needs to keep track of the batch numbers and quantities of that batch given to the customer. For example, in dispensing 50 Lipitor pills, the pharmacist may have dispensed 30 pills from batch 14279 with expiry date 12/31/2013, and 20 pills from batch 15928 with expiry date 6/30/2014.