Question
You are working in a facility that produces make-to-stock items. Each product is made via a series of operations, each at a different machine. Machines
You are working in a facility that produces make-to-stock items. Each product is made via
a series of operations, each at a different machine. Machines are run by workers. Each
product is identified by a unique number, and has a 10-character name. Every operation
has a different number, as well as a type identifier (e.g., milling operation). Each machine
has a number and is in a particular department: the number and department together
identify the machine. Every worker is identified by an employee number: the employees
name (first and last) and a single phone # MUST also be available.
Additionally, you find that
- each product requires between 1-6 operations: each operation is for a particular product.
- each operation is done at a particular machine, which is dedicated to that operation
only. Some machines, however, are not used for the current products.
- ten workers run the machines. Each worker can operate one or more machines.
Some machines are fully automated, however, and hence dont require any workers.
Develop a conceptual schema for the above scenario. Specify your schema via
three tables
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started