Based on the conceptual Chens ERD model presented below, create a relational schema for the database of a manufacturing company. For each of the relations, indicate the normal form for that relation, if the relation is not in third normal form, decompose it into 3NF. That is, you will generate a set of relations connected with arrows from foreign key to primary key. About 10 relations connected with arrows from foreign key in one table to primary key in another table. Make sure your relation schema is optimal. For example, a foreign key should be assigned to the relation that will produce less redundancies.

Example:

Customer ID Customer Nam Address CUSTOMER has RECORD 1 RID History submit Order ID M ORDER Order_Date 1 M orderline Order_Quantity M Product ID PRODUCT Description 1 Price M produce M E ID E_Name Skill ID Skill Name 1 M1 K work WORK CENTER EMPLOYEE M WID W_Name Supervise