Question
Given is a booking relation in a flight booking system (assume attribute values are atomic): BOOKING ( FlightNr, CNr, Airline, Land, Destination, DestinationCountry, Departure, FlightDate,
Given is a booking relation in a flight booking system (assume attribute values are atomic): BOOKING ( FlightNr, CNr, Airline, Land, Destination, DestinationCountry, Departure, FlightDate, BookingDate, Price, CName, BonusMiles ) The following functional dependencies hold in the relation schema, leading to data redundancies: FlightNr Destination FlightNr Airline FlightNr DestinationCountry FlightNr Land FlightNr Departure Destination DestinationCountry Airline Land CNr CName CNr BonusMiles Design, step-by-step, a database schema in 3rd Normal Form using decomposition. Note the primary keys.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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