Production tracking is important in many manufacturing environments (e.g., the pharmaceuticals industry, children’s toys, etc.). The following ER diagram captures important information in the tracking of production. Specifically, the ER diagram captures relationships between production lots (or batches), individual production units, and raw materials.(ER Diagram in photo) I) Please convert the ER diagram into a relational database schema. Be certain to indicate primary keys and referential integrity constraints ii. Please identify an attribute in the above ER diagram that might represent a composite attribute, and explain why/how it might represent a composite attribute. iii. Please identify an attribute in the ER diagram that could represent a derived attribute and explain why/how it might represent a derived attribute. iv. The ER diagram/relational database schema contains several instances of data redundancy. Please identify one instance where a data redundancy issue exists. v. The current ER diagram has the following relationship, “raw materials are used in 0 to many lots.” Please explain, in the context of the manufacturing environment, how the meaning changed if the minimal cardinality is changed to “1” (i.e., the relationship becomes "raw materials are used in 1 to many lots.”)
Production tracking is important in many manufacturing environments (e.g., the pharmaceuticals industry, children’s toys, etc.). The following ER diagram captures important information in the tracking
of production. Specifically, the ER diagram captures relationships between production lots (or batches), individual production units, and raw materials.(ER Diagram in photo)
I) Please convert the ER diagram into a relational
primary keys and referential integrity constraints
ii. Please identify an attribute in the above ER diagram that might represent a composite
attribute, and explain why/how it might represent a composite attribute.
iii. Please identify an attribute in the ER diagram that could represent a derived attribute
and explain why/how it might represent a derived attribute.
iv. The ER diagram/relational database schema contains several instances of data
redundancy. Please identify one instance where a data redundancy issue exists.
v. The current ER diagram has the following relationship, “raw materials are used in 0 to
many lots.” Please explain, in the context of the manufacturing environment, how the
meaning changed if the minimal cardinality is changed to “1” (i.e., the relationship
becomes "raw materials are used in 1 to many lots.”)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images