Answered step by step
Verified Expert Solution
Link Copied!

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 (

image text in transcribed

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

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

Step: 3

blur-text-image

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

Professional IPhone And IPad Database Application Programming

Authors: Patrick Alessi

1st Edition

0470636173, 978-0470636176

More Books

Students also viewed these Databases questions

Question

Know the three main dimensions of the service environment.

Answered: 1 week ago