The relationship between employee and job tables is __.
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 A.M. 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-86, please refer to the preceding paragraph.
Design the query that retrieves customer names, addresses, and birth dates, born after
1/1/1970, and from zip codes 03223 and 03264.
Hardware components of a network include __.
A long distance phone number stored in __ data type would need at least __ characters.
Describe how the order table is related to all the other tables in the database.
The network, hardware, software and __ are four typical organizational system
components.
Creating a table structure In Microsoft SQL Server is done in __ view.
For years, QuickTax, Inc. has helped small businesses manage their taxes. The
management wants a database to keep track of clients, employees, and jobs. Managers
need to keep track of client names, addresses, contact persons, phone numbers, and
email addresses. They also need to track the employee’s social security numbers, names,
and birth dates. Also, the company needs to be able to keep track of the data on each job
an employee performs for each of their clients.
For questions 72 – 81, please refer to the preceding paragraph.
Table representing jobs is an example of a(n) __ table.
Describe 1NF violation and how to redesign the table to correct it.
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.
In Microsoft Access, an invalid entry error text message for a particular field, can be
specified in __ field property.