DATABASE SYSTEMS

1) Using the FoodInspection table we reviewed in class (see image below), normalize the table into second normal form and create the 2NF dependency diagram and identify any transitive dependencies. (20 points) 1 Business rules * Each business has one or more inspections. * Each inspection has zero or more violations. 5 0 0 0 eliminates the transitive dependencies and create the 3NF dependency diagram. (25 points extra credit) Data source: Municipality of Anchorage Open Data Portal - Restaurant and Food Inspections FA0000108 STH AVENUE DELI 320 WSTH AVE 410 ANCHORAGE AK FA0C00108 STH AVENUE DELI 320 W5TH AVE 410 ANCHORAGE A FA0000108 STH AVENUE DEL 320 W STH AVE 410 ANCHORAGE AK FA0000108 STH AVENUE DELI 320 W 5TH AVE 410 ANCHORAGEA FA0000108 STH AVENUE DEL 320 W STH AVE 410 ANCHORAGEAK FA0000108 STH AVENUE DELI 320 W STH AVE 410 ANCHORAGEA FA0C00108 STH AVENUE DEL 320 W STH AVE 410 ANCHORAGE AK FA0000108 STH AVENUE DELI 320 W STH AVE 410 ANCHORAGEA FA0000108 STH AVENUE DELI 320 W 5TH AVE 410 ANCHORAGEA FA0000108 STH AVENUE DEL 320 W 5TH AVE 410 ANCHORAGE AK FA0000108 STH AVENUE DELI 320 W 5TH AVE 410 ANCHORAGEA FA0000108 STH AVENUE DELI 320 W 5TH AVE 410 ANCHORAGEA FA0000108 STH AVENUE DELI 320 WSTH AVE 410 ANCHORAGE AK FA0000108 STH AVENUE DELI 320 W 5TH AVE 410 ANCHORAGEAK FA0000108 STH AVENUE DELI 320 W5TH AVE 410 ANCHORAGE A FA0000108 STH AVENUE DELI 320 W5TH AVE 410 ANCHORAGEAK FA0000108 STH AVENUE DEL 320 W 5TH AVE 410 ANCHORAGEAK Change of Owners V1301762 01 FOCD FROM APPRO Change of Owners,'V1301763 14 FOOOCONTACTSUR'14 FA0000108 STH AVENUE DELI 320 W 5TH AVE 410 ANCHORAGEA FA0000108 STH AVENUE DELI 320 W5TH AVE 410 ANCHORAGEA FA0000108 STH AVENUE DELI 320 W5TH AVE 410 ANCHORAGEAK FA0000108 STH AVENUE DELI 320 W5TH AVE 410 ANCHORAGEAK FA0000108 STH AVENUE DELI 320 W 5TH AVE 410 ANCIORAGEA FA0010784 12-ICO) COFFEE & C 12100 OLD SEWARDIANOCRACE AK