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 Dia


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.

Don't use plagiarized sources. Get Your Custom Essay on
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 Dia
Just from $10/Page
Order Essay

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

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.

Money-back guarantee

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

Zero-plagiarism guarantee

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

Free-revision policy

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

Privacy policy

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

Fair-cooperation guarantee

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

Order your essay today and save 30% with the discount code ESSAYSHELP