1. Production tracking is important in many manufacturingenvironments (e.g., the pharmaceuticals industry, children’s toys,etc.). The following ER diagram captures important information inthe tracking of production. Specifically, the ER diagram capturesrelationships between production lots (or batches), individualproduction units, and raw materials. Answer the following questionsbased on the ER diagram as given above: a) Fill in the blanksbelow: [6 Marks] Table Name (Entity) Is dependent (Answer yes/no).Any other answer will receive 0 Primary Key Column Name ProductionUnits Lot Raw Materials b) Write the name of the 2 columns that canbe a foreign key in the dependent table. [2 Mark] c) Identify 2columns
OR
OR