Answered step by step
Verified Expert Solution
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
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
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