What type of information system(s) should Strauble-Dytisa be considering to help support their operations? Identify a system that would implement the operations and justify it.

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

 Strauble-Dytisa is a manufacturer of refrigerator parts located in Quaretero, Mexico. They supply parts to manufacturers in the U.S. such as Maytag and Frigidaire. Orders for parts are received (by Sales Department) from manufacturers.

Each order (see the order form on the next page) has an order#, order date, and a total order amount (you can ignore taxes, s/h etc.). The order includes also the part#’s that are required, the part names and quantity of the part. An order could include for e.g. #51500 “door Liner” qty 50 as seen on the form. Since different manufacturers can order the same part (e.g. door liner), the order “qtys” from different orders are combined into one “#needed” for each part.

The Sales Department checks orders against an inventory file to see if parts are available. If the parts are available, an invoice is created and the parts are shipped to the manufacturer along with an invoice. A copy of the invoice is sent to accounting.

If the parts are not available, a copy of the order issent to Engineering/production. The engineering department consults the design specs for the part from a catalog and compares it to a “die file” -- a file that lists the dies (a die is a casting used to make a particular part) that are available. Assume one die per part. If a die is not available, a work order is prepared that includes the drawing as well as details about the die and sent to a nearby workshop.

Dies, designated by the die# are stored in a shelf designated by a shelf#. A shelf will have multiple dies. The parts are then manufactured using the dies; these are inserted into hydraulic presses and “stamped” (do not model “presses” and “stamping”). As parts are manufactured, the company places the finished parts in a container (designated by the C#), and updates a tag on the container. The tag has the “C# “, the # finished, the #needed. Each type of part is placed in a separate container i.e. all door panels in one container, backplanes in another etc. When the required number of parts are manufactured, the tags are removed and the parts are packed and sent to Sales Department. Sales creates invoices and ships the parts along with a copy of the invoice. Another copy is sent to accounting.

1. What type of information system(s) should Strauble-Dytisa be considering to help support their operations? Identify a system that would implement the operations and justify it.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Database Development
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