Consider the following set of data requirements for an ART MUSEUM in which a collection of art objects is described. . The art museum DB has art objects, each identified by a unique identification number, an artist, if known, a year when it was created. It also has a type, title and description. All art objects are further divided into (categorized) into painting, sculpture, and other category based on their type. Each painting has a paint type (oil, etc.), drawn_on material (canvas, paper, etc.) and style (abstract, impressionism, etc.). Each sculpture has material made from (stone, metal, etc.) style (abstract, impressionism, etc.), height, and weight. (abstract, impressionism, etc.). The museum also tracks the artist information, if known such as unique name, date of birth, e if known, and date the artist died, if not alive. It also keep track about the artist country of origin (Italian, Egyptian), epoch (ancient, modern, etc.), and main style. Each art object might be displayed on an exhibition. Each exhibition has a unique name, start date and end date. Make the conceptual design of the ART_ MUSEUM database. This includes (1) The Initial Conceptual Design (ICD) and (2) The design of the EER schema for it. Le., when designing the EER schema make the initial conceptual design and after that-the necessary refinements Specify the key attributes of each entity type and structural constraints (both cardinality ratios and total/partial participation) on each relationship type. Also, specify the constraints (both .(10 pts) The initial conceptual design of your EER schema (for reference, you may see the ICD of the COMPANY database, p. 9-10 in the notes for Ch. 7) The EER diagrams of your EER schema resulted after all the design refinements have been completed: . (80 pts) EER diagram with structural constraints using I, M, N (written in next to a relationship type rhombus) for cardinality ratio and double and single lines for total and partial participation. Assumptions for any unspecified data requirements, if needed I made
