Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Refer to the following Aircraft _ I relation, from the relational schema designed for the datat ) ase of the Fun Travel Aircraft Company, which
Refer to the following AircraftI relation, from the relational schema designed for the datatase of the Fun Travel Aircraft Company, which rents aircrafts for local private travels. The relation includes the aircraft number ACNUM model ACMODEL rental charger per hour ACRENTCHG number of seats available ACSEATS and the total time in hours the aircraft was flying to the date ACTOTALTIME The Primay Key for the relation is AC NUM. Analyze the data in the relation and identify the Functional Dependencies FD that exist. marks b In which Normal Form NF is the relation AircraftI in Justify your answer. marks c If the relation AircraftI is not in the NF normalize it into a relation in NF Show each step of the normalization process clearly and provide any justifications.
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