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,...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
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
Posted Date:
Students also viewed these databases questions
-
Saraswati Glass Works has an investment of Rs 30 crore divided into 30 lakh ordinary shares. The profitability rate of the firm is 20 percent and the capitalization rate is 12.5 percent. What is the...
-
Given the sample records in the CHARTER table shown in Table P6.11, do the following: a. Write the relational schema and draw the dependency diagram for the table structure. Make sure that you label...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Amandeep, a graduate of Cambrian Colleges Business Program, found a job as an online marketing specialist for Tangerine Bank. Within a year, he had saved {A} and decided to buy a new car but was not...
-
A guitar string has a mass per length of 2.33 103 kg/m and a fundamental frequency of 146.8 Hz when it is under a tension of 82.4 N. The string breaks, and its owner has only a spare string of mass...
-
The most likely response to Question 2 is a(n): A. increase in the price level. B. decrease in risk premiums. C. increase in government debt. Connor Wagener, a student at the University of Canterbury...
-
M_Limited has an authorised share capital of 1,500,000 divided into 1,500,000 ordinary shares of 1 each. The issued share capital at 31 March 2007 was 500,000 which was fully paid, and had been...
-
Bao Wao Designs Inc. purchased a computerized blueprint printer that will assist in the design and display of plans for factory layouts. The cost of the printer was $22,500, and its expected useful...
-
Hackworth Company's common stock is expected to pay a $5.80 dividend in the coming year. If investors require a 24% return and the growth rate in dividends is expected to be 8%, what should the...
-
Air containing 1.6 vol% sulfur dioxide is scrubbed with pure water in a packed column of 1.5-m2 cross-sectional area and 3.5-m height packed with no. 2 plastic Super Intalox saddles, at a pressure of...
-
Woodlands (Pty) Ltd is a manufacturer that specialises in unique hand-crafted modern chandeliers, fumiture, and home accessories with a contemporary African feel. The company's financial year end is...
-
How do derivatives and complex financial instruments, such as credit default swaps and collateralized debt obligations, contribute to systemic risk within global financial markets ?
-
take any sample and determine its chemical composition and eventually, its molecular formula. As an analytical chemist, how are you going to do it, without necessarily going into details of elements'...
-
In evaluating The Coca-Cola Companies 2020 10-K report, what could be considered a related party transaction and disclosure?...
-
The diameter of a silicon atom is 2.34 x10 -8 cm. If the silicon atoms were placed next toeach other in a straight line across and 8.5-inch width piece ofpaper, how many silicon atoms would be there?
-
Consider that you take out a $250,000, 15-year mortgage with 3.5% interest with monthly payments. Create the amortization schedule. (Show the first 3 payments) Payment # Payment Amount Interest Paid...
-
what makes the stock market more appealing than the bond market for some investors
-
1) Predict the organicproduct formed when BzCl reacts with cyclohexanol. BzCl = benzoylchloride. 2) Provide the majororganic product of the reaction below. 3) Draw the structureof the product formed...
-
Convert 3.8874 to fraction form and reduce to lowest terms. Do the indicated conversion. If it is a repeating decimal, use the correct notation.
-
Convert \(\frac{27}{625}\) to decimal form. Do the indicated conversion. If it is a repeating decimal, use the correct notation.
-
\(\frac{3}{5}+\frac{3}{10}\) Perform the indicated operations. Reduce to lowest terms.
Study smarter with the SolutionInn App