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

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

Transcribed Image Text:

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. 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.