Question: map the model to relational database schema and perform data normalization if the relation schemas produced are not yet in 3NF. reward_Type reward code cust_ID

map the model to relational database schema and perform data normalization if the relation schemas produced are not yet in 3NF.map the model to relational database schema and perform data normalization if

reward_Type reward code cust_ID cust_Name cust_ID cust_Address trans_Date trans_ID emo ID eme_IR salary_ID salary_ID M 1 1 M 1 1 REWARD achieved By CUSTOMER makes TRANSACTION receives EMPLOYEE has SALARY 1 1 reward_Status reward_Validity contacto cust_Email trans_Type trans_Amount) eme_Name emp_ContNo salary_Amount salary_Type ordered By 5 clothing_Code request_ID request ID cust_ID delivery_No nder_D request_ID manager_ID emo_ID feedback_ID Xmanager_ID M 1 M 1 1 1 1 M CLOTHING_ITEM has REQUEST has DELIVERY MANAGER receives FEEBACK 1 1 clothing_Quantity clothing Type request_Data request Status delivery Time delivery_Date manager_Name manager_ContNo feedback_Type feeback_Title has managedy Service Code) request_ID storeID manager_ID vendor_Name vendor_ID store_ID M 1 1 M price_Code SERVICE STORE_DETAIL soldBy VENDOR M 1 service_Type service_price store_Address store_ContNo vendor_Address vender_ContNo has has price_Code price_Item Weight BAUR_ID vendor_ID 1 M PRICELIST EQUIPMENT price_Amount equip_Type equip Cost equip_Quantity equir_Name reward_Type reward code cust_ID cust_Name cust_ID cust_Address trans_Date trans_ID emo ID eme_IR salary_ID salary_ID M 1 1 M 1 1 REWARD achieved By CUSTOMER makes TRANSACTION receives EMPLOYEE has SALARY 1 1 reward_Status reward_Validity contacto cust_Email trans_Type trans_Amount) eme_Name emp_ContNo salary_Amount salary_Type ordered By 5 clothing_Code request_ID request ID cust_ID delivery_No nder_D request_ID manager_ID emo_ID feedback_ID Xmanager_ID M 1 M 1 1 1 1 M CLOTHING_ITEM has REQUEST has DELIVERY MANAGER receives FEEBACK 1 1 clothing_Quantity clothing Type request_Data request Status delivery Time delivery_Date manager_Name manager_ContNo feedback_Type feeback_Title has managedy Service Code) request_ID storeID manager_ID vendor_Name vendor_ID store_ID M 1 1 M price_Code SERVICE STORE_DETAIL soldBy VENDOR M 1 service_Type service_price store_Address store_ContNo vendor_Address vender_ContNo has has price_Code price_Item Weight BAUR_ID vendor_ID 1 M PRICELIST EQUIPMENT price_Amount equip_Type equip Cost equip_Quantity equir_Name

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

\f