__ field in the client table would most likely be the largest field in terms of size.
For years, QuickTax, Inc has helped small business manage their taxes. The
management has 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 employees’ 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.
In a QuickTax database, all the information related to jobs would be stored in a _.
If we could have a client with two tax returns that have an identical general portion and
different specialized portion, this would be an example of the __.
The Internet uses a set of protocols called __.
Discuss how the violation of 4NF might potentially occur in this example.
Specialized type of computers processing requests and returning results are called __.
The most appropriate data type for employee’s birth date would be __.
In Microsoft Access, from the standpoint of a user entering data into the client table, the
most efficient way of implementing State field would be using __.
Interaction with the ASP page in the main window of Web Developer can occur in __
view and __ view.
Jerry, the owner of Exotic Flower’s 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 86-89, 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 flower database is
available on SQL Server.
Design the query that calculates which flower groups are ordered the most, displayed as
“Best Sellers”, and display them from highest to the lowest, including their price.
According to the above paragraph, describe how a typical transaction might occur.
Relational databases use __ links between related tables, whereas network databases
use _physical_ links between related tables.
A server control used to display data in a form of a table is called the _.