Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. Read the following Case and complete the requirements below: Car Stuff, Inc. is a wholesale distributor of auto parts, such as bulbs, brakes, upholstery,

image text in transcribed
image text in transcribed
2. Read the following Case and complete the requirements below: Car Stuff, Inc. is a wholesale distributor of auto parts, such as bulbs, brakes, upholstery, and related items. Customers receive an updated catalog annually and place orders over the phone. When a customer calls in with an order, a clerk asks for the customer ID and name. The clerk keys in the customer number, and the computer retrieves the customer record from the customer database and displays it on the clerk's screen. The clerk compares the customer name to the data on the screen to ensure that the customer is legitimate. If everything checks out, the clerk enters the customer's order. After the order is entered, the computer compares the amount of the order to the available credit to ensure that the purchase does not exceed the credit amount limit. This results in the creation of an entry in the sales event data store and an allocation of inventory. At the end of the day, the sales event data are processed against the customer data and the inventory data, and is recorded in the sales order master data store. At the same time, a customer acknowledgement is printed in the mail room and is mailed to the customer. Also, a picking ticket is printed in the warehouse and will be used to assemble the customer's order. For the case, complete the following requirements. a. Prepare a table of entities and activities b. Draw a context diagram c. Draw a physical data flow diagram (DFD) d. Prepare an annotated table of entities and activities. Indicate on this table the groupings, bubble numbers, and bubble titles to be used in preparing a level o logical DFD. e. Draw a level o logical DFD. 2. Read the following Case and complete the requirements below: Car Stuff, Inc. is a wholesale distributor of auto parts, such as bulbs, brakes, upholstery, and related items. Customers receive an updated catalog annually and place orders over the phone. When a customer calls in with an order, a clerk asks for the customer ID and name. The clerk keys in the customer number, and the computer retrieves the customer record from the customer database and displays it on the clerk's screen. The clerk compares the customer name to the data on the screen to ensure that the customer is legitimate. If everything checks out, the clerk enters the customer's order. After the order is entered, the computer compares the amount of the order to the available credit to ensure that the purchase does not exceed the credit amount limit. This results in the creation of an entry in the sales event data store and an allocation of inventory. At the end of the day, the sales event data are processed against the customer data and the inventory data, and is recorded in the sales order master data store. At the same time, a customer acknowledgement is printed in the mail room and is mailed to the customer. Also, a picking ticket is printed in the warehouse and will be used to assemble the customer's order. For the case, complete the following requirements. a. Prepare a table of entities and activities b. Draw a context diagram c. Draw a physical data flow diagram (DFD) d. Prepare an annotated table of entities and activities. Indicate on this table the groupings, bubble numbers, and bubble titles to be used in preparing a level o logical DFD. e. Draw a level o logical DFD

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Baccalaureate Computer Science HL And SL Option A Databases Part I Basic Concepts

Authors: H Sarah Shakibi PhD

1st Edition

1542457084, 978-1542457088

More Books

Students also viewed these Databases questions