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.