Question: Please help with this question. for your reference on how to create the table please see the bottom screenshot and create the table in the
Please help with this question. for your reference on how to create the table please see the bottom screenshot and create the table in the same way. thank you.
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 , like in your notes (Chapter 8).


Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
