Question: Based on the entities and attributes above. Write normalize the relational schema into its 2NF (based on partial dependencies ) and ultimately into 3NF (

 Based on the entities and attributes above. Write normalize the relational

Based on the entities and attributes above. Write normalize the relational schema into its 2NF (based on partial dependencies ) and ultimately into 3NF ( based on transitive dependency ).

CUSTOMER - cust ID, cust Name, contactNo, cust Address, cust Email REQUEST-request ID, request. Status, request Date EMPLOYEE - emp ID, emp. Name, emp.ContNo MANAGER manager. ID, manager Name, manager ContNo SALARY - salary. ID, salary. Amount, salary.Type PRICELIST - pricelist Code, pricelist. Amount, pricelist Item Weight SERVICE - Service Code, service Type, service Price TRANSACTION - transaction ID, transaction Amount, transaction Date, transaction Type FEEDBACK - feedback.ID, feedback. Type, feedback. Title REWARD - reward Code, reward Type, reward Status, reward Validity DELIVERY - rider ID, delivery. No, delivery. Time, delivery. Date CLOTHING_ITEM - clothing Code, clothing. Type, clothing.. Quantity STORE_DETAIL - store. ID, store Address, store.contNo VENDOR - vendor ID, vendor Name, vendor Address, vendor ContNo EQUIPMENT - equipment ID, equipment Type, equipment Cost, equipment Quantity, equipment 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 Databases Questions!