MIS (management information system) homework i need help

MIS

0: Business Systems Analysis

PS #

1/11, 2013)

Part A: Data Flow Diagram

Using a summary of the six business activities for Perfect Pizza as follows, create (1) a
Context diagram
for Perfect Pizza and (2)
Level 0 diagram
, which is the detailed DFD exploded from the context diagram. (

4

0 points).

1. Display customer record. Input is the customer number and the customer record. Output is customer information.

2. Take customer order. Input is the order information (including the customer number). Output is the total amount due for the order.

3. Print customer receipt. Input is the customer order and the customer master record. Output is the customer receipt.

4. Deliver customer order. Input is the customer receipt and coupons. Output is the delivered receipt to the customer.

5. Send order to cook. Input is the customer order. Output is the cook’s order.

6

. Print weekly totals. Input is the customer order and the previous year’s customer order summary. Output is the weekly performance figures.

Part B: Decision Table and Decision Tree

(1) Show the finalized complete and reduced decision table using the following table (20 points).

Y

Y

Y

Y

Y

Y

N

N

Y

Y

Y

Y

N

N

—

Y

N

Y

N

Y

—

X

X

X

X

X

X

X

X

X

X

(2) Using the finalized decision table in Part B, show the decision tree (20 points).

Part C: Database Design

Explain three different types of normalization (1NF, 2NF, and 3NF) based on their assumptions and requirements within one page. (20 points)