Database Reference
In-Depth Information
EXERCISES
339
1. Discuss the effect of the following changes on the design for the Marvel College requirements:
a. More than one instructor might teach a given section of a course, and each instructor must
be listed on the time schedule.
b. Each department offers only a single major.
c. Each department offers only a single major, and each faculty member can advise students
only in the major that is offered by the department to which the faculty member is assigned.
d. Each department offers only a single major, and each faculty member can advise students
only in the major that is offered by the department to which the faculty member is assigned.
In addition, a student can have only one major.
e. There is an additional transaction requirement: given a student
'
s name, find the student
'
s
number.
f. More than one faculty member can be assigned to one office.
g. The number of credits earned in a particular course cannot vary from student to student or
from semester to semester.
h. Instead of a course number, course codes are used to uniquely identify courses. (In other
words, department numbers are no longer required for this purpose.) However, it is still
important to know which courses are offered by which departments.
i. On the registration request form, a student may designate a number of alternates along with
his or her primary choice. These alternates are listed in priority order, with the first one
being the most desired and the last one being the least desired.
2. Complete an information-level design for Holt Distributors.
General description. Holt Distributors buys products from its vendors and sells those pro-
ducts to its customers. The Holt Distributors operation is divided into territories. Each customer
is represented by a single sales rep, who must be assigned to the territory in which the customer
is located. Although each sales rep is assigned to a single territory, more than one sales rep can
be assigned to the same territory.
When a customer places an order, the computer assigns the order the next available order
number. The data entry clerk enters the customer number, the customer purchase order
(PO) number, and the date. (Customers can place orders by submitting a PO, in which case, a
PO number is recorded.) For each part that is ordered, the clerk enters the part number, quan-
tity, and quoted price. (When it is time for the clerk to enter the quoted price, the computer
displays the price from the master price list. If the quoted price is the same as the actual price,
the clerk takes no special action. If not, the clerk enters the quoted price.)
When the clerk completes the order, the system prints the order acknowledgment/picking
list form shown in Figure A-18 and sends it to the customer for confirmation and payment.
When Holt Distributors is ready to ship the customer
'
s order, this same form is used to
pick
the merchandise in the warehouse and prepare it for delivery.
Search WWH ::




Custom Search