Create a logical ERD for the problems below using the crowsfoot format discussed in class. Be sure that each entity has the entity name at the top of the box, the primary key attribute or attributes in the middle of the box, and the non-key attributes in the bottom of the box. Lines should separate each part of the entity box. Follow these instructions about each ERD: The ERD should not have any M:N relationships. All attributes should be placed within an entity. Each entity must have a primary key defined. A primary key may consist of one or more attributes. Each relationship must have a foreign key. Denote the foreign key(s) with the notation (FK) on the ERD. Each relationship must include both a maximum and minimum cardinality for both sides of the relationship. Each relationship must have a verb phrase. Do not differentiate between an identifying or non-identifying relationship (dotted line vs. solid line). Make all your relationship lines solid. All attributes provided in the sample data or data forms must be included in the database.

Question 2. Design a database to help a large art museum keep track of its works of art. Each work of art is described by an item code (identifier), title, type (i.e. painting, sculpture, etc.), genre (i.e. abstract, photograph, etc.), height, width, and weight. Genre and type are different characteristics of a work of art. A work of art may be of more than one genre, but it is of only one type. Each genre may be related to more than one work of art. Each type may be related to more than one work of art. The museum wants to create separate lists of the types and genres of art work available at the museum. The museum has predefined the descriptions of types and genres and wants to standardize them for greater consistency of data. A work of art is created by one and only one artist, but the artist for some works is unknown. An artist is described by an artist ID (identifier), name, date of birth, and date of death (the date of death will be null for artists who are still living). Only data about artists for works currently owned by the museum are kept in the database. It is quite possible that one artist can create more than one work of art. The museum wants to keep track of the location of each work of art over time. At any point in time, a work of art is: 1) on display at the museum, 2) in storage, 3) away as part of a traveling show, 4) on loan to another museum, or 5) in transit. The museum wants to retain a complete history of the placement of works of art by date and time. They want to know when (beginning and ending dates) and where a work of art was located at any given point in time. They want to be able to tell where a work of art is right now, but they also want to be able to tell where a work of art was two years ago. They want to know such things as how many works of art have been loaned to another museum. They want to know which works of art have been away in traveling shows. They want to know how long a particular work of art is in storage. Assume that all date fields also can contain time, so there is no need to separate date and time into separate fields. If on display at the museum, the work of art is also described by its location within the museum. A location within the museum is defined by a building number, room number, wall number and position number. You do not have to keep any other information about the internal locations within the museum (like a description of the building or room). A traveling show is described by a showID (identifier), title of the show, city and country in which the show is currently appearing, and the start and end dates of the show. The start and end dates of the show may be different than the beginning and ending dates that the work of art was at the show. For example, a show might last for six months in one location, but a specific work of art may be at that show for only four of those six months. You must store the start and end dates of the show separately from the beginning and ending dates that the work of art was at the show. When a work of art is at another museum, we simply need to know that the work of art is at another museum, and which museum it is located at. We do not need to know where (building, wall, etc. ) at that museum the work of art is located. Other museums are identified by a museumID, the name of the museum, and the location (city, state, country). There is no standard identifier like a zip code for these museum locations, since the museums could be anywhere around the world. When a work of art is in transit, the museum of course wants to know the beginning and ending dates of transit, but also wants to keep track of the name of the transit company (i.e. UPS, FedEx), and a description of any potential damage that occurred while in transit. The name of a transit company can definitely be standardized. The descriptions of damage are unique and cannot be standardized.