Question

5. Read the following scenario. Do not be concerned that you are unfamiliar with the specifics of the setting - that isn't unusual for any systems analyst. 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. (40 points) 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.

5. Read the following scenario. Do not be concerned that you are unfamiliar with the specifics of the setting - that isn't unusual for any systems analyst. 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. (40 points)

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.

5. Read the following scenario. Do not be concerned that you are unfamiliar with the specifics of the setting - that isn't unusual for any systems analyst. 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. (40 points)

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.

Added by Victoria R.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Supreeta N

06/22/2023

Step 1

Step 1: The receptionist at Smalltown Music & Video Company receives all mail and sorts it, distributing it to the appropriate departments. Show more…

Show all steps

Thanks for your feedback!

The Smalltown Music & Video Company - 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.

Play audio

Feedback

Supreeta N and 101 other subject AP CS educators are ready to help you.

Ask a new question

Labs

Want to see this concept in action?

NEW

Explore this concept interactively to see how it behaves as you change inputs.

View Labs

Key Concepts

Recommended Videos

Recommended Textbooks

Transcript

00:01 Hello students, the entities and level 0 process for the data flow diagram are let us first know or like find out what are the entities the entities are first is the small town music small town, small town music is one of the entity small town music and the video company and video, video company, video company the other entity is magzine subscriber magzine subscriber, subscribers and the next is receptionist it is the receptionist, receptionist and the next entity we can say it is an order, order entry, order entry clerk the another entity is as the sales department sales department is one of the entity sales department, department, fine the other one is a customer where you will have a mail orders and everything a customer, customer the next one is the credit clerk, credit clerk, clerk and the other one is the warehouse, warehouse and the last one we can say it is an accounts receivable department accounts receivable department, department so, these are some of the entities of the data flow like a receptionist, receptionist where you can perform a sorting and the distribution as an operation and for the sales department you can perform like after the receptionist you go for the sales department when the order is cancelled or the mails or the letters, fine in an the next comes an order entity clerk it checks the availability of an items checks if the price of the items are available yes, i hope you can see here the clear picture of all the entities as you can see the, you can see from, you can see one of the example as the receptionist the receptionist has the technique of sorting and distribution as i have discussed and the order, order entry clerk it has to check the availability of the items and check the price of an items the other comes as the credit clerk where it checks the credit status and the warehouse fills, the another one was the warehouse where it fills the, where it has the function to perform the fills the approved orders and updates the inventory availability we can check all this, these are nothing but the entities as the receptionist, sales department, order clerk, order entry clerk, credit clerk, warehouse and these are some of the entities we can say, fine and now the level 0 processes are, those are, those are something which are performing some function like receiving and sort of an mail it is one of the level 0 process, fine where you are just receiving and sorting of…

Ace is your personal tutor. It breaks down any question with clear steps so you can learn.

Start Using Ace

Continue solving this problem

Create a free account to:

View full step-by-step solution
Ask follow-up questions with Ace AI
Save progress and study later

Question

Please give Ace some feedback