Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Day Trading Strategies And Risk Management

Authors: Richard N. Williams

1st Edition

979-8863610528

More Books

Students also viewed these Finance questions