Answered step by step
Verified Expert Solution
Link Copied!

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

imageimage

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Precalculus

Authors: Jay Abramson

1st Edition

1938168348, 978-1938168345

More Books

Students also viewed these Databases questions

Question

What are types of firms that exemplify monopolistic competition?

Answered: 1 week ago