For this assignment you will draw from an MS Excel worksheet to create a data model that conforms to third normal form. Use MS Visio and use crow's foot database notation

Beyond the hints and tips, though, you must infer the user requirements based on the information contained in the associated MS Excel worksheet. Specifically, you must:1.Not violate first normal form(i.e., your model must deal with multi-valued attributes);2.Not violate second normal form (i.e., your model must eliminate partial dependencies); and3.Not violate third normal form(i.e., your model must eliminate transitive dependencies). Some spreadsheet columns represent composite attributes, and its your job to determine which ones shouldbe broken down into simple attributes.

Note that where there are missing values (in the spreadsheet), they are there for a reason.(Im referring specifically to the artist2 and artist2_countrycolumns.) That is, its anticipated that data will be collected for those columns, so they must be taken into account in your datamodel.

Hints and Tips/General hints/guidelineso

Use surrogate PKsfor every entity(e.g., museumID, exhibitID)

Remember that the crows foot should abut the child, not the parent

Remember that foreign keys reside in the child entityoEntity and attribute names shouldnt have any spaces in them, and they should be singular, not plural (e.g., exhibit, not exhibits)

Anattribute name should be prefixed with the name of its entity (e.g., objectYear, not year)

A foreign key should have the same name as the primary key it is derived from

The solution model comprises 7entities, including 3bridge entities

Specific hints-There are no 1:1 relationships in the model,Hints about relationships A museum can host many exhibits, and an exhibit can appear (over time of course) in many museums,an object isnt tied to a museum, rather, its tied to an exhibit(because thisdatabase is all about keeping track of exhibits).Also, an object can appear in multiple exhibits over time.

Please submit as a pdf if you can thank you.

exhibit_start_date 17-Feb-18 17-Feb-18 17-Feb-18 17-Feb-18 17-Feb-18 17-Feb-18 17-Feb-18 museum_name museum_address National Gallery of Art 100 Constitution Ave. NW, Washington DC 20565 National Gallery of Art 100 Constitution Ave. NW, Washington DC 20565 National Gallery of Art 100 Constitution Ave. NW, Washington DC 20565 National Gallery of Art 100 Constitution Ave. NW, Washington DC 20565 National Gallery of Art 100 Constitution Ave. NW, Washington DC 20565 National Gallery of Art 100 Constitution Ave. NW, Washington DC 20565 National Gallery of Art 100 Constitution Ave. NW, Washington DC 20565 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 exhibit_name exhibit_location Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 100 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 101 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 102 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 103 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 104 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 105 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 106 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 501 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 501 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 501 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 501 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 501 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 501 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 501 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 501 The American West in Bronze, 1850-1925 East Gallery 450 The American West in Bronze, 1850-1925 East Gallery 450 The American West in Bronze, 1850-1925 East Gallery 450 The American West in Bronze, 1850-1925 East Gallery 450 The American West in Bronze, 1850-1925 East Gallery 450 The American West in Bronze, 1850-1925 East Gallery 450 The American West in Bronze, 1850-1925 East Gallery 450 The American West in Bronze, 1850-1925 East Gallery 450 15-May-18 15-May-18 15-May-18 15-May-18 15-May-18 15-May-18 15-May-18 15-May-18 18-Dec-18 18-Dec-18 18-Dec-18 18-Dec-18 18-Dec-18 18-Dec-18 18-Dec-18 18-Dec-18 exhibit_end_date object_title object_class 19-May-18 Christ in the House of His Parents (The Carpenter's Shop) Painting 19-May-18 Ecce Ancilla Domini (The Annunciation) Painting 19-May-18 Valentine Rescuing Sylvia from Proteus (Two Gentlement of Ve Painting 19-May-18 Chatterton Painting 19-May-18 Ophelia Painting 19-May-18 La Belle Iseult Painting 19-May-18 The Light of the World Painting 3-Sep-18 Pieta and the Virgin and Saint John Painting 3-Sep-18 Orpheus and Eurydice Painting 3-Sep-18 Portrait of Lucina Brembati Painting 3-Sep-18 Christ and a Devotee Painting 3-Sep-18 Portrait of a Little Girl of the Redetti Family Painting 3-Sep-18 Saint Ambrose and Emperor Theodosius Painting 3-Sep-18 The Three Crosses Painting 3-Sep-18 Saint Jerome in a Landscape Painting 13-Apr-19 Pioneer Woman Sculpture 13-Apr-19 Lassoing Wild Horses Sculpture 13-Apr-19 Choosing of the Arrow Sculpture 13-Apr-19 Two Gun Bill Sculpture 13-Apr-19 Appeal to the Great Spirit Sculpture 13-Apr-19 End of the Trail Sculpture 13-Apr-19 Bull Elk Sculpture 13-Apr-19 Indian Hunter and His Dog Sculpture E E E E object_medium Oil on canvas Oil on canvas Oil on canvas Oil on canvas Oil on canvas Oil on canvas Oil on canvas Tempera on wood Oil on wood Oil on wood Oil on wood Oil on canvas Oil and tempera on wood Tempera on wood Oil and tempera on canvas Bronze Bronze object_dimensions object_year artist1 86.4 x 139.7 cm 1849-1850 John Everett Millais 73.7 x 41.9 cm 1849-1850 Dante Gabriel Rossetti 98.5 x 133.3 cm 1850-1851 William Holman Hunt 62.2 x 93.3 cm 1855-1856 Henry Wallis 76.2 x 111.8 cm 1851-1852 John Everett Millais 71.8 x 50.2 cm 1857-1858 William Morris 49.8 x 21.6 cm 1851-1856 William Holman Hunt 43.7 x 32.4 cm 1455-1460 Giovanni Bellini 39.6 x 53 cm 1508-1512 Titian 52.6 x 44.8 cm 1518-1523 Lorenzo Lotto 78.3 x 61.9 cm 1518 Moretto da Brescia 40 x 32 cm 1570 Giovanni Moroni 32 x 22 cm 1490 Bergognone 68 x 38 cm 1450-1456 Vincenzo Foppa 65.1 x 58 cm 1505 Barolomeo Montagna n/a 1927 Bryant Baker n/a 1900-1902 Solon Hannibal Borglum 1849 Henry Kirke Brown 1925 Charles Cristadoro n/a 1922 Cyrus Edwin Dallin 20.32 cm (h) x 17.78 cm (1) x 7.62 cm (w) 1918 James Earle Fraser n/a 1905 Eli Harvey n/a 1926 Paul Manship Bronze n/a Bronze n/a Bronze Bronze Bronze Bronze artist2 artist2_country artist1_country United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom Italy Italy Italy Italy Italy Italy Italy Italy USA USA USA USA USA USA USA USA exhibit_start_date 17-Feb-18 17-Feb-18 17-Feb-18 17-Feb-18 17-Feb-18 17-Feb-18 17-Feb-18 museum_name museum_address National Gallery of Art 100 Constitution Ave. NW, Washington DC 20565 National Gallery of Art 100 Constitution Ave. NW, Washington DC 20565 National Gallery of Art 100 Constitution Ave. NW, Washington DC 20565 National Gallery of Art 100 Constitution Ave. NW, Washington DC 20565 National Gallery of Art 100 Constitution Ave. NW, Washington DC 20565 National Gallery of Art 100 Constitution Ave. NW, Washington DC 20565 National Gallery of Art 100 Constitution Ave. NW, Washington DC 20565 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 The Metropolitan Museum of Art 1000 Fifth Ave., New York, NY 10028-0198 exhibit_name exhibit_location Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 100 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 101 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 102 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 103 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 104 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 105 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 106 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 501 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 501 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 501 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 501 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 501 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 501 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 501 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 501 The American West in Bronze, 1850-1925 East Gallery 450 The American West in Bronze, 1850-1925 East Gallery 450 The American West in Bronze, 1850-1925 East Gallery 450 The American West in Bronze, 1850-1925 East Gallery 450 The American West in Bronze, 1850-1925 East Gallery 450 The American West in Bronze, 1850-1925 East Gallery 450 The American West in Bronze, 1850-1925 East Gallery 450 The American West in Bronze, 1850-1925 East Gallery 450 15-May-18 15-May-18 15-May-18 15-May-18 15-May-18 15-May-18 15-May-18 15-May-18 18-Dec-18 18-Dec-18 18-Dec-18 18-Dec-18 18-Dec-18 18-Dec-18 18-Dec-18 18-Dec-18 exhibit_end_date object_title object_class 19-May-18 Christ in the House of His Parents (The Carpenter's Shop) Painting 19-May-18 Ecce Ancilla Domini (The Annunciation) Painting 19-May-18 Valentine Rescuing Sylvia from Proteus (Two Gentlement of Ve Painting 19-May-18 Chatterton Painting 19-May-18 Ophelia Painting 19-May-18 La Belle Iseult Painting 19-May-18 The Light of the World Painting 3-Sep-18 Pieta and the Virgin and Saint John Painting 3-Sep-18 Orpheus and Eurydice Painting 3-Sep-18 Portrait of Lucina Brembati Painting 3-Sep-18 Christ and a Devotee Painting 3-Sep-18 Portrait of a Little Girl of the Redetti Family Painting 3-Sep-18 Saint Ambrose and Emperor Theodosius Painting 3-Sep-18 The Three Crosses Painting 3-Sep-18 Saint Jerome in a Landscape Painting 13-Apr-19 Pioneer Woman Sculpture 13-Apr-19 Lassoing Wild Horses Sculpture 13-Apr-19 Choosing of the Arrow Sculpture 13-Apr-19 Two Gun Bill Sculpture 13-Apr-19 Appeal to the Great Spirit Sculpture 13-Apr-19 End of the Trail Sculpture 13-Apr-19 Bull Elk Sculpture 13-Apr-19 Indian Hunter and His Dog Sculpture E E E E object_medium Oil on canvas Oil on canvas Oil on canvas Oil on canvas Oil on canvas Oil on canvas Oil on canvas Tempera on wood Oil on wood Oil on wood Oil on wood Oil on canvas Oil and tempera on wood Tempera on wood Oil and tempera on canvas Bronze Bronze object_dimensions object_year artist1 86.4 x 139.7 cm 1849-1850 John Everett Millais 73.7 x 41.9 cm 1849-1850 Dante Gabriel Rossetti 98.5 x 133.3 cm 1850-1851 William Holman Hunt 62.2 x 93.3 cm 1855-1856 Henry Wallis 76.2 x 111.8 cm 1851-1852 John Everett Millais 71.8 x 50.2 cm 1857-1858 William Morris 49.8 x 21.6 cm 1851-1856 William Holman Hunt 43.7 x 32.4 cm 1455-1460 Giovanni Bellini 39.6 x 53 cm 1508-1512 Titian 52.6 x 44.8 cm 1518-1523 Lorenzo Lotto 78.3 x 61.9 cm 1518 Moretto da Brescia 40 x 32 cm 1570 Giovanni Moroni 32 x 22 cm 1490 Bergognone 68 x 38 cm 1450-1456 Vincenzo Foppa 65.1 x 58 cm 1505 Barolomeo Montagna n/a 1927 Bryant Baker n/a 1900-1902 Solon Hannibal Borglum 1849 Henry Kirke Brown 1925 Charles Cristadoro n/a 1922 Cyrus Edwin Dallin 20.32 cm (h) x 17.78 cm (1) x 7.62 cm (w) 1918 James Earle Fraser n/a 1905 Eli Harvey n/a 1926 Paul Manship Bronze n/a Bronze n/a Bronze Bronze Bronze Bronze artist2 artist2_country artist1_country United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom Italy Italy Italy Italy Italy Italy Italy Italy USA USA USA USA USA USA USA USA