Question: how can i make a relation model according to this E-R diagram and write an sql diagram according to it having these requirements a. Report

how can i make a relation model according to this E-R diagram and write an sql diagram according to it having these requirements a. Report the IDs of cars with model year 2012 and up. b. Report the total car sales amount between 2012 and 2021. c. Report the IDs and names of customers who have rented more than seven cars between 2010 and 2020. Sort the results by the alphabetical order of names. d. Report the color and selling price of all VW, Mercedes Benz, and BMW cars in the dealership.

( Customer 10.M can be rental_date 2 Registered custome

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!

Imagine that you are charged with building a knowledge-based system for a car insurance company. Car insurance companies use quite complex grids (we could say rule sets, or knowledge bases) to...

As pollution is increasing, som large cities have started a project called car sharing to reduce the number of cars in the city and also reduce the cost of having a car available when needed by a...

ISDS 3110: Data and Information Management LAB 4: Joining Tables SQL Queries In this lab, you will be querying the text schema on the MySQL server. The required tables are person and car. One person...

This assignment aims to develop a broad knowledge of storing and managing data to satisfy the organizational requirements. These will be reinforced by developing the practical skills required for...

Course Management Information Systems H3 School School of Management Class BACHELOR business administration CONTENT MIS design for Library Management Information Systems (LMIS) 1. Step 1: Textual...

I want an electronic drawing of the ER diagram, & MAP diagram, & code SQL , and a screenshot of the output and this data below ER Diagram: [Customer(Customer ID, Name, Phone, City)] --[Has...

If 12.39 g of Urea (CN_(2)OH_(4)) are produced when 8.87 g of Ammonia react completely with Carbon dioxide gas, what is the percent yield for this reaction? 2NH_(3)(g) + CO_(2)(g) CN_(2)OH_(4)(s) +...

Needing help with this project anything is appreciated. The model with the relationships is throwing me through a loop. Thanks Database Project Part 1: 150 points Due: See Canvas for Due Dates...

the following relational algebra questions based on tables S1 and S2 (below) Question 1 What is the output of S1 S2 ? The row identified by sid 22 The rows identified by sid 31 and 58 The row...

SIT103 Data and Information Management T2, 2023 Summative assessment task-2: A real-world database design and implementation project Due dates: Part-1: Project proposal, due date: Wednesday 10th May...

What type of ion exchange resin and what buffer pH would you use to purify pepsin from an extract of pig cells? (Assume that pepsin should bind to the column resin). Anion exchanger at pH less than 3...

Return to the Yummy, Inc., data in Short Exercise 13-3. Assume instead that the December 15, 2012 stock dividend was 45%. Requirements 1. Journalize the stock dividend. 2. How many shares of common...

Take a moment to read some of the research and news articles that Akshay has been reading. What might he infer about ESG investing? ESG investment strategies eliminate entire sectors ESG is valuo -...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

a. How will the leader be selected?

4. Trust develops with shared experience, values, give-and-take, and the result of human communication. Satellites, electronic mail, and networks could reduce the dimensions of trust to which we are...

1. Opportunities for face-to-face contact will be diminished, and information from nonverbal cues will be reduced. Consequently, opportunities for random spontaneous information sharing will be...