In Microsoft SQL Server, __ are constraints that can be applied to restrict values in a
column.
In Oracle, the statement used to retrieve all of the client’s contacts and emails would be
__.
In Oracle, 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 __.
In Microsoft Access, the statement used to retrieve client’s contacts with emails ending
in “net”, would be __ .
In SQL Query Analyzer, the statement used to retrieve client’s contacts with emails
ending in “net”, and from area code 603, would be __.
The data source will be altered by writing an appropriate SQL statement under _ tab.
Employee table is a __ table and job table is a __ table.
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. In addition, each of the consultants
(employees) has a senior consultant as a mentor to help with some of the more
challenging jobs and to evaluate employee’s performance. In turn, a particular employee
(consultant) that has a senior employee as a mentor, can be a mentor himself to a more
junior employee. Further, each of the jobs the company deals with has some things that
are in common, starting with ID, date/time started/ended, and so forth. Also, there are
some tax forms that must be filed with every client, regardless of specifics of a business
situation. On the other hand, there are some specific forms that apply to certain types of
business situations, but are different or simply not required for other clients.
For questions 72-81, please refer to the preceding paragraph.
The recursive relationship between consultant mentors and mentored has a __
cardinality.
Tables are graphically represented as __ in an ER diagram.
In equipment supertype and computer subtype example, the computer subtype is said to
__ all the attributes of the equipment supertype.
In Oracle, the script line used to define the foreign key in job table, creating a
relationship with client table, would be: __.
Design the query that will calculate total revenue for each of the flower groups, labeled
as “Total Revenue”.
Microsoft Access database files have a(n) __ extension.
According to the paragraph, client table will have the following data items: _.
Complete the design of the order table in an Oracle database using appropriate SQL
script. Assume that any necessary parent tables have been created. Make sure to
indicate which of the fields is the primary key and which fields are the foreign keys.
Design the query that retrieves all the customer names and phone numbers, only for the
customers born in the 1960’s, that made the reservations between 7/1/06 and 7/15/06,
sorted by rental date.
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.
Describe 1NF violation and how to redesign the table to correct it.