QUESTION $3$: CREATING A RELATIONAL DATABASE SCHEMA

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

$($a$)$ Convert the ER diagram into a relational database schema. Be certain to indicate primary keys and referential integrity constraints $(18$ marks$)$