In$-$Class Graded Assignment

The following E$-$R diagram tracks production, specifically the relationship between production lots $($or batches$)$

individual production units, and raw materials

Your assignment:

Convert the E$-$R diagram into a relational database schema

Identify all primary keys

Identify all foreign keys

Determine if there are examples of data redundancy or a derived value in the E$-$R diagram. If so$,$ give at

least one. Otherwise, state that there are none.

Rubric:

Built using a modeling tool $(15$ points$)$

Correct entities $(25$ points$)$

Correctly identify the primary key for all entities in the submitted model $(20$ points$)$

Correctly identify the foreign keys $(25$ points$)$

Answer to redundancy$/$derived question $(15$ points$)$