Subject: Relational Database Using the AIRPORT KLX TABLE, describe an example th
ID: 3699115 • Letter: S
Question
Subject: Relational Database
Using the AIRPORT KLX TABLE, describe an example that illustrates the Deletion anomaly:
Using the AIRPORT KLX TABLE, describe an example that illustrates the Insertion anomaly:
Using the AIRPORT KLX TABLE, describe an example that illustrates the Update anomaly:
Given the AIRPORT KLX TABLE, please identify all the full key functional dependencies that are present, partial functional dependencies (if any), and transitive functional dependencies (if any):
Show the result of normalizing the AIRPORT KLX TABLE to 2NF:
Show the result of normalizing the AIRPORT KLX TABLE to 3NF:
AIRPORT KLX TABLE Date ilinelD AirlineName TerminallD NumberOfGates NumberOfDepartingFlights 11-Dec UA 11-DecNW 11-DecAA 11-DecDL 11-Dec JB 12-Dec UA 12-Dec DL 12-DecSWA SouthwestC United Northwest A American Delta Jet Blue United Delta 20 20 20 15 15 20 15 15 34 17 20 6 29 20Explanation / Answer
Solution:
The first four subparts have been answered as per Chegg guidelines, please repost others.
Using the AIRPORT KLX TABLE, describe an example that illustrates the Deletion anomaly:
A Delete Anomaly occurs when certain attributes are lost on deletion of some other attributes.
Example- Suppose we wish to delete the information about an Airline with ID ‘SWA’. For deleting this particular airline the information related to the TerminalID ‘C’ will also be lost.
Using the AIRPORT KLX TABLE, describe an example that illustrates the Insertion anomaly:
Insert anomaly happens when certain attributes cannot be inserted into the database without the presence of other attributes in a table.
Example- Without having the information about the terminal like TerminalID, NumberOfGates etc., an airline information (AirlineID, AirlineName etc.) cannot be inserted.
Using the AIRPORT KLX TABLE, describe an example that illustrates the Update anomaly:
An update anomaly occurs when one and more instances of duplicate data is updated but not all instances.
Example- Suppose we need to update the NumberOfGates of a particular TerminalID (‘A’), for this we need to update all instances of this TerminalID in the given database.
Given the AIRPORT KLX TABLE, please identify all the full key functional dependencies that are present, partial functional dependencies (if any), and transitive functional dependencies (if any):
Attributes are said to be fully functionally dependent when one attributes ‘X’ of a table uniquely identifies another attribute ‘Y’ (and not any subset of Y) of a table.
In the AIRPORT KLX table below are the full functional dependencies that exist-
AirlineID -> AirlineName
TerminalID -> NumberOfGates
No Partial and transitive dependency exists in the given table.
I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)