Question: I have attached the diagram below. Please answer all 5 questions in Microsoft SQL . Project Part 2 You should create SQL tables for the

I have attached the diagram below. Please answer all 5 questions in Microsoft SQL

Project Part 2 You should create SQL tables for the above scenariousing your NER Diagram & create at least 10 dummy records for

Project Part 2 You should create SQL tables for the above scenario using your NER Diagram & create at least 10 dummy records for each table. Remember, you must create the all the dummy records in the tables by writing SQL queries. You should be able to retrieve the appropriate data for the following questions by joining appropriate tables using SQL commands. 1. The Model of each vacuum along with its price 2. The number of Vacuums that were manufactured after 2010 3. The name of the technician who has inspected the most number of vacuums 4. List the vacuum models which were graded with an average along with its verification date. 5. The serial number of each vacuum along with its designer's name & technician's name.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!