Answered step by step
Verified Expert Solution
Link Copied!

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.image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Will You Be My Internal Audit Manager

Authors: Benito Gross

1st Edition

B09774C8CK, 979-8521636563

Students also viewed these Accounting questions

Question

2. How should this be dealt with by the organisation?

Answered: 1 week ago

Question

explain what is meant by the term fair dismissal

Answered: 1 week ago