Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
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