Answered step by step
Verified Expert Solution
Question
1 Approved Answer
BIG CITY TAXI TaxiColD TaxiCoNameTaxiStandID NumTaxiCabs NumTaxiFares BL RD YL A1 FR BL A1 HT Date 34 Blue Red Yellow A-One Fred's Blue A-One HomeTown
BIG CITY TAXI TaxiColD TaxiCoNameTaxiStandID NumTaxiCabs NumTaxiFares BL RD YL A1 FR BL A1 HT Date 34 Blue Red Yellow A-One Fred's Blue A-One HomeTown 20 20 20 15 15 20 15 15 15-Sep 17 15-Sep 15-Sep 15-Sep 15-Sep 16-Sep 16-Sep 16-Sep 20 6 29 20 17 .The BIG CITY TAXI table captures data about daily taxi fares in a big city . Each taxi company operating in the city has a unique Taxi Company ID Taxi Company name .Each taxi stand in the city has a unique TaxiStandID and a fixed number of taxi cabs Each cab company is permanently assigned to one and only one taxi stand in the city . Each taxi stand can have multiple cab companies assigned to it . Each day, this table records the number of fares in the city for each taxi company 1. Using the BIG CITY TAXI table, describe an example that illustrates the insertion anomaly. 2. Using the BIG CITY TAXI table, describe an example that illustrates the deletion anomaly 3. Depict the full key functional dependencies in the BIG CITY TAXI table 4. Depict the partial functional dependencies (if any) in the BIG CITY TAXI table 5. Depict the transitive functional dependencies (if any) in the BIG CITY TAXI table
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started