Given the following narrative description of a system, draw a context diagram and a  level-0 DFD for the activities with several processes described. State any assumptions if  you have any The purpose of the production scheduling system is to respond to a production order  (submitted by the Sales Department) by generating a daily production schedule,  generating raw material requisitions (sent to the Materials Management Department) for  all production orders scheduled for the next day, and generating job tickets for the work  to be completed at each workstation during the next day (sent to the Shop Floor Shift  Supervisor). The work is described in the following paragraphs. The production  scheduling problem can be conveniently broken down into three functions: routing,  loading and releasing. For each product on a production order, we must determine which  workstations are needed, in w

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

. Given the following narrative description of a system, draw a context diagram and a 
level-0 DFD for the activities with several processes described. State any assumptions if 
you have any


The purpose of the production scheduling system is to respond to a production order 
(submitted by the Sales Department) by generating a daily production schedule, 
generating raw material requisitions (sent to the Materials Management Department) for 
all production orders scheduled for the next day, and generating job tickets for the work 
to be completed at each workstation during the next day (sent to the Shop Floor Shift 
Supervisor). The work is described in the following paragraphs. The production 
scheduling problem can be conveniently broken down into three functions: routing, 
loading and releasing. For each product on a production order, we must determine which 
workstations are needed, in what sequence the work must be done, and how much time 
should be necessary at each workstation to complete the work. This data is available from 
the production route sheets. This process, which is referred to as routing the order, 
results in a route ticket. Given a route ticket (for a single product on the original 
production order), we then load the request. Loading is nothing more than reserving 
dates and times at specific workstations. The reservations that have already been made 
are recorded in the workstation load sheets. Loading requires us to look for the earliest 
available time slot for each task, being careful to preserve the required sequence of tasks 
(determined from the route ticket). at the end of each day, the workstation load sheets for 
each workstation are used to produce a production schedule. job tickets are prepared for 
each task at each workstation. the materials needed are determined from the bill of 
materials data store, and material requests are generated for appropriate quantities.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Software Development Approaches
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
  • SEE MORE 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