Question: please answer quick I have only 1 hour time for this! Part E: NORMALIZATION (15 points) Departure Route No Destination Distance Time Ticket No Date

please answer quick I have only 1 hour time for this!

please answer quick I have only 1 hour time for this! Part

Part E: NORMALIZATION (15 points) Departure Route No Destination Distance Time Ticket No Date Driver No DriveName ClientNo ClientName TGO1 Terengganu 500 9:00 27/11/2020 TK01 DO1 Ahmad 001 Maryam KLO2 600 20:00 28/11/2020 Lumpur TK02 Razi JHO1 Johor 350 8:00 29/11/2020 TK03 DO2 Zeki C03 Aishah Kuala CO2 KL03 Kuala Lumpur 330 21:00 TK04 30/11/2020 C04 Ibrahim 10:00 IK05 4/12/2020 D03 Amir COS Fatimah PHOT Pahang 250 11:00IK06 4/12/2020 D04 Zainab C06 Yusuf The bus ticketing report shown above displays snippet of the daily transactions. Based on this report answer the following questions: 1. Identify the functional dependencies (primary, partial, and transitive if any) in the relation above based on the information given to you. Specify whether it is primary, partial, or transitive. (4 points) 2. Perform normalization process to this relation based on the following steps: Ist Normal Form, 2nd Normal Form and finally the 3rd Normal Form. Your answers are the final relations or tables created after you have performed all three Normal Form. Please indicate the primary keys or/and foreign key(s) for all the relations. (6 points) 3. Using your findings in Question 2 of Part E, draw an ERD to reflect the properly decomposed normalized tables. Show all the relationships, attributes, primary key, foreign key, and multiplicities. (5 points)

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!