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.”)
Question
NB: First three questions already answered (I, ii and iii), take the last 2(iv and v)
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.”)
Step by step
Solved in 2 steps
