Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Dealer(DealerID, Name, Address, City, Phone, TaxID, Comments) Booth(BoothID, BoothNo, Area, Location, color, Price, Status, Commission) Sales_Dealer_Booth(DealerID, BoothID, DealerRent, Date_of_rent) Implement and populate the database by
Dealer(DealerID, Name, Address, City, Phone, TaxID, Comments) Booth(BoothID, BoothNo, Area, Location, color, Price, Status, Commission) Sales_Dealer_Booth(DealerID, BoothID, DealerRent, Date_of_rent) 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. *Note: SQL syntax is written and saved in a text editor application (e.g., Notepad) and will be submitted as a separate file. Combine both the CREATE TABLES and INSERT INTO VALUES script into one text file (.txt) and make sure the script can be executed together without any errors
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started