Build an ERD for a factory that represents the following requirements and business rules. Make up your own attributes for each entity involved. 1) A component can be used to make any of several other components; 2) A component can be made of several other components 3) A component can be constructed from several raw materials; 4) A raw material is used in several components; 5) Each component is produced by a single worker; 6) A worker can produce many kinds of components; 7) A component may need a certain quantity of other components and raw materials; 8) There are two kinds of raw materials: perishable ones that have definite expiration time and desirable storage temperature, and non-perishables that does not have expiration time or storage restrictions
Build an ERD for a factory that represents the following requirements and business rules. Make up your own attributes for each entity involved. 1) A component can be used to make any of several other components; 2) A component can be made of several other components 3) A component can be constructed from several raw materials; 4) A raw material is used in several components; 5) Each component is produced by a single worker; 6) A worker can produce many kinds of components; 7) A component may need a certain quantity of other components and raw materials; 8) There are two kinds of raw materials: perishable ones that have definite expiration time and desirable storage temperature, and non-perishables that does not have expiration time or storage restrictions
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
