Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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 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