IS315_2_Homework3

IS 315 Analysis and Design Techniques

Homework Assignment 3

Bebop Records

Bebop Records is a mail order company that distributes CDs and tapes at discount prices to record club members.

A customer mails in an order.

When an order processing clerk receives an order form, she verifies that the sender is already a club member by checking the MEMBERS FILE.

If the sender is not a member, the clerk returns the order along with a membership application form.

If the customer is a member, the clerk verifies all of the order item data by checking the INVENTORY FILE. Then the clerk enters all the order and order item data and saves it to the ORDERS FILE and the ORDER ITEMS FILE. At the same time the clerk also prints an invoice and shipping list for each order, which are forwarded to the ORDER FULFILLMENT DEPARTMENT for processing there.

Using the Origin Level Data Flow Diagram for Bebop Records that we created and discussed in our second class on Wednesday, June 18th, create the following Data Dictionary entries for the following items:

Data Flows Invoice

Elements All the elements, including group levels, that constitute the Invoice data flow

Data Stores Member File

External Entities Order Fulfillment Department

For your information, the invoice contains the following fields:

Order number

Date of Order

Ordered by (name and address)

Ship to (name and address)

Ship via

Payment terms

Several line items:

Quantity

Item number

Item name

Price per item

Line total

Invoice subtotal

Discounts

Taxes

Shipping charges

Invoice total

Assignment clarification:

What I would like you to do is decompose 'Invoice' to show its structure using an '=' sign and '+' signs as I demonstrated in class. This should reveal all the fields within invoice, some of which will ALSO be group level fields. Those groups should separately be decomposed diagramatically in the same fashion until all the elemental fields in invoice have been identified.

Then please provide a definition for ANY 6 of those elements using only four of the factors that the book suggests for defining an element: name, alternate name, type & length, & acceptable values. Please make up definition information that is not provided, trying to be realistic.

Define the Data Store and External Entity as described in class and in the text book (page 172).

This assignment is due at the beginning of class on Monday, June 30, 2003 and should be turned in as hardcopy or sent to the instructor at jbernste@condor.depaul.edu as an email or attachment to an email provided it is received in time. However, please do NOT turn in a floppy disk or other PC storage media.