Implement and populate the database by using your knowledge of SQL DDL. Reference the 3NF entities from previous steps as a guide to define the properties and structure in SQL syntax. Enforce referential integrity by defining PK/FK constraints in the SQL script. Include 15 dummy records for each table. This dummy data should be well thought out as you will be using the data to run specific queries that will demonstrate that the database has resolved the issues at NHD.

Figure 2 illustrates the map of the various spaces leased to dealers. Currently this is kept on paper and is used to determine which booths are leased or vacant. In addition, to this form, Lisa needs to keep up with the booth's location (outside perimeter, insider perimeter, or aisle), its color (green, tan, yellow, Figure 1 is used to obtain information about dealers. Be certain that each dealer is uniquely identified. or white), which dealer rents the booth (or which booths are vacant), and wheher the booth has rafters above it or and carpeting It may be necessary to determine and create a unique identifier is one is not found on the form. A-16 A-15 A-14 A-13 A-12 A-11 A-10 A-09 A-08 A-07 12x8 12x8 12x10 12x10 12x 18 12x18 2x 10 12x10 12x10 12x12 $175 $175 $230 $230 $310 $310 $230 $230 $230 $290 A-17 A-06 12x8 12x18 $175 B-12 B-11 B-10 B-09 B-08 B-07 B-06 $310 NHD 8x12 8x12 8x 10 8x 10 8x 10 8x8 18x8 A-18 $175 $175 $120 $120 $120 $105 $105 A-05 12x12 C06 B-05 12x12 Memories Antique Mall $290 B-13 2-13 C-12 $290 8x12 8x16 8x16 $105 A-04 Dealer Information Form 175 $150 $ 150 COZ COA B-04 12x12 8 x8 8x8 8x8 $290 Name: Marcia Tyler A-19 $90 $90 2x 18 $105 A.03 $310 B-14 C-14 8x8 COB COR B-03 12x12 Address: 9800 Harbor Lane 8x10 8x20 BXR 8x8 3x10 $290 $120 $200 $90 $90 $90 $120 C-09 CO2 B-02 A-02 City: Cleveland State: IN ZIP: 37364 AXE 8x8 8x 10 12x18 A-20 B-15 C-15 Front $90 $90 $120 $310 Phone: (423) 890-8788 Cell Phone: (423) 645-8900 2x18 8x10 8x20 Counter C.TO CO BOT $310 $120 $200 8x8 8x8 8x10 Tax ID: 34 -5690654 $90 $90 $120 A-01 12 x18 Comments: Call cell phone first. Up to 15% discount is approved. $310 Figure 1: Dealer Information Form Figure 2: Map of the Selected Mall Page 2