Map this ER diagram to a Relational Model and normalize it if needed. employee EMP_ID INT EMP_Frame

Map this ER diagram to a Relational Model and normalize it if needed.

 

 

 

Transcribed Image Text:

employee EMP_ID INT EMP_Frame VARCHAR(40) EMP_Lname VARCHAR(40) EMP_Sex VARCHAR(1) EMP_Birthdate DATE EMP_Salary INT Indexes distributor ?DIST_ID INT RETAIL_ID INT Indexes orders ORDER_ID INT CLI_ID INT ORDER_Date DATE SHIPPING_Dur DATE ORDER_Total DECIMAL (13,2) Indexes # retailer RETAIL_ID INT DIST_ID INT PART_MSRP DECIMAL(13,2) PART_Discount DECIMAL(5,2) PART_Cost DECIMAL(13,2) Indexes - client CLI_ID INT ORDER_ID INT CLI_Fname VARCHAR(40) CLI_Lname VARCHAR(40) CLI_Address VARCHAR(100) CLI_Zip INT CLI_Membership VARCHAR(1) Indexes manufacturer MANU_ID INT DIST_ID INT Indexes employee EMP_ID INT EMP_Frame VARCHAR(40) EMP_Lname VARCHAR(40) EMP_Sex VARCHAR(1) EMP_Birthdate DATE EMP_Salary INT Indexes distributor ?DIST_ID INT RETAIL_ID INT Indexes orders ORDER_ID INT CLI_ID INT ORDER_Date DATE SHIPPING_Dur DATE ORDER_Total DECIMAL (13,2) Indexes # retailer RETAIL_ID INT DIST_ID INT PART_MSRP DECIMAL(13,2) PART_Discount DECIMAL(5,2) PART_Cost DECIMAL(13,2) Indexes - client CLI_ID INT ORDER_ID INT CLI_Fname VARCHAR(40) CLI_Lname VARCHAR(40) CLI_Address VARCHAR(100) CLI_Zip INT CLI_Membership VARCHAR(1) Indexes manufacturer MANU_ID INT DIST_ID INT Indexes