For this assignment you will create a normalized database (3NF) from the data in the ChicagoParksArt table, which you can create with the following script:

ChicagoParksArt.sql

/****************************

 * ChicagoParksArt.sql

 *

 * Creates a denormalized table with a list of artwork on display at the Chicago Park District.

 * Source: https://data.cityofchicago.org/Parks-Recreation/Parks-Public-Art/sj6t-9cju

 ****************************/

IF EXISTS (

 SELECT 1 

 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' 

 AND TABLE_NAME='ChicagoParksArt'

 ) 

 DROP TABLE ChicagoParksArt;

GO

CREATE TABLE ChicagoParksArt

(

 a VARCHAR(255),

 b VARCHAR(255),

 c VARCHAR(255),

 d VARCHAR(255),

 e VARCHAR(255),

 f VARCHAR(255),

 g VARCHAR(255),

 h VARCHAR(255),

 i VARCHAR(255),

 j VARCHAR(255)

);

GO

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'East Gate Arch', 'Greg & Camille Leavitt', 'Lincoln Park Zoo', '41.921948000000000', '-87.632309000000006', '55', '11', '60');

INSERT ChicagoParksArt VALUES ('WASHINGTON (HAROLD)', '494', 'Ecstasy', 'Virginio Ferrari', 'CPD', '41.802644000000001', '-87.582384000000005', '130', '6', '61');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Elephant Drinking Fountain', 'George Suyeoka', 'Lincoln Park Zoo', '41.923029000000000', '-87.633402000000004', '53', '11', '62');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Eli Bates Fountain (Storks at Play)', 'Augustus Saint-Gaudens', 'CPD', '41.922735000000003', '-87.635214000000005', '8', '6', '63');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Emanuel Swedenborg Memorial', 'Adolff Johnson', 'CPD', '41.931448000000003', '-87.631686000000002', '3', '6', '64');

INSERT ChicagoParksArt VALUES ('PALMISANO (HENRY)', '531', 'Entry Fountain', 'Ernest Wong', 'CPD', '41.844225999999999', '-87.646930999999995', '42', '6', '65');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Equestrian Indians', 'Ivan Mestrovic', 'COD', '41.875960999999997', '-87.623558000000003', '67', '5', '66');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Eugene Field Memorial', 'Edward McCartan', 'CPD', '41.921143000000001', '-87.632163000000006', '39', '6', '67');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Federal Building Columns', 'Henry Ives Cobb', 'CPD', '41.884113999999997', '-87.617450000000005', '60', '6', '68');

INSERT ChicagoParksArt VALUES ('OGDEN (WILLIAM) PLAZA', '477', 'Floor Clock II', 'Vito Acconci', 'CPD', '41.890264000000002', '-87.619891999999993', '131', '6', '69');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Flying Dragon', 'Alexander Calder', 'Art Institute of Chicago', '41.880408000000003', '-87.623757999999995', '5', '2', '70');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'For the Young at Heart', 'George Suyeoka', 'Lincoln Park Zoo', '41.921109999999999', '-87.635186000000004', '53', '11', '71');

INSERT ChicagoParksArt VALUES ('FULLER (MELVILLE)', '4', 'Fountain', NULL, 'CPD', '41.812061000000000', '-87.634591999999998', NULL, '6', '72');

INSERT ChicagoParksArt VALUES ('MARIANO (LOUIS)', '1239', 'Fountain', NULL, 'CPD', '41.901738000000002', '-87.628159999999994', NULL, '6', '73');

INSERT ChicagoParksArt VALUES ('MID-NORTH', '1206', 'Fountain', 'Gast Monuments Inc.', NULL, '41.923603999999997', '-87.639052000000007', '51', NULL, '74');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Fountain Figures', 'Leonard Crunelle', 'CPD', '41.873865000000002', '-87.619802000000007', '85', '6', '75');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Fountain Figures', 'Leonard Crunelle', 'CPD', '41.873877999999998', '-87.618001000000007', '85', '6', '76');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Fountain Figures', 'Leonard Crunelle', 'CPD', '41.877701000000002', '-87.619902999999994', '85', '6', '77');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Fountain Figures', 'Leonard Crunelle', 'CPD', '41.877726000000003', '-87.618086000000005', '85', '6', '78');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Fountain Girl', 'George Wade', 'CPD', '41.912253000000000', '-87.629322999999999', '54', '6', '79');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Fountain of the Great Lakes (Spirit of the Great Lakes)', 'Lorado Taft', 'Art Institute of Chicago', '41.878760999999997', '-87.623652000000007', '87', '2', '80');

INSERT ChicagoParksArt VALUES ('WASHINGTON (GEORGE)', '21', 'Fountain of Time', 'Lorado Taft', 'CPD', '41.786726999999999', '-87.607697000000002', '87', '6', '81');

INSERT ChicagoParksArt VALUES ('HUMBOLDT (BARON VON)', '219', 'Fritz Reuter', 'Franz Engelsman', 'CPD', '41.903801000000001', '-87.701919000000004', '45', '6', '82');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Garden Figure', 'Frederick Cleveland Hibbard', 'CPD', '41.924177999999998', '-87.635216999999997', '47', '6', '83');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Gen. Philip Henry Sheridan Monument', 'Gutzon Borglum', 'CPD', '41.940449000000001', '-87.639239000000003', '56', '6', '84');

INSERT ChicagoParksArt VALUES ('WASHINGTON (GEORGE)', '21', 'George Washington Monument', 'Daniel Chester French', 'COC', '41.802557999999998', '-87.616434999999996', '28', '4', '85');

INSERT ChicagoParksArt VALUES ('GARIBALDI (GIUSEPPE)', '1047', 'Giuseppe Garibaldi Monument', 'Victor Gheradi', 'CPD', '41.872591999999997', '-87.665311000000003', '128', '6', '86');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Goddess of Youth (Hebe)', NULL, 'CPD', '41.924245999999997', '-87.635382000000007', NULL, '6', '87');

INSERT ChicagoParksArt VALUES ('BURNHAM (DANIEL)', '27', 'Gold Star Families Memorial', 'David Woodhouse & Assoc.', 'CPD', '41.862440999999997', '-87.614228999999995', '32', '6', '88');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Gorilla', NULL, 'Lincoln Park Zoo', '41.919880999999997', '-87.632294000000002', NULL, '11', '89');

INSERT ChicagoParksArt VALUES ('WASHINGTON (GEORGE)', '21', 'Gotthold Ephraim Lessing', 'Albin Polasek', 'CPD', '41.794457999999999', '-87.606510000000000', '4', '6', '90');

INSERT ChicagoParksArt VALUES ('GOUDY (WILLIAM) SQUARE', '105', 'Goudy Square Playground Art', 'Walter Arnold', 'CPD', '41.905506000000003', '-87.626874999999998', '132', '6', '91');

INSERT ChicagoParksArt VALUES ('HERITAGE GREEN', '537', 'Grainne', 'Maurice Harron', 'CPD', '41.879451000000003', '-87.643786000000006', '95', '6', '92');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Greene Vardiman Black', 'Frederick Cleveland Hibbard', 'CPD', '41.911340000000003', '-87.627593000000005', '47', '6', '93');

INSERT ChicagoParksArt VALUES ('"WICKER (CHARLES)"', '214', 'Gurgolye Fountain', 'Robinson Iron Works', 'CPD', '41.907688999999998', '-87.676728999999995', '110', '6', '94');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Hans Christian Andersen', 'Johannes Gelert', 'CPD', '41.919603000000002', '-87.634662000000006', '72', '6', '95');

INSERT ChicagoParksArt VALUES ('HORNER (HENRY)', '228', 'Henry Horner Monument', 'John David Brcin', 'CPD', '41.961089000000001', '-87.698229999999995', '75', '6', '96');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Heron', 'H. Wheatley Allen', 'Lincoln Park Zoo', '41.921320999999999', '-87.635203000000004', '57', '11', '97');

INSERT ChicagoParksArt VALUES ('HUMBOLDT (BARON VON)', '219', 'Home (Miner and Child)', 'Charles Mulligan', 'CPD', '41.903449000000002', '-87.697559999999996', '19', '6', '98');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'In Celebration of the 200th Anniversary of the Founding of the Republic', 'Isamu Noguchi', 'Art Institute of Chicago', '41.880389000000001', '-87.621099999999998', '66', '2', '99');

INSERT ChicagoParksArt VALUES ('HUMBOLDT (BARON VON)', '219', 'Interpreting Nature', 'Roman Villareal', 'CPD', '41.906255000000002', '-87.699420000000003', '111', '6', '100');

INSERT ChicagoParksArt VALUES ('UNION', '210', 'James Connolly Monument', 'Tom White', 'CPD', '41.882634000000003', '-87.666535999999994', '124', '6', '101');

INSERT ChicagoParksArt VALUES ('CHICAGO WOMENS PARK AND GARDENS', '550', 'Jane Addams Memorial (Helping Hands)', 'Louise Bourgeois', NULL, '41.856971999999999', '-87.621233000000004', '89', NULL, '102');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Johann Christoph Friedrich von Schiller', 'Ernst Bilhauer Rau', 'CPD', '41.921998000000002', '-87.635194999999996', '43', '6', '103');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'John Alexander Logan Monument', 'Augustus Saint-Gaudens', 'CPD', '41.870607999999997', '-87.623445000000004', '8', '6', '104');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'John Peter Altgeld Monument', 'Gutzon Borglum', 'CPD', '41.932186999999999', '-87.637529999999998', '56', '6', '105');

INSERT ChicagoParksArt VALUES ('NORTHERLY ISLAND', '34', 'Karel Havlicek', 'Joseph Strachovsky', 'CPD', '41.866318999999997', '-87.610449000000003', '81', '6', '106');

INSERT ChicagoParksArt VALUES ('KENNEDY (DENNIS)', '48', 'Korean War Memorial', 'Maurice Moore Memorials', 'CPD', '41.688001999999997', '-87.681370000000001', '96', '6', '107');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Kwa-Ma-Rolas (Totem Pole)', 'Haida Indians', 'CPD', '41.948971999999998', '-87.642422999999994', '58', '6', '108');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Large Interior Form', 'Henry Moore', 'Art Institute of Chicago', '41.880294999999997', '-87.623666999999998', '63', '2', '109');

INSERT ChicagoParksArt VALUES ('LEGION', '274', 'Legion Park Gateway Plaza Fountain', 'DeStefano & Partners', 'CPD', '41.989952000000002', '-87.707955999999996', '36', '6', '110');

INSERT ChicagoParksArt VALUES ('HUMBOLDT (BARON VON)', '219', 'Leif Ericsson Monument', 'Sigvald Asbjrnsen', 'CPD', '41.906716000000003', '-87.701559000000003', '115', '6', '111');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Limestone Lion', 'Kathleen McCullough', 'Lincoln Park Zoo', '41.921968000000000', '-87.633059000000003', '84', '11', '112');

INSERT ChicagoParksArt VALUES ('GARFIELD (JAMES)', '204', 'Lincoln the Rail-Splitter', 'Charles J. Mulligan', 'CPD', '41.881788000000000', '-87.716069000000005', '17', '6', '113');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Lion Fountain', 'George Suyeoka', 'Lincoln Park Zoo', '41.921342000000003', '-87.633920000000003', '53', '11', '114');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Lions', 'Edward Kemeys', 'Art Institute of Chicago', '41.879568999999996', '-87.624043000000000', '38', '2', '115');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Lowland Gorilla Family', 'Bill Wieger', 'Lincoln Park Zoo', '41.919719000000001', '-87.631829999999994', '10', '11', '116');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Magdalene', 'Dessa Kirk', 'Dessa Kirk', '41.875734000000001', '-87.623801000000000', '35', '8', '117');

INSERT ChicagoParksArt VALUES ('NORTHERLY ISLAND', '34', 'Man Enters the Cosmos', 'Henry Moore', 'CPD', '41.866759000000002', '-87.607106000000002', '63', '6', '118');

INSERT ChicagoParksArt VALUES ('PARK NO. 474', '474', 'Man on a Bench', 'George Segal', 'Illinois Institute of Technology', '41.835509999999999', '-87.627601999999996', '52', '10', '119');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Man With Fish', 'Stephan Balkenhol', 'Shedd Aquarium', '41.867130000000003', '-87.614649999999997', '117', '14', '120');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Margate Park Playground Art', 'CPAG', 'CPD', '41.972464000000002', '-87.649438000000004', '22', '6', '121');

INSERT ChicagoParksArt VALUES ('WASHINGTON SQUARE', '1244', 'McCormick Fountain', NULL, 'CPD', '41.899272000000003', '-87.630583999999999', NULL, '6', '122');

INSERT ChicagoParksArt VALUES ('FULLER (MELVILLE)', '4', 'Melville W. Fuller Bust', 'William Ordway Partridge', 'CPD', '41.812175000000003', '-87.634597999999997', '134', '6', '123');

INSERT ChicagoParksArt VALUES ('BURNHAM (DANIEL)', '27', 'Mermaid (La Sirena)', 'Jose Moreno', 'CPD', '41.820650999999998', '-87.597196999999994', '80', '6', '124');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Monument to Johann Wolfgang von Goethe', 'Herman Hahn', 'CPD', '41.932603000000000', '-87.638609000000002', '64', '6', '125');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Mother and Baby Pygmy Hippo', 'Henry Mitchell', 'Lincoln Park Zoo', '41.922750999999998', '-87.632971999999995', '62', '11', '126');

INSERT ChicagoParksArt VALUES ('GARFIELD (JAMES)', '204', 'Norman Cornwall Memorial (WWI Obelisk)', 'Carl J. Epiing', 'CPD', '41.877057999999998', '-87.716005999999993', '16', '6', '127');

INSERT ChicagoParksArt VALUES ('NICHOLS (JOHN FOUNTAIN)', '277', 'North Fountain', 'Maria Whiteman', 'CPD', '41.799168999999999', '-87.593660000000000', '94', '6', '128');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Old Fishing Hole', 'Peter Darro', 'Lincoln Park Zoo', '41.920586000000000', '-87.633675999999994', '102', '11', '129');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Olmec Head', 'Ignacio Perez Salono', 'Field Museum', '41.867044999999997', '-87.615821999999994', '65', '9', '130');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Paris Metro Entryway (Guimard)', 'Hector Guimard', 'COC', '41.876976999999997', '-87.623906000000005', '59', '4', '131');

INSERT ChicagoParksArt VALUES ('GARFIELD (JAMES)', '204', 'Pastoral & Idyl', 'Lorado Taft', 'CPD', '41.886335000000003', '-87.717299999999994', '87', '6', '132');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Pathfinders', 'Veryl Goodnight', 'Lincoln Park Zoo', '41.921464000000000', '-87.634871000000004', '127', '11', '133');

INSERT ChicagoParksArt VALUES ('CORNELL (PAUL) SQUARE', '5', 'Paul Cornell Bust', 'Sigvald Asbjrnsen', 'CPD', '41.802959000000001', '-87.670123000000004', '115', '6', '134');

INSERT ChicagoParksArt VALUES ('GARFIELD (JAMES)', '204', 'Persian Pool (Yellow Lilies)', 'Dale Chihuly', 'CPD', '41.886293000000002', '-87.717456999999996', '25', '6', '135');

INSERT ChicagoParksArt VALUES ('TOM (PING) MEML.', '481', 'Ping Tom Bust', 'Liao Huilan', 'CPD', '41.856945000000003', '-87.634906999999998', '86', '6', '136');

INSERT ChicagoParksArt VALUES ('COMMERCIAL CLUB PGD. OF CHICAGO', '1006', 'Playground Art', 'John Pittman Webber', 'CPD', '41.896607000000003', '-87.673768999999993', '79', '6', '137');

INSERT ChicagoParksArt VALUES ('KENNEDY (DENNIS)', '48', 'Playground Art', 'Roman Villareal', 'CPD', '41.687674999999999', '-87.681959000000006', '111', '6', '138');

INSERT ChicagoParksArt VALUES ('MOUNT GREENWOOD', '251', 'Playground Art', 'CPAG', 'CPD', '41.690947000000001', '-87.712301999999994', '22', '6', '139');

INSERT ChicagoParksArt VALUES ('OWENS (JESSE)', '237', 'Playground Art', 'CPAG', 'CPD', '41.734856000000001', '-87.574393000000001', '22', '6', '140');

INSERT ChicagoParksArt VALUES ('WASHINGTON (GEORGE)', '21', 'Playground Art', 'CPAG', 'CPD', '41.791828000000002', '-87.614739999999998', '22', '6', '141');

INSERT ChicagoParksArt VALUES ('SKINNER (MARK)', '211', 'Playground Dragon', 'CPAG', 'CPD', '41.879382000000000', '-87.659873000000005', '22', '6', '142');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Polar Bear', 'Viktor Bougaev', 'Lincoln Park Zoo', '41.924039999999998', '-87.633793999999995', '129', '11', '143');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Putnam Chain', NULL, 'Chicago History Museum', '41.912410000000001', '-87.631101999999998', NULL, '3', '144');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Rabbit and Butterfly', 'H. Wheatley Allen', 'Lincoln Park Zoo', '41.920811000000000', '-87.634917000000002', '57', '11', '145');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Reading Cones', 'Richard Serra', 'COC', '41.880603000000001', '-87.619051999999996', '108', '4', '146');

INSERT ChicagoParksArt VALUES ('PARK NO. 532', '532', 'Restoration', 'Milton Mizenburg Jr.', NULL, '41.819965000000003', '-87.600577999999999', '98', NULL, '147');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Richard Oglesby Monument', 'Leonard Crunelle', 'CPD', '41.930148000000003', '-87.637066000000004', '85', '6', '148');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Rites of Spring', 'Milton Horn', 'Lincoln Park Zoo', '41.919333999999999', '-87.632999999999996', '97', '11', '149');

INSERT ChicagoParksArt VALUES ('GARFIELD (JAMES)', '204', 'Robert Burns Memorial', 'William Grant Stevenson', 'CPD', '41.881990999999999', '-87.717360999999997', '133', '6', '150');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Robert Cavalier de LaSalle', 'Count Jacque de la Laing', 'CPD', '41.913364999999999', '-87.632743000000005', '21', '6', '151');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Roscoe Playground Art', 'CPAG', 'CPD', '41.943016999999998', '-87.638994999999994', '22', '6', '152');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Rosenberg Fountain (Hebe)', 'Franz Machtl', 'CPD', '41.868690999999998', '-87.623773000000000', '46', '6', '153');

INSERT ChicagoParksArt VALUES ('GOMPERS (SAMUEL)', '40', 'Samuel Gompers Monument', 'Susan Clinard', 'CPD', '41.975287999999999', '-87.728550999999996', '118', '6', '154');

INSERT ChicagoParksArt VALUES ('OZ', '423', 'Scarecrow', 'John Kearney', 'CPD', '41.921720999999998', '-87.643970999999993', '78', '6', '155');

INSERT ChicagoParksArt VALUES ('RENAISSANCE', '509', 'Sculptural Fountain', 'Jerzy Kenar', 'CPD', '41.750718999999997', '-87.656103000000002', '70', '6', '156');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Seal and Sea Lion', 'Dino C. Crisanti', 'Lincoln Park Zoo', '41.921491000000003', '-87.634550000000004', '37', '11', '157');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Siblings', 'Rosetta', 'Lincoln Park Zoo', '41.918596999999998', '-87.635931999999997', '112', '11', '158');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Signal of Peace', 'Cyrus Edwin Dallin', 'CPD', '41.933205999999998', '-87.631377000000001', '24', '6', '159');

INSERT ChicagoParksArt VALUES ('LOGAN SQUARE SKATE PARK', '549', 'Silversurf Gate', 'Lucy Slivinski', NULL, '41.928493000000003', '-87.689569000000006', '90', NULL, '160');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Sir Georg Solti Bust', 'Dame Elisabeth Frink', 'CPD', '41.878095999999999', '-87.623956000000007', '26', '6', '161');

INSERT ChicagoParksArt VALUES ('BURNHAM (DANIEL)', '27', 'Soldier Field Childrens Garden', 'Peter Lindsay Schaudt', NULL, '41.864573000000000', '-87.614842999999993', '103', NULL, '162');

INSERT ChicagoParksArt VALUES ('NICHOLS (JOHN FOUNTAIN)', '277', 'South Fountain', 'Gary Wojcik', 'CPD', '41.795389000000000', '-87.594451000000007', '50', '6', '163');

INSERT ChicagoParksArt VALUES ('BURNHAM (DANIEL)', '27', 'Special Olympics Memorial', 'Richard Hunt', 'CPD', '41.862175999999998', '-87.615478999999993', '107', '6', '164');

INSERT ChicagoParksArt VALUES ('PARK NO. 554', '554', 'Spider Sculpture', 'Phil Schuster', NULL, '41.913969000000002', '-87.704637000000005', '104', NULL, '165');

INSERT ChicagoParksArt VALUES ('NORTHERLY ISLAND', '34', 'Spiral Galaxy', 'John David Mooney', 'Adler Planetarium', '41.866000999999997', '-87.607176999999993', '76', '1', '166');

INSERT ChicagoParksArt VALUES ('WASHINGTON (GEORGE)', '21', 'Spirit of DuSable Series', 'Jill N. Parker', 'CPD', '41.792979000000003', '-87.607179000000002', '71', '6', '167');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Spirit of Music (Theodore Thomas Memorial)', 'Albin Polasek', 'CPD', '41.873370000000001', '-87.623498999999995', '4', '6', '168');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Sunform', 'David L. Rodgers', 'Lincoln Park Zoo', '41.920597999999998', '-87.633189999999999', '30', '11', '169');

INSERT ChicagoParksArt VALUES ('NORTHERLY ISLAND', '34', 'Thaddeus Kosciusko Monument', 'Kasimir Chodzinski', 'CPD', '41.866280000000003', '-87.612499999999997', '83', '6', '170');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'The Alarm', 'John J. Boyle', 'CPD', '41.936633000000000', '-87.635884000000004', '77', '6', '171');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'The Lesson', 'Darrell Davis', 'Lincoln Park Zoo', '41.921674000000003', '-87.634810000000002', '29', '11', '172');

INSERT ChicagoParksArt VALUES ('TOUHY (PATRICK)', '246', 'The Receptor', 'Tamsie Ringler', 'Tamsie Ringler', '42.015085999999997', '-87.674852999999999', '119', '15', '173');

INSERT ChicagoParksArt VALUES ('JACKSON (ANDREW)', '19', 'The Republic (Golden Lady)', 'Daniel Chester French', 'CPD', '41.779598000000000', '-87.579896000000005', '28', '6', '174');

INSERT ChicagoParksArt VALUES ('SENN (NICHOLAS)', '227', 'The Young Lincoln', 'Charles Keck', 'CPD', '41.989775000000002', '-87.669439999999994', '18', '6', '175');

INSERT ChicagoParksArt VALUES ('MIDWAY PLAISANCE', '1268', 'Thomas Garrigue Masaryk (The Blanik Knight)', 'Albin Polasek', 'CPD', '41.786935999999997', '-87.590148999999997', '4', '6', '176');

INSERT ChicagoParksArt VALUES ('OZ', '423', 'Tin Man', 'John Kearney', 'CPD', '41.921655000000001', '-87.647437999999994', '78', '6', '177');

INSERT ChicagoParksArt VALUES ('BURNHAM (DANIEL)', '27', 'Tribute to Freedom', 'Anna Koh Varilla', 'CPD', '41.863460000000003', '-87.617424000000000', '6', '6', '178');

INSERT ChicagoParksArt VALUES ('BURNHAM (DANIEL)', '27', 'Tribute to George Halas', 'Julie Rotblatt-Amrany', NULL, '41.862532999999999', '-87.615513000000007', '82', NULL, '179');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Ulysses S. Grant Memorial', 'Louis T. Rebisso', 'CPD', '41.917529000000002', '-87.630863000000005', '88', '6', '180');

INSERT ChicagoParksArt VALUES ('MERRIMAC', '256', 'Veterans Memorial', 'Gast Monuments Inc.', NULL, '41.952606000000003', '-87.786271999999997', '51', NULL, '181');

INSERT ChicagoParksArt VALUES ('BURNHAM (DANIEL)', '27', 'Wallach Fountain', 'Frederick Cleveland Hibbard', 'CPD', '41.795574000000002', '-87.575658000000004', '47', '6', '182');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'William C. Niesen Memorial Fountain', NULL, 'CPD', '41.915126999999998', '-87.630197999999993', NULL, '6', '183');

INSERT ChicagoParksArt VALUES ('McKINLEY (WILLIAM)', '23', 'William McKinley', 'Charles Mulligan', 'CPD', '41.826282999999997', '-87.683813000000001', '19', '6', '184');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'William Shakespeare', 'William Ordway Partridge', 'CPD', '41.923811999999998', '-87.636194000000003', '134', '6', '185');

INSERT ChicagoParksArt VALUES ('INDIAN BOUNDARY', '165', 'Wind Harp', 'Craig Brant', 'Craig Brant', '42.009599000000001', '-87.692150999999996', '23', '7', '186');

INSERT ChicagoParksArt VALUES ('LOYOLA', '115', 'Windform', 'Lynn Takata', 'CPD', '42.005941999999997', '-87.658181999999996', '91', '6', '187');

INSERT ChicagoParksArt VALUES ('OGDEN (WILLIAM)', '8', 'World War II Memorial Fountain', 'Frederick Cleveland Hibbard', 'CPD', '41.775041000000002', '-87.655824999999993', '47', '6', '188');

INSERT ChicagoParksArt VALUES ('HUMBOLDT (BARON VON)', '219', 'Worlds Fair Bison', 'Edward Kemeys', 'CPD', '41.903801000000001', '-87.702405999999996', '38', '6', '189');

INSERT ChicagoParksArt VALUES ('MONUMENT', '57', 'WWI Monument (Honor Roll for Vets)', 'James J. Egan', 'CPD', '42.001748999999997', '-87.818113999999994', '68', '6', '190');

INSERT ChicagoParksArt VALUES ('WEST PULLMAN', '225', 'WWI War Memorial', NULL, 'CPD', '41.670451000000000', '-87.630864000000003', NULL, '6', '191');

INSERT ChicagoParksArt VALUES ('TRUMBULL (LYMAN)', '16', 'WWII Memorial Fountain', 'Frederick Cleveland Hibbard', 'CPD', '41.706415999999997', '-87.564727000000005', '47', '6', '192');

INSERT ChicagoParksArt VALUES ('HARRISON (CARTER)', '213', 'Zapata Bust', 'Gabriel Ponzanelli', 'CPD', '41.856802000000002', '-87.671710000000004', '49', '6', '193');

INSERT ChicagoParksArt VALUES ('GARFIELD (JAMES)', '204', 'Zellij Fountain', 'Said Ben Adiba', 'CPD', '41.886572000000001', '-87.717676999999995', '113', '6', '194');

INSERT ChicagoParksArt VALUES ('RAINBOW BEACH', '1001', '50th Anniversary of the Rainbow Division WWI', NULL, 'CPD', '41.760435000000001', '-87.556309999999996', NULL, '6', '1');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', '8th Street Fountain', 'Bennett Frost & Thomas', 'CPD', '41.871920000000003', '-87.623334999999997', '9', '6', '2');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Aaron Montgomery Ward Bust', 'Milton Horn', 'CPD', '41.869320999999999', '-87.623591000000005', '97', '6', '3');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Abraham Lincoln (Seated Lincoln)', 'Augustus Saint-Gaudens', 'CPD', '41.877318000000002', '-87.621516999999997', '8', '6', '4');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Abraham Lincoln Monument (Standing Lincoln)', 'Augustus Saint-Gaudens', 'CPD', '41.912590000000002', '-87.630266000000006', '8', '6', '5');

INSERT ChicagoParksArt VALUES ('GARFIELD (JAMES)', '204', 'Administration Bldg Interior Panels (Gold Dome Rotunda Panels)', 'Richard W. Bock', 'CPD', '41.882672999999997', '-87.716013000000004', '109', '6', '6');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Agora', 'Magdalena Abakanowicz', 'CPD', '41.868090000000002', '-87.623367000000002', '92', '6', '7');

INSERT ChicagoParksArt VALUES ('DEARBORN (HENRY)', '465', 'Alchemy -- Birds and Stone', 'Dan Yarborough', 'CPD', '41.870815000000000', '-87.629133999999993', '27', '6', '8');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Alexander Hamilton', 'John Angel', 'CPD', '41.931705999999998', '-87.638426999999993', '74', '6', '9');

INSERT ChicagoParksArt VALUES ('HUMBOLDT (BARON VON)', '219', 'Alexander von Humboldt Monument', 'Felix Gorling', 'CPD', '41.905472000000003', '-87.701457000000005', '44', '6', '10');

INSERT ChicagoParksArt VALUES ('BURNHAM (DANIEL)', '27', 'American Doughboy (Spirit of the American Doughboy)', 'Ernest Moore Viquesney', 'CPD', '41.860805999999997', '-87.616521000000006', '41', '6', '11');

INSERT ChicagoParksArt VALUES ('NORTHERLY ISLAND', '34', 'Americas Courtyard', 'Denise Milan', 'CPD', '41.865642000000001', '-87.606549999999999', '34', '6', '12');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Artists and Automobiles', 'Dessa Kirk', 'Dessa Kirk', '41.875003000000000', '-87.621476999999999', '35', '8', '13');

INSERT ChicagoParksArt VALUES ('BURNHAM (DANIEL)', '27', 'Balbo Monument', 'Capraro & Komar', 'CPD', '41.861493000000003', '-87.613551999999999', '14', '6', '14');

INSERT ChicagoParksArt VALUES ('SENECA', '1242', 'Ben', 'Deborah Butterfield', 'CPD', '41.897168999999998', '-87.622241000000002', '33', '6', '15');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Benjamin Franklin', 'Richard Henry Park', 'CPD', '41.913795000000000', '-87.631088000000005', '106', '6', '16');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Big Beaver Totem Pole', 'Norman Tait Nishga', 'Field Museum', '41.867201000000001', '-87.617029000000002', '101', '9', '17');

INSERT ChicagoParksArt VALUES ('NICHOLS (JOHN FOUNTAIN)', '277', 'Bird of Peace (The Egg Guarding the Nest)', 'Cosmo Campoli', 'CPD', '41.799188000000001', '-87.593379999999996', '20', '6', '18');

INSERT ChicagoParksArt VALUES ('BIXLER (RAY)', '1083', 'Bixler Playlot Park Fountain', NULL, 'CPD', '41.791679999999999', '-87.592776000000001', NULL, '6', '19');

INSERT ChicagoParksArt VALUES ('CHICAGO WOMENS PARK AND GARDENS', '550', 'Botanical Gardens Fountain', 'Tannis Langdon', 'CPD', '41.857076999999997', '-87.621347999999998', '120', '6', '20');

INSERT ChicagoParksArt VALUES ('GARFIELD (JAMES)', '204', 'Bulls with Maidens (World Fair Bulls/Statues of Plenty)', 'Daniel Chester French', 'CPD', '41.886595000000000', '-87.718653000000003', '28', '6', '21');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Bushmans Head', NULL, 'Lincoln Park Zoo', '41.920186000000001', '-87.632189999999994', NULL, '11', '22');

INSERT ChicagoParksArt VALUES ('CANAL ORIGINS', '502', 'Canal Cut Artwork', 'Phil Schuster', 'CPD', '41.842883000000000', '-87.665508000000003', '104', '6', '23');

INSERT ChicagoParksArt VALUES ('PORTAGE', '147', 'Canoe Sculpture', 'Phil Schuster', 'Phil Schuster', '41.954455000000003', '-87.766565999999997', '104', '13', '24');

INSERT ChicagoParksArt VALUES ('MIDWAY PLAISANCE', '1268', 'Carl von Linne', 'Frithiof Kjellberg', 'CPD', '41.787529999999997', '-87.599604999999997', '48', '6', '25');

INSERT ChicagoParksArt VALUES ('UNION', '210', 'Carter Harrison Memorial', 'Frederick Cleveland Hibbard', 'CPD', '41.883035000000000', '-87.665830000000000', '47', '6', '26');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Central Station Fragments', 'Bradford L. Gilbert', 'Metra', '41.867769000000003', '-87.622022999999999', '12', '12', '27');

INSERT ChicagoParksArt VALUES ('"WICKER (CHARLES)"', '214', 'Charles Gustave Wicker', 'Nancy Deborah Wicker', 'CPD', '41.907800000000002', '-87.677171999999999', '100', '6', '28');

INSERT ChicagoParksArt VALUES ('MIDWAY PLAISANCE', '1268', 'Cheney-Goode Memorial', 'South Park Commission Architects', 'CPD', '41.787032000000004', '-87.588329000000002', '116', '6', '29');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Chess Pavillion', 'Boris Gilbertson', 'CPD', '41.911293999999998', '-87.624987000000004', '11', '6', '30');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Chicago Fire Relic', NULL, 'Chicago History Museum', '41.911948000000002', '-87.630737999999994', NULL, '3', '31');

INSERT ChicagoParksArt VALUES ('BURNHAM (DANIEL)', '27', 'Chicago Firefighter/Paramedic Memorial', 'John Alaniz', 'CPD', '41.850698999999999', '-87.609773000000004', '73', '6', '32');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Chicago Stock Exchange Arch', 'Adler & Sullivan', 'Art Institute of Chicago', '41.880647000000003', '-87.621063000000007', '2', '2', '33');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Childrens Fountain', 'Robinson Iron Works', 'CPD', '41.911338000000001', '-87.631426000000005', '110', '6', '34');

INSERT ChicagoParksArt VALUES ('ARRIGO (VICTOR)', '215', 'Christopher Columbus and Fountain', 'Moses Ezekiel', 'CPD', '41.871715999999999', '-87.661359000000004', '99', '6', '35');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Christopher Columbus Monument', 'Carl Brioschi', 'CPD', '41.867927999999999', '-87.619617000000005', '15', '6', '36');

INSERT ChicagoParksArt VALUES ('WARREN (LAURENCE)', '428', 'Circle of Nature', 'Lynn Takata', 'CPD', '42.001990999999997', '-87.688920999999993', '91', '6', '37');

INSERT ChicagoParksArt VALUES ('INDIAN BOUNDARY', '165', 'City Hall Keystone', 'A.C. Goddard', 'CPD', '42.009120000000003', '-87.692188999999999', '1', '6', '38');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'City Hall Relic (Finial)', 'Jenney & Loring', 'CPD', '41.918855999999998', '-87.636106999999996', '69', '6', '39');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Clarence Buckingham Memorial Fountain', 'Marcel Francois Loyau', 'CPD', '41.875796000000001', '-87.618939999999995', '93', '6', '40');

INSERT ChicagoParksArt VALUES ('WARD (A. MONTGOMERY)', '511', 'Commemorative Ground Ring', 'Sheila Klein', 'CPD', '41.893706999999999', '-87.641670000000005', '114', '6', '41');

INSERT ChicagoParksArt VALUES ('CONNORS (WILLIAM)', '1200', 'Connors Park Fountain', 'Teng & Assoc.', 'CPD', '41.898570999999997', '-87.626693000000003', '121', '6', '42');

INSERT ChicagoParksArt VALUES ('GARFIELD (JAMES)', '204', 'Conservatory Entrance Fountain', 'Wolff Clements & Assoc', 'CPD', '41.886276000000002', '-87.716825000000000', '135', '6', '43');

INSERT ChicagoParksArt VALUES ('NORTHERLY ISLAND', '34', 'Copernicus Monument', 'Bronislaw Koniuszy', 'COD', '41.866349000000000', '-87.607788999999997', '13', '5', '44');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Core-Loc Armoring Devices', 'US Army Corps of Engineers', 'CPD', '41.886420999999999', '-87.613163000000000', '125', '6', '45');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Couch Tomb', 'Van Osdel & Baumann', 'CPD', '41.913015000000001', '-87.631691000000004', '126', '6', '46');

INSERT ChicagoParksArt VALUES ('OZ', '423', 'Cowardly Lion', 'John Kearney', 'CPD', '41.920214000000001', '-87.643913999999995', '78', '6', '47');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Cubi VII', 'David Smith', 'Art Institute of Chicago', '41.880322999999997', '-87.623801999999998', '31', '2', '48');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Cummings Playground Art', 'Tom Tischler', 'CPD', '41.920743999999999', '-87.635970999999998', '123', '6', '49');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Curve XXII (I Will)', 'Ellsworth Kelly', 'CPD', '41.926136000000000', '-87.633381000000000', '40', '6', '50');

INSERT ChicagoParksArt VALUES ('NORTHERLY ISLAND', '34', 'Daphne', 'Dessa Kirk', 'CPD', '41.861223000000003', '-87.608221000000000', '35', '6', '51');

INSERT ChicagoParksArt VALUES ('MARQUETTE (JACQUES)', '10', 'Darius & Girenas Memorial', 'Raout Josset', 'CPD', '41.771521999999997', '-87.693731000000000', '105', '6', '52');

INSERT ChicagoParksArt VALUES ('OZ', '423', 'Dorothy and Toto', 'John Kearney', 'CPD', '41.921697000000002', '-87.646216999999993', '78', '6', '53');

INSERT ChicagoParksArt VALUES ('LINCOLN (ABRAHAM)', '100', 'Dr. Jose Rizal', 'Antonio T. Mondejar', 'CPD', '41.967148000000002', '-87.648173999999997', '7', '6', '54');

INSERT ChicagoParksArt VALUES ('KING (MARTIN LUTHER JR.)', '265', 'Dr. Martin Luther King Bust', 'Tina Allen', 'CPD', '41.755820999999997', '-87.654668000000001', '122', '6', '55');

INSERT ChicagoParksArt VALUES ('SUN YAT-SEN', '451', 'Dr. Sun Yat-Sen', NULL, 'CPD', '41.848123000000001', '-87.634523999999999', NULL, '6', '56');

INSERT ChicagoParksArt VALUES ('WASHINGTON (GEORGE)', '21', 'Drexel Fountain', 'Henry Manger', 'COC', '41.801890999999998', '-87.604462999999996', '61', '4', '57');

INSERT ChicagoParksArt VALUES ('JONQUIL', '1270', 'Eagle Columns', 'Richard Hunt', 'CPD', '41.928852999999997', '-87.653940000000006', '107', '6', '58');

INSERT ChicagoParksArt VALUES ('GRANT (ULYSSES)', '24', 'Eagle Fountains', 'Frederick Cleveland Hibbard', 'CPD', '41.875470999999997', '-87.623704000000004', '47', '6', '59');

The table is a list artwork on display at the Chicago Park District. This includes data like the title of the artwork, the artist, the owner of the artwork, the park where it is displayed, and the longitude and latitude.

Details and notes:

Upload both files to Blackboard before you click submit. Do not click submit for the first file, and the separately submit the second file (I will only see the last submission). Do not zip the files together.

Create the tables with good table and column names in camel case.

Pick the appropriate data types and reasonable sizes for each column.

You must include the appropriate primary key, unique, not null, and foreign key constraints.

You do not need to create check constraints.

Assume that all columns that do not currently have nulls in them will never have nulls in them.

You must include all the data in the source table in your database. Do not skip any rows or columns.

The integer columns in the table are all surrogate keys.

Do not use INDENTITY for this assignment. Trust me, it's much easier this way.

Lorado Taft is a famous artist.

Most of this artwork is owned by the Chicago Park District or the City of Chicago.

Be sure to clearly mark each step in your script with a comment. For example:

 -------------------------- -- Step #1 -------------------------- 

I should be able to run you entire script repeatedly by pressing the F5 key. Be sure to test this.

Do not include a USE, CREATE DATABASE, or DROP DATABASE command in your script.

Part I - Entity Relationship Diagram

Using MS Visio, create an ERD for your normalized database (3NF) named usrNNYourNameLab05.vsdx. Include all the features we learned up to chapter 6.

Part II - SQL Script

Create an SQL script named usrNNYourNameLab05.sql to create your database. You script should both create the tables themselves and insert the rows in the tables. This will be very similar to steps 1 through 4 in last week's assignment.

Step 0 - Header

Include an appropriate header at the top of the script. This should include the name of the file, your name, due date, assignment name, and a two or three sentence description of the file.

Step 1 - Drop Objects

If any of the objects for this database already exist you must drop them first. Be sure to drop them in the correct order. Use the IF EXISTS command to prevent an error if the object does not exist already.

Step 2 - Create Tables

Create the tables and primary keys. You must use CREATE TABLE statements. Do not use SELECT... INTO.... You may create the primary keys when you create the tables, or do it as a separate step. Use Camel Case for both the table and column names (as this is the standard in SQL Server). Use the correct data type (from the ones we learned in class) for each column.

Step 3 - Create Foreign Key

Add the appropriate foreign keys to the database.

Step 4 - Insert Rows

Insert the rows from the diagram into the database. Be sure to insert the rows in the correct order. I strongly suggest you use the data from the denormalized table rather than hard coding the values into your insert statements.