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.
JobClient table design is referred to as __ design.
Each record in a table is uniquely identified by a __.
Creating a table structure in Microsoft Access is done in __ view.
In SQL Query Analyzer, the statement used to retrieve all of the client’s names, sorted A
to Z, with city, state, and zip code would be __.
Jerry, the owner of Exotic Flower Inc., built a small greenhouse to store several types of
exotic flowers that he purchases from wholesale suppliers around the world. Each
exotic flower Jerry buys and resells falls into one of several flower groups that differ
with respect to their storage needs, duration, time in bloom, price, etc. Each of the
orders placed by customers specifies the type of exotic flower, the supplier it came
from, the date of order, expected delivery date, flower condition on delivery, as well as
the quantity ordered. Customer’s data contain all the standard information needed to
collect payment and deliver the flowers.
For questions 87-91, please refer to the preceding paragraph.
Design the query that retrieves flower group and price for flowers that have any kind of
sun storage need.
In Microsoft Access, Validation rule restricting pay rate field entries to be between 10
and 15 dollars per hour, would be specified as __.
Discuss how the violation of 3NF might potentially occur in this example.
Draw the appropriate server control that will allow you to display the flower data and
describe the steps needed for proper configuration.
Using the above paragraph, list all the fields in the vehicle table. What would you use
for a primary key?
In Microsoft Access datasheet view of Employee table, the + sign in front of every
employee record may be clicked on to show __.
Describe the nature of supertype/subtype hierarchy in this case (if any) and discuss how
it would be modeled in the ER diagram for this database.
A relationship where one record in a primary table corresponds to one record in another
table is called __ relationship.
In Microsoft Access, the statement used to retrieve all of the data from the employee
table would be ____.
