Problem PE1.2

Draw an EER schema diagram for the database that is to keep track of information for an art museum that has multiple Art_Objects. Assume that the following business rules (BRs) are relevant:

BR	Description
1	Each Art_Object has a unique OID_Number, an Artist (if known), a O_Year (when it was created, if known), a O_Title, and a O_Description.
2	Information describing the Country of Origin and Epoch (Renaissance, Modern, Ancient, and so forth) is also captured for each Art_Object. For each Art_Object there is a single Country_of_Origin; for a Country_of_Origin there could be multiple Art_Objects. For each Art_Object there is a single Epoch; for some Epochs there are multiple Art_Objects.
3	The museum keeps track of Artist information: A_Name, Date_Born (if known), Date_Died (if not living), Country_of_Origin, Epoch, Main_Style, and Description. The A_Name is assumed to be unique.
4	Each Country of Origin has C_Region and a unique C_Name.
5	Each Epoch has E_Description, E_Year_Range and a unique E_Name.
6	Art_Objects are classified as: Painting, Sculpture, Statue, or Other (to accommodate objects that are neither Painting nor Sculpture nor Statue). A Painting has a Paint_Type (oil, watercolor, etc.), a Material on which it is drawn on (paper, canvas, wood, etc.), 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 class has a Type (print, photo, etc.) and Style.
7	Each Material has a M_Description and a unique M_Name.
8	Different Exhibitions occur, each having a X_Name (unique), Start_Date, and End_date. Exhibitions are related to all the Art_Objects that were on display during the Exhibition (i.e. an Exhibition typically includes multiple Art_Objects, each of which could be included in multiple Exhibitions).
9	Information is kept on other Collections with which the museum interacts, including Collection_Name (unique), Collection_Type (museum, personal, etc.), Description, Address, Phone, and current Contact_Person.
10	Art_Objects are also classified as either Permanent_Collection (objects that are owned by the museum) or Borrowed. Information captured about objects in the Permanent_Collection includes Date_Acquired, Status (on display, on loan, or stored), and Cost. Information captured about Borrowed objects includes the Collection from which it was borrowed, Date_Borrowed, and Date_Returned.

Use the following to present your Answer for Questions PE1.2:

Work Table

Entities	Name of Entity		Classification		List of Attributes		Identifier
Categories	Name of Category		Names of Participating Entities				Identifier
Relationships	Name of Relationship	Classification		Names of Participating Entities/Categories		List of Non-Identifier Attributes

Answer for Question: Entity-Relationship Diagram