COACH-BOOKING(COACH TRIP, COACH_DATE, COACH_CITY, COACH_MILES, COACH_MAX_PAX, DRIVER, ASST_DRIVER, MECHANIC, BAGGAGE_HANDLER, CUST_NUM, CUST_NAME, LICENCE PLATE_NO, BUS_MODEL_CODE, BUS_MODEL_SEATS,...

  

Transcribed Image Text:

COACH-BOOKING(COACH TRIP, COACH_DATE, COACH_CITY, COACH_MILES, COACH_MAX_PAX, DRIVER, ASST_DRIVER, MECHANIC, BAGGAGE_HANDLER, CUST_NUM, CUST_NAME, LICENCE PLATE_NO, BUS_MODEL_CODE, BUS_MODEL_SEATS, BUS_MODEL_CHG_MILE) Based on the information provided above, perform the necessary Normalization, up to 3NF, and express your answers in textual relational schema format E.g. PROJECT (PROJ NUM, PROJ_NAME) JOB (JOB CLASS, CHG_HOUR) etc... (Note: no need to draw dependency diagrams!) Question 6 (5 marks) Attribute Name COACH TRIP COACH_DATE COACH_CITY COACH MILES COACH_MAX_ PAX DRIVER ASST DRIVER MECHANIC BAGGAGE HANDLER CUST_NUM CUST_NAME LICENCE PLATE NO BUS_MODEL_ CODE BUS_MODEL_ SEATS BUS_MODEL_ CHG_MILE Sample Value 38633 18-July- 2022 Perth 1300 28 Thomson 8133 Sally 5101H BMW-3000 60 $13.63 Sample Value 38635 18-July- 2022 Melbourne 1500 30 Donny Stewart Ched Reginald 3818 Janet 5231J CV-580 50 $18.33 Sample Value 38636 19-July- 2022 Sydney 8000 28 Stewart Thomson 3318 Selene 5101H BMW-3000 60 $13.63 Sample Value 38637 20-July- 2022 Adelaide 6830 50 Thomson 8133 Sally 8763P BMW-3000 60 $13.63 COACH-BOOKING(COACH TRIP, COACH_DATE, COACH_CITY, COACH_MILES, COACH_MAX_PAX, DRIVER, ASST_DRIVER, MECHANIC, BAGGAGE_HANDLER, CUST_NUM, CUST_NAME, LICENCE PLATE_NO, BUS_MODEL_CODE, BUS_MODEL_SEATS, BUS_MODEL_CHG_MILE) Based on the information provided above, perform the necessary Normalization, up to 3NF, and express your answers in textual relational schema format E.g. PROJECT (PROJ NUM, PROJ_NAME) JOB (JOB CLASS, CHG_HOUR) etc... (Note: no need to draw dependency diagrams!) Question 6 (5 marks) Attribute Name COACH TRIP COACH_DATE COACH_CITY COACH MILES COACH_MAX_ PAX DRIVER ASST DRIVER MECHANIC BAGGAGE HANDLER CUST_NUM CUST_NAME LICENCE PLATE NO BUS_MODEL_ CODE BUS_MODEL_ SEATS BUS_MODEL_ CHG_MILE Sample Value 38633 18-July- 2022 Perth 1300 28 Thomson 8133 Sally 5101H BMW-3000 60 $13.63 Sample Value 38635 18-July- 2022 Melbourne 1500 30 Donny Stewart Ched Reginald 3818 Janet 5231J CV-580 50 $18.33 Sample Value 38636 19-July- 2022 Sydney 8000 28 Stewart Thomson 3318 Selene 5101H BMW-3000 60 $13.63 Sample Value 38637 20-July- 2022 Adelaide 6830 50 Thomson 8133 Sally 8763P BMW-3000 60 $13.63

Answer rating: 100% (QA)

To normalize the given table up to 3NF Third Normal Form we first need to understand the initial set of attributes and identify the functional dependencies among them This process will help eliminate ... View the full answer