Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION 18 A database includes information about manufacture data of automobiles. Consider the following two relation schemas. AUTOS: Each model name (model) is the primary

image text in transcribed

QUESTION 18 A database includes information about manufacture data of automobiles. Consider the following two relation schemas. AUTOS: Each model name (model) is the primary key of Auros. Each maker (maker name) may produce one or more different models, indicated in the Autos table. For Example: ('Mustang', "Ford") . ('Focus', 'Ford) ('Dart', 'Dodge") ('Caravan', 'Dodge') PRODUCTION: The combined model name (model) and year (year) is the primary key for the PRODUCTION table. The model name (model) is a foreign key that references AUTOS.Model. The number of units manufactured (units_made) of each model is noted for each year (vear) in the PRODUCTION table. AUTOS Model Maker_name PRODUCTION Model Year Units made Write two different SQL queries: (a) Write a SQL query that displays the maker_name and number of different models produced by each maker. (b) Write a SQL query that displays the maker_name and total number of units manufactured for each maker whose overall total production is more than 10000 units (.e. exclude small auto manufacturers who have not yet produced more than 10000 vehicles in their entire history). Arial 3 (12pt) E-T- TT TT Paragraph v T T 351 S fx Mashups - 146 3. HTML CSS

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

Students also viewed these Databases questions