Title: Process Diagram for Sally
1Process Diagram for Sallys Bookstore (as written)
Operate the bookstore
Order Books
Sell Books
Print Suggested Orders
Review Qty on Hand
Manage Customer Information
Process Sales Transactions
2ERD for Sallys Bookstore (as written)
Category
Is interested in
Is in
Makes/Is for
Is for
Book
Customer
Transaction
- Business Rules (Assumptions)
- Customers could buy more than one book in a
transaction - Books are supplied by only one supplier
- Books are in only one category but a customer
could like more than one category
Comes from
Supplier
Abbreviated Dictionary Customer Cust-ID, Name,
etc. Transaction Cust-ID, Book-ID, Date,
Qty Book Book-ID, Title, Author, Date,
Supplier-ID, Cat-ID, EOQ, Qty on Hand, Reorder
Qty Supplier Supplier-ID, Name, etc. Category
Cat-ID, name
3DFD for Sallys Bookstore (as written)
Enter new customer info
Customer
New Customer info
Books to buy
Books to buy
Phone number
Process the transaction
Customer Info
receipt
Display past history
Verify phone number
Customer
Customer
price
Transaction data
Quantity sold info
category
Customer
Transactions
Transactions
Books
Qty on hand, EOQ
Books to be ordered information
Requirement Report
Print suggested orders
Determine order requirements
Sally
Supplier