Normalize the following to 3NF Show the new tables and the data recorded in them
ID: 3889388 • Letter: N
Question
Normalize the following to 3NF Show the new tables and the data recorded in them Be sure to indicate the key field(s) of each table by underlining their name(s) Date TaxiColD TaxiCoName TaxiCoAddress TaxiCoPhone TaxiStandID TaxiStandAddress NumTaxiCabs NumTaxiFares 100 Main 20 15 20 20 15 15 20 15 15 15-Sep BL Blue 462-8095 200 High St 34 Red Yellow A-One Fred's Blue A-One HomeTown 481 Cedar Ln 200 High St 200 High St 481 Cedar Ln 481 Cedar Ln 200 High St 481 Cedar Ln Airport 18 West Ave 403 Hwy 5 203 Elm 15-Sep RD 15-Sep YL 15-Sep A1 15-Sep FR 16-Sep BL 16-Sep A1 16-Sep HT 403-8372 374-2648 643-7364 578-5788 462-8095 643-7364 591-2534 17 20 6 29 20 17 23 Duke St 100 Main 203 Elm 14 E 3rd . Each Taxi company has a unique ID, name, address, and phone Each Taxi stand has a unique ID and address, and can accommodate a set number of cabs . A taxi company may have cabs at multiple taxi stands during a day . A taxi stand has cabs from multiple companies serving it . The number of taxi fares is recorded for each cab company at a given taxi stand on a given dateExplanation / Answer
Normalization In 3NF
taxi_company( TaxiCoId, TaxiName, TaxiAddress, TaxiPhone );
taxi_stand( TaxiStandId, TaxiStandAddress);
taxi_company_stand( TaxiCoId, TaxiStandId, NumTaxiCabs, NumTaxiFare,Date );
TaxiCoId
TaxiName
TaxiAddress
TaxiPhone
BL
Blue
100 Main
462-8095
RD
Red
18 West Ave
403-8372
YL
Yellow
403 Hwy 5
374-2648
A1
A-One
203 Elm
643-7364
FR
Fred’s
23 Duke St
578-5788
HT
Home Town
14 E 3rd
591=2534
TaxiStandId
TaxiStandAddress
A
200 High St
B
481 Cedar Ln
C
Airport
TaxiCoId
TaxiStandId
NumTaxiCabs
NumTaxiFare
Date
BL
A
20
34
15-Sep
BL
B
15
8
15-Sep
RD
A
20
17
15-Sep
YL
A
20
11
15-Sep
A1
B
15
20
15-Sep
FR
B
15
6
15-Sep
BL
A
20
29
16-Sep
A1
B
15
20
16-Sep
HT
C
15
17
16-Sep
TaxiCoId
TaxiName
TaxiAddress
TaxiPhone
BL
Blue
100 Main
462-8095
RD
Red
18 West Ave
403-8372
YL
Yellow
403 Hwy 5
374-2648
A1
A-One
203 Elm
643-7364
FR
Fred’s
23 Duke St
578-5788
HT
Home Town
14 E 3rd
591=2534
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.