Consider Case Study (2): World’s Trend Catalog Division. Case -2: World’s Trend Catalog Division World’s Trend is a mail order supplier of high-quality, fashionable clothing. Customers place orders by telephone, by mailing an order form included with each catalog, or via the Web site. When customer orders come in, the item master and the customer master files are both updated. If an item is out of stock, the inventory control department is notified. If the order is from a new customer, a new record is created in the customer master file. Picking slips are produced for the customer order and sent to the warehouse. A shipping statement is prepared. The process of shipping a customer order involves getting the goods from the warehouse and matching up the customer shipping statement, getting the correct customer address, and shipping it all to the customer. The customer statement is generated, and a billing statement is sent to a customer once a month. An accounts receivable report is sent to the accounting department. Step-1: Identify Entities • Customer • Inventory • Warehouse • Accounting Step-2: Identify Processes • Add Customer Info. • Add Customer Order • Produce Picking Slip • Prepare Shipping Statement • Ship Customer Order • Create Customer Statement • Produce Account Receivable Step-3: Identify Data Stores • Customer File • Items File If you know that THE parent process (3) – PRODUCE PICKING LIST have the following child subprocesses: 1. Read Item Record (from Items File) 2. Create Order Record (to Order Item File) 3. Sort Item by Location in Warehouse (to sorted orders file) 4. Get Customer Records (from Customer File) 5. Print Order Picking Slip Draw the child DFD (Level 3 Data Flow Diagram) for the mentioned process

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Consider Case Study (2): World’s Trend Catalog Division.

Case -2: World’s Trend Catalog Division World’s Trend is a mail order supplier of high-quality, fashionable clothing. Customers place orders by telephone, by mailing an order form included with each catalog, or via the Web site. When customer orders come in, the item master and the customer master files are both updated. If an item is out of stock, the inventory control department is notified. If the order is from a new customer, a new record is created in the customer master file. Picking slips are produced for the customer order and sent to the warehouse. A shipping statement is prepared. The process of shipping a customer order involves getting the goods from the warehouse and matching up the customer shipping statement, getting the correct customer address, and shipping it all to the customer. The customer statement is generated, and a billing statement is sent to a customer once a month. An accounts receivable report is sent to the accounting department.

Step-1: Identify Entities • Customer • Inventory • Warehouse • Accounting

Step-2: Identify Processes • Add Customer Info. • Add Customer Order • Produce Picking Slip • Prepare Shipping Statement • Ship Customer Order • Create Customer Statement • Produce Account Receivable

Step-3: Identify Data Stores • Customer File • Items File

If you know that THE parent process (3) – PRODUCE PICKING LIST have the following child subprocesses:

1. Read Item Record (from Items File)

2. Create Order Record (to Order Item File)

3. Sort Item by Location in Warehouse (to sorted orders file)

4. Get Customer Records (from Customer File)

5. Print Order Picking Slip

Draw the child DFD (Level 3 Data Flow Diagram) for the mentioned process.

Customer Not Found Error
Customer
Order
Customer
Order
D1
1.1
Customer Records
D4
Validate
Customer
Account
Customer File
Shipping File
D2 Item File
1.2
Validate
Order
Items
Item Not Found Error
-Valid Customer Info-
Customer
Records
Shipping Cost-
-Valid Customer Info.
Items
Quantity
-Valid Item-
-Item Price & Weight-
1.6
Update
Customer
Records
1.5
Calculate
Order
Total
Order Totals
1.3
Determine
Quantity
Available
Order Totals-
Available
Item
Back-Order Items
1.7
Create
Pending
Orders
1.4
D2
Pending
Order
Update
Item
Quantity
Item Records
Items File
Item
Records
Transcribed Image Text:Customer Not Found Error Customer Order Customer Order D1 1.1 Customer Records D4 Validate Customer Account Customer File Shipping File D2 Item File 1.2 Validate Order Items Item Not Found Error -Valid Customer Info- Customer Records Shipping Cost- -Valid Customer Info. Items Quantity -Valid Item- -Item Price & Weight- 1.6 Update Customer Records 1.5 Calculate Order Total Order Totals 1.3 Determine Quantity Available Order Totals- Available Item Back-Order Items 1.7 Create Pending Orders 1.4 D2 Pending Order Update Item Quantity Item Records Items File Item Records
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Types of Database Architectures
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education