Directions for the Problems. Draw a conceptual data model to model the scenario in each problem. Use the model constructs (e.g., the material on the E-R model and the enhanced E-R model) from chapters 2 and 3 as appropriate and follow the modeling conventions used in the example problems in the online lessons. Do not use the modeling conventions shown in Figure 2-22 of the Hoffer textbook which illustrate a data model in Visio notation. Be sure to include all appropriate completeness constraints, disjointness constraints, and subtype indicators in your conceptual data models.

An art museum owns a large volume of Art Works. Attributes of Art Work are ArtItemID, Title, Type, Height, Width, and Size. Size is calculated by multiplying the height and width. An Art Work is created by one or more Artist. An Artist can create one or more Art Work. Attributes of Artist include ArtistID, ArtistName (composed of FirstName, MiddleInitial, and LastName), and CountriesOfResidence. An Artist can have more than one CountryOfResidence. The art museum creates Traveling Shows to display its Art Works in cities throughout the world. Attributes of Traveling Show include TravelingShowID, Cities, StartDate, EndDate, and Duration. A Traveling show can have one or more city. Duration is calculated as the amount of time between the StartDate and EndDate. A Traveling Show must include at least one Art Work and may include many Art Works. Art Works may be included in many number of Traveling Shows but may have never been included in a Traveling Show.