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 10:30, robert7248

You have a large, late-model pick-up truck with a rear seat. the pick-up truck weighs 6,500 pounds. the florida seat belt law

Answers: 1

continue

Computers and Technology, 23.06.2019 09:30, cdavis379

:you areto design the controller for alight that functions both as an ordinary light and also as a motion activated light and alarm. a. if the manual switch s is on, then the light l is on. b. besides the manual switch, there is a motion detector, m1, which activatesthis light. c.if motion is detected but the light is on anyway because s is on, only then a secondoutput a, an alarm, is turned on. d. the disable switch, d, disables the motion activated light and alarmbut leaves manual control operation of the light using switch s.(i)read the problem statement and clearly identify the inputs and outputs for the circuit you are designing. (ii)create the truth table for this system; include the light, alarm, switch, disable, and the motion sensor.(iii)draw a schematic of this system.

Answers: 1

continue

Computers and Technology, 24.06.2019 20:30, glstephens04

How is energy expended in active transport

Answers: 1

continue

Computers and Technology, 25.06.2019 16:00, Onlytrillest

|the entire hostname has a maximum of

Answers: 1

continue

Do you know the correct answer?

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