Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
The lack of foreign keys is seen as an __ of normalized designs.
ASP.NET application is tested by viewing it in a __.
The first step in configuring the GridView control is to __.
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.
Draw each of the tables with the appropriate table name.
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 60-81, please refer to the preceding paragraph.
In SQL Query Analyzer, the statement used to retrieve all of the data from the employee
table would be __.
Relational databases achieve a high degree of data independence by deriving _ from
base table in order to protect those tables from the end user.
__ operation retrieves a subset of rows.
Create the query that calculates the "Average Time to Delivery" from lowest to highest,
grouped by supplier, and only for the flowers delivered in good condition.
In Oracle, previously executed scripts during the current session can be viewed using _
link.
The initial step in configuring an SqlDataSource for qtax SQL Server database is to
create a new __.
A children table without a reference to a parent table is called a(n) __.
In Microsoft Access, the statement used to retrieve all of the client's names, sorted A to
Z, with city, state, and zip code would be __.
__ operation combines data from two tables.
The primary key of the parent table must be defined __ the foreign key in a child table.
