Deleting a record for a job with ID 7 in JobClient table would also remove all the
information on __.
In SQL Query Analyzer, the statement used to show all client emails and contacts for
whom jobs have been done, would be __.
Plymouth Car Rental started with two compact cars and has expanded its fleet of
vehicles with several sedans and trucks. When a customer books a rental, his/her age
has to be at least 18 for compact cars and sedans, which are rented by the day and must
be returned the following morning by 11 AM. Trucks are rented for a maximum of six
hours. The owner requires a deposit on the reservation to be paid within seven days of
booking. Vehicle records consist of the makes and types (Honda sedan), color, seating
capacity, required deposit, rental rate and rental limit (in hours). Customer data consists
of customer's names, addresses, phone numbers, and birth dates. Bookings identify the
customer, vehicle, as well as the time rented and returned. There can be several
payments up until the reservation date. Payments must reflect the payment status for
each booking, including deposit, when the deposit was made, then each of the payments
made, and when the entire payment was completed.
For questions 82"85, please refer to the preceding paragraph.
Complete the design of the customer table in an Oracle database using appropriate SQL
script. Make sure to indicate which of the fields is the primary key.