Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. A make-to-stock (MTS) company operates via eight manual assembly lines. Each assembly line consists of between one and six stations (a station cannot exist

image text in transcribed

2. A make-to-stock (MTS) company operates via eight manual assembly lines. Each assembly line consists of between one and six stations (a station cannot exist without a ine). The company manufactures up to 25 different products via these assembly lines. (50) Every assembly line is identified by a unique number, and can manufacture one or more products (i.e., multiple-product lines). Each product, in turn, can be produced on one or more assembly lines. Each line runs only one product at a time, however (and the same product may be found on different lines). Every product has a different identification code, as well as a name and associated engineering drawing number Each station on a line has one or more tools located at it, and is identified by its position on the line (i.e., station #). It is important to maintain a list of what tools are located at each station. Additionally, it is important to know the skill level needed at each station for the product currently being produced on that line. The company is interested in developing a database to track what products are currently being made on which lines. Develop a conceptual schema for this scenario, presenting it as an E-R diagram (do not worry about min/max cardinality constraints). 2. A make-to-stock (MTS) company operates via eight manual assembly lines. Each assembly line consists of between one and six stations (a station cannot exist without a ine). The company manufactures up to 25 different products via these assembly lines. (50) Every assembly line is identified by a unique number, and can manufacture one or more products (i.e., multiple-product lines). Each product, in turn, can be produced on one or more assembly lines. Each line runs only one product at a time, however (and the same product may be found on different lines). Every product has a different identification code, as well as a name and associated engineering drawing number Each station on a line has one or more tools located at it, and is identified by its position on the line (i.e., station #). It is important to maintain a list of what tools are located at each station. Additionally, it is important to know the skill level needed at each station for the product currently being produced on that line. The company is interested in developing a database to track what products are currently being made on which lines. Develop a conceptual schema for this scenario, presenting it as an E-R diagram (do not worry about min/max cardinality constraints)

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

Practical Azure SQL Database For Modern Developers Building Applications In The Microsoft Cloud

Authors: Davide Mauri, Silvano Coriani, Anna Hoffma, Sanjay Mishra, Jovan Popovic

1st Edition

1484263693, 978-1484263693

More Books

Students also viewed these Databases questions