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 crows 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.

museum_name National Gallery of Art National Gallery of Art National Gallery of Art National Gallery of Art National Gallery of Art National Gallery of Art National Gallery of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art museum_address exhibit name exhibit_location 100 Constitution Ave. NW, Washington DC 20565 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 100 100 Constitution Ave. NW, Washington DC 20565 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 101 100 Constitution Ave. NW, Washington DC 20565 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 102 100 Constitution Ave. NW, Washington DC 20565 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 103 100 Constitution Ave. NW, Washington DC 20565 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 104 100 Constitution Ave. NW, Washington DC 20565 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 105 100 Constitution Ave. NW, Washington DC 20565 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 106 1000 Fifth Ave., New York, NY 10028-0198 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 601 1000 Fifth Ave., New York, NY 10028-0198 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 601 1000 Fifth Ave., New York, NY 10028-0198 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 601 1000 Fifth Ave., New York, NY 10028-0198 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 601 1000 Fifth Ave., New York, NY 10028-0198 , Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 601 , 1000 Fifth Ave., New York, NY 10028-0198 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 601 1000 Fifth Ave., New York, NY 10028-0198 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 601 1000 Fifth Ave., New York, NY 10028-0198 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 601 1000 Fifth Ave., New York, NY 10028-0198 The American West in Bronze, 1850-1925 East Gallery 450 1000 Fifth Ave., New York, NY 10028-0198 The American West in Bronze, 1850-1925 , East Gallery 450 1000 Fifth Ave., New York, NY 10028-0198 The American West in Bronze, 1850-1925 East Gallery 450 1000 Fifth Ave., New York, NY 10028-0198 , The American West in Bronze, 1850-1925 East Gallery 450 1000 Fifth Ave., New York, NY 10028-0198 The American West in Bronze, 1850-1925 East Gallery 450 1000 Fifth Ave., New York, NY 10028-0198 The American West in Bronze, 1850-1925 East Gallery 450 1000 Fifth Ave., New York, NY 10028-0198 The American West in Bronze, 1850-1925 East Gallery 450 1000 Fifth Ave., New York, NY 10028-0198 The American West in Bronze, 1850-1925 East Gallery 450 exhibit_start_date exhibit_end_date 17-Feb-18 19-May-18 17-Feb-18 19-May-18 17-Feb-18 19-May-18 17-Feb-18 19-May-18 17-Feb-18 19-May-18 17-Feb-18 19-May-18 17-Feb-18 19-May-18 15-May-18 3-Sep-18 15-May-18 3-Sep-18 15-May-18 3-Sep-18 15-May-18 3-Sep-18 15-May-18 3-Sep-18 15-May-18 3-Sep-18 15-May-18 3-Sep-18 15-May-18 3-Sep-18 18-Dec-18 13-Apr-19 18-Dec-18 13-Apr-19 18-Dec-18 13-Apr-19 18-Dec-18 13-Apr-19 18-Dec-18 13-Apr-19 18-Dec-18 13-Apr-19 18-Dec-18 - 13-Apr-19 18-Dec-18 13-Apr-19 object_title object_class object_medium Christ in the House of His Parents (The Carpenter's Shop) Painting Oil on canvas Ecce Ancilla Domini (The Annunciation) Painting Oil on canvas Valentine Rescuing Sylvia from Proteus (Two Gentlement of Ve Painting Oil on canvas Chatterton Painting Oil on canvas Ophelia Painting Oil on canvas La Belle Iseult Painting Oil on canvas The Light of the World Painting Oil on canvas Pieta and the Virgin and Saint John Painting Tempera on wood Orpheus and Eurydice Painting Oil on wood Portrait of Lucina Brembati Painting Oil on wood Christ and a Devotee Painting Oil on wood Portrait of a Little Girl of the Redetti Family Painting Oil on canvas Saint Ambrose and Emperor Theodosius Painting Oil and tempera on wood The Three Crosses Painting Tempera on wood Saint Jerome in a Landscape Painting Oil and tempera on canvas Pioneer woman Sculpture Bronze Lassoing Wild Horses Sculpture Bronze Choosing of the Arrow Sculpture Bronze Two Gun Bill Sculpture Bronze Appeal to the Great Spirit Sculpture Bronze End of the Trail Sculpture Bronze Bull Elk Sculpture Bronze Indian Hunter and His Dog Sculpture 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 1900-1902 Solon Hannibal Borglum n/a 1849 Henry Kirke Brown n/a 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 1926 Paul Manship n/a n/a artist2 artist2_country artist1 John Everett Millais Dante Gabriel Rossetti William Holman Hunt Henry Wallis John Everett Millais William Morris William Holman Hunt Giovanni Bellini 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 Titian Lorenzo Lotto Moretto da Brescia Giovanni Moroni Bergognone Vincenzo Foppa Barolomeo Montagna Bryant Baker Solon Hannibal Borglum Henry Kirke Brown Charles Cristadoro Cyrus Edwin Dallin James Earle Fraser Eli Harvey Paul Manship USA USA USA USA USA USA USA museum_name National Gallery of Art National Gallery of Art National Gallery of Art National Gallery of Art National Gallery of Art National Gallery of Art National Gallery of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art The Metropolitan Museum of Art museum_address exhibit name exhibit_location 100 Constitution Ave. NW, Washington DC 20565 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 100 100 Constitution Ave. NW, Washington DC 20565 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 101 100 Constitution Ave. NW, Washington DC 20565 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 102 100 Constitution Ave. NW, Washington DC 20565 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 103 100 Constitution Ave. NW, Washington DC 20565 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 104 100 Constitution Ave. NW, Washington DC 20565 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 105 100 Constitution Ave. NW, Washington DC 20565 Pre-Raphaelites: Victorian Art and Design, 1848-1900 West Building 106 1000 Fifth Ave., New York, NY 10028-0198 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 601 1000 Fifth Ave., New York, NY 10028-0198 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 601 1000 Fifth Ave., New York, NY 10028-0198 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 601 1000 Fifth Ave., New York, NY 10028-0198 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 601 1000 Fifth Ave., New York, NY 10028-0198 , Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 601 , 1000 Fifth Ave., New York, NY 10028-0198 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 601 1000 Fifth Ave., New York, NY 10028-0198 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 601 1000 Fifth Ave., New York, NY 10028-0198 Bellini, Titian, and Lotto: North Italian Paintings from the West Gallery 601 1000 Fifth Ave., New York, NY 10028-0198 The American West in Bronze, 1850-1925 East Gallery 450 1000 Fifth Ave., New York, NY 10028-0198 The American West in Bronze, 1850-1925 , East Gallery 450 1000 Fifth Ave., New York, NY 10028-0198 The American West in Bronze, 1850-1925 East Gallery 450 1000 Fifth Ave., New York, NY 10028-0198 , The American West in Bronze, 1850-1925 East Gallery 450 1000 Fifth Ave., New York, NY 10028-0198 The American West in Bronze, 1850-1925 East Gallery 450 1000 Fifth Ave., New York, NY 10028-0198 The American West in Bronze, 1850-1925 East Gallery 450 1000 Fifth Ave., New York, NY 10028-0198 The American West in Bronze, 1850-1925 East Gallery 450 1000 Fifth Ave., New York, NY 10028-0198 The American West in Bronze, 1850-1925 East Gallery 450 exhibit_start_date exhibit_end_date 17-Feb-18 19-May-18 17-Feb-18 19-May-18 17-Feb-18 19-May-18 17-Feb-18 19-May-18 17-Feb-18 19-May-18 17-Feb-18 19-May-18 17-Feb-18 19-May-18 15-May-18 3-Sep-18 15-May-18 3-Sep-18 15-May-18 3-Sep-18 15-May-18 3-Sep-18 15-May-18 3-Sep-18 15-May-18 3-Sep-18 15-May-18 3-Sep-18 15-May-18 3-Sep-18 18-Dec-18 13-Apr-19 18-Dec-18 13-Apr-19 18-Dec-18 13-Apr-19 18-Dec-18 13-Apr-19 18-Dec-18 13-Apr-19 18-Dec-18 13-Apr-19 18-Dec-18 - 13-Apr-19 18-Dec-18 13-Apr-19 object_title object_class object_medium Christ in the House of His Parents (The Carpenter's Shop) Painting Oil on canvas Ecce Ancilla Domini (The Annunciation) Painting Oil on canvas Valentine Rescuing Sylvia from Proteus (Two Gentlement of Ve Painting Oil on canvas Chatterton Painting Oil on canvas Ophelia Painting Oil on canvas La Belle Iseult Painting Oil on canvas The Light of the World Painting Oil on canvas Pieta and the Virgin and Saint John Painting Tempera on wood Orpheus and Eurydice Painting Oil on wood Portrait of Lucina Brembati Painting Oil on wood Christ and a Devotee Painting Oil on wood Portrait of a Little Girl of the Redetti Family Painting Oil on canvas Saint Ambrose and Emperor Theodosius Painting Oil and tempera on wood The Three Crosses Painting Tempera on wood Saint Jerome in a Landscape Painting Oil and tempera on canvas Pioneer woman Sculpture Bronze Lassoing Wild Horses Sculpture Bronze Choosing of the Arrow Sculpture Bronze Two Gun Bill Sculpture Bronze Appeal to the Great Spirit Sculpture Bronze End of the Trail Sculpture Bronze Bull Elk Sculpture Bronze Indian Hunter and His Dog Sculpture 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 1900-1902 Solon Hannibal Borglum n/a 1849 Henry Kirke Brown n/a 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 1926 Paul Manship n/a n/a artist2 artist2_country artist1 John Everett Millais Dante Gabriel Rossetti William Holman Hunt Henry Wallis John Everett Millais William Morris William Holman Hunt Giovanni Bellini 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 Titian Lorenzo Lotto Moretto da Brescia Giovanni Moroni Bergognone Vincenzo Foppa Barolomeo Montagna Bryant Baker Solon Hannibal Borglum Henry Kirke Brown Charles Cristadoro Cyrus Edwin Dallin James Earle Fraser Eli Harvey Paul Manship USA USA USA USA USA USA USA