Question: Part 2 Answer Q3-Q5 with reference to the BIKE_RENTAL_RECORD table below. where, - (Rental_date, Cus_phone, Bike_no) is the Primary Key - Cus_phone determines Cus_name -

 Part 2 Answer Q3-Q5 with reference to the BIKE_RENTAL_RECORD table below.

Part 2 Answer Q3-Q5 with reference to the BIKE_RENTAL_RECORD table below. where, - (Rental_date, Cus_phone, Bike_no) is the Primary Key - Cus_phone determines Cus_name - Bike_no determines Description, Bike_type, Charge - Bike_type determines Charge - (Rental_date, Cus_phone, Bike_no) determines Status Q3. Using the BIKE_RENTAL_RECORD table above, identify one example each for insertion, deletion and modification anomalies. ( 9 marks) Q4.Draw the dependency diagram for the BIKE_RENTAL_RECORD table above. Identify all dependencies including functional, partial and transitive dependencies. (6 marks) Q5.Normalize the BIKE_RENTAL_RECORD table to 3NF, showing all intermediate steps. (20 marks)

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!