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.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more