Convert ERDs into relational models:

Note: The result of conversion is a collection of simplified commands example is below:

Convert ERDs into relational models: resulit must be in simplified commands lke the sample example shown above.

Be sure to convert each many-to-many relationship into a table.

Do not convert (0,1)-to-many relationship to a table. That is, do not convert optional 1-to-many relationships.

Chem isft Empbyee ID Name Phone No Assignment (Employee_ID Project D) Serial No) Assign_Date Project assigned for Project ID Start Date used Equipment Serial No Cost Chemist (Employee_ID, Name, Phone_No) Project (Project_ID, Start_Date) Equipment (Serial_No, Cost Assignment (Employee_ID, Project_ID, Serial_No, Assign_Date) Assignment.Employee_ID references Chemist.Employee_ID Assignment.Project_ID references Project.Project_ID Assignment.Serial_No references Equipment.Serial_No