Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
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_NameStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started