Computers and Technology, 02.04.2021 19:40 j1theking18

Given the following database schema for a rental car business. Use SQL to express each of the following queries using a minimum number of operations and tables: CARS= ( Plate Number, Make, Rate, Status) Status= available or null( rented out)
Rate is the daily charge.
Customer=( Ful Name, PhoneNumber, DLNumber, CreditCardNumber)
RentalTranscation= ( TranscationNumber, FullName, PlateNumber, PickUpDate, ReturnDate)
ReturnDate may assume the value null if it hasn’t been returned
Delete any customer from the customer table who does not has a phone number
Update the table CAR by increasing the rate of each Ford car by 20%( the Ford represents the car’s make).
List the PlateNumber and the total revenue. Note that the revenue of a single rental transaction = ( ReturnDate-PickUpDate) *Rate
List the full name who rented out every car (all calls) which has rate <= 10 dollar.

Answers: 2

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 20:00, jayjay5246

What is the term for water wave that is created by an underwater earthquake

Answers: 1

continue

Computers and Technology, 23.06.2019 13:00, alexacarillo

In excel - calculate the actual increase/decrease from first quarter to the second quarter then subtract subtract first quarter value from second quarter total then divide result by first quarter value

Answers: 1

continue

Computers and Technology, 23.06.2019 13:50, mrfishyyyy

Explain how email technologies enable the exchange of messages between users. find out the typical parts of an email address and explain each part.

Answers: 1

continue

Computers and Technology, 23.06.2019 18:50, ana7496

What is transmission control protocol/internet protocol (tcp/ip)? software that prevents direct communication between a sending and receiving computer and is used to monitor packets for security reasons a standard that specifies the format of data as well as the rules to be followed during transmission a simple network protocol that allows the transfer of files between two computers on the internet a standard internet protocol that provides the technical foundation for the public internet as well as for large numbers of private networks

Answers: 2

continue

You know the right answer?

Given the following database schema for a rental car business. Use SQL to express each of the follow...