1. Read the following scenario and explain to the owner and to the clerks the differences between logical and physical modeling. When and why would anyone use each? Remember, users and managers each have different perspectives, needs, and concerns.
Smalltown Hardware and Home Improvement (yes, headquartered in Smalltown, Arkansas!) is expanding beyond the owner’s wildest dreams. She has hired a small consulting company by the name (Primo) to analyze the need for a new system. Things have been stressed between her and the consulting company since the consulting company started working with her because she says the staff at Primo keep using this “tech” languages and diagrams that she doesn’t understand. Further, she feels that Primo keep ignoring “how” she does things, instead, only focusing on “what” she does. She wants the consulting company to improve how she does things – she knows what she does. Since the consulting company (Primo) are about to present DFDs to both the owner and to the store clerks, Primo know that they need to address some issues now..
2. Read the following scenario. Create a list of the entities and level-0 processes for the Data Flow Diagram. Also, create a list of the entities and their primary keys for the Entity Relationship Diagram.
The Smalltown Music & Video Company (you guessed it – headquartered in Smalltown, Arkansas!) advertises in a variety of magazines. Most orders are submitted by magazine subscribers who complete and send coupons to the mail order company. All mail arrives at the receptionist’s desk. The receptionist sorts and distributes the mail to the appropriate departments. Mail orders and letters requesting order cancellations are forwarded to an order-entry clerk in the sales department.
The order-entry clerk initially checks the availability and the price of the ordered items and, if necessary, mails a back-order notice to the customer stating that there may be multiple shipments for this order. This clerk also takes orders from customers directly by phone and forwards all fillable orders to the credit-clerk. When the order-entry clerk receives a letter requesting an order cancellation (or a cancellation by telephone), the status of the order is first determined. If the customer order has not been processed, the order-entry clerk informs the warehouse that the order should be canceled and then informs the customer that the cancellation has been completed.
When fillable orders are received by the credit clerk, the customer’s credit status is checked. Orders are approved and an order-confirmation letter is sent to those customers with good credit standing. Customers with bad credit standing are sent a payment-overdue notice requesting pre-payment. The credit clerk forwards approved orders to the warehouse.
The warehouse fills the approved order and updates the inventory availability. An invoice is sent with the packaged order to the customer, and a shipping notice is sent to the accounts receivable department. The invoice may contain data from several orders as back-orders are shipped. Accounts receivable bills the customer for the products shipped. This department also maintains the invoice data files, updating them to reflect charges or payments received. Payments are received in the mail and delivered to accounts receivable by the receptionist. A payment receipt is sent to the customer.