Transcript test answers - DePaul University

Prepare for Final
1-3. Perfect Pizza wants to install a system to record orders for pizza and
calzones. When regular customers call Perfect Pizza on the phone, they are
asked their phone number. When the phone number is typed into a computer, the
name, address, phone number and last order is displayed. If the name is not
found the person will enter the information. Once the order is taken the total
including tax and delivery is calculated. Then the order is given to the cook. A
receipt is printed. Occasionally, special offers (coupons) are printed so the
customer can get a discount. Drivers who make the deliver give the customer a
copy of the receipt and coupon. Weekly totals are kept for comparison with last
year's performance.
1. Draw a context diagram
2. Draw a level one DFD
3. Draw an ERD and list any assumptions
Prepare for Final
From the attached invoice draw an ERD Diagram
Order No. 61384
Customer No: 1234
Name: David Lee
Address: 615 S. Quincy
City, St, Zip: Hinsdale, IL, 60521
Order Date: 03/12/99
Promise Date: 03/19/99
Order Process Site: 123 New York
Product
ABC
456
Description
Books
Cheese
Order Allowance
Pick up allowance 2% - 1000
Good customer
4000
Invoice Total 45,000
Quantity Price
2000
1500
20000.00
30000.00
Prepare for final
A commercial bakery makes many different products (each from several
ingredients.) These products include breads, desserts, specialty cakes, and
many other baked goods. Ingredients that are used in many products - such
as flower, spices, milk - are purchased from several vendors. Sometimes
many ingredients are purchased from a single vendor (sometimes in the same
order), and other times a single ingredient may be purchased from many
vendors. The bakery has commercial customers, such as schools and
restaurants, that regularly place orders for several types of baked goods
(sometimes in the same order.)
Draw a stable ER Diagram. Please draw the entities and their keys. Don't
bother indicating non-key attributes. Create additional entities that you
need to stabilize or complete the diagram, but don't imagine other entities
that are not part of the situation.
Fast Food Restaurant
Orders
Orders status
Customer
Kitchen
Fast
Food
System
Receipt
Manager
Weekly Sales
Delivery info
Orders
Delivery
Person
Fast Food Restaurant
Cust info
Customer info
Cust info
Customer
Process
Cust
Call
Cust #
Kitchen
Processed
Orders
Order info
Customer
order
Confirmation
Prepare
Orders
New Cust
order
Last Cust
order
Customer orders
Order info
Order info
Calc
Unprocessed
orders
FInal order
Bill
Receipt& Coupons
Delivery
Person
Prepare
Orders for
Delivery
Orders ready for
delivery
Gen
Rpts
Sales Info
Manager
Fast Food Restaurant ERD
Order
Order # (PK)
Phone # (FK)
Date
Taxes
Delivery stat
Time entered
Time promised
Customer
Phone # (PK)
Name
Address info
Customer
Makes
Orders
Orders
have
many items
Order Items
Item # (PK)
Order #(PK)
Quantity
items
one set of attributes
has
Coupon
Coupon # (PK)
Description
Amount
Type
Coupon/Order
Coupon # (PK)
Order (PK)
in
Items
Item # (PK)
Description
Price
Ingredients1
Ingredients2
Size
Cost
Order Management ERD
Customer
Cust # (PK)
Name
City
State
Zip
Good cust
Order
Order # (PK)
Cust # (FK)
Order Date
Promise Date
Order Site
Customer
Makes
Orders
has
Allowance
Allown # (PK)
Description
Discount %
Allowance
Order# (PK)
Allow # (PK)
Amount
in
Orders
have
many items
Order Items
Item # (PK)
Order #(PK)
Quantity
ha
s
Items
Item # (PK)
Description
Price
Unit of Measure
Bakery ERD
Customer
Cust # (PK)
Name
City
State
Zip
Ingredients
Ingr Id # (PK)
Description
Provided
Makes
Has
Order
Order # (PK)
Cust # (FK)
Order Date
Prod Ingr
Prod Id# (PK)
Ingr Id# (PK)
Sup Ing
Ingr Id # (PK)
have
ha
s
has
Supplier
Sup Id # (PK)
has
Order Items
Order # (PK)
Item # (PK)
Quantity
Product
Product #(PK)
Description
Price
Unit of Measure
1. Store item to store iteme
Good Sold File
Sold data
Sold data
Inventory
6. Process box #
4. No input to the
process
2. No labels
10. External to external
8. No labels
Customer
Students
Student Data
9. No data store name
Inventory Data
40
Update
Inventory
Inventory Data
3. Same data flow
different names
5. External to store
7. No labels
3.0
Creates
Reports
3.0
Produce
Mgmt
Reports
11. Reversing
errors with no labels
Inventory
12. No labels
Manager
Management Reports