A primary key __ identifies each record in a table.
A set of different information technologies comprises a company’s _.
If client’s type (based on ownership, for example) was determining the type of
specialized portion of tax returns, this field would be called a ___.
In Microsoft Access, the statement used to display client emails and contacts, together
with job dates and times from 3/13/06 to 3/15/06, would be __.
Exposures is a specialty retailer of fine gifts, picture frames, albums, scrapbooks, as
well as occasional gift ideas. Visit their Web site at www.exposureonline.com, and
using the registration, billing, catalog, and shopping cart screens below, go through
each of the five ER design steps.
List all the entities in Exposures database and describe their relationships with other
entities.
For the columns that are checked off in the process of creating an Insert statement, __
cells associated with them appear in the query grid.
In the JobClient table, JobID-ClientID is not a determinant because of the resulting
ambiguity in the __ field.
Plymouth Car Rental (PCR) 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-85, please refer to the preceding paragraph.
Draw the appropriate server control and describe the steps of creating the new
connection and selecting the appropriate server provider, assuming rental database is
available on SQL Server.
In SQL Query Analyzer, the statement used to retrieve all of the client’s contacts and
emails would be __.
The behavior of controls, such as what happens when a button is clicked, is specified by
__.
ER diagrams make it much easier to understand the __ among entities in the database.
In a parent/child relationship, the crow’s foot always points toward the __ table.
Discuss how the violation of 4NF might potentially occur in this example.