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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

The following unnormalized database schema is given for a flight booking system: BOOKING(FlightNr, CNr, Airline, Destination, DestinationCountry, Departure, FlightDate, BookingDate, Price, CName )...

Star Restaurant ( Spring Boot + Microservices ) 1 . 0 Introduction 1 . 0 Functional Requirements Star Restaurant is one of the leading restaurants, that has branches all over India. It pioneered the...

The market for ticket prices in the entertainment industry In April 2020, the United Kingdom's Competition and Markets Authority (CMA) launched an investigation into the 4billion merger between two...

Consider a relational database about hotels, customers (guests) and their bookings that is maintained by an online hotel booking company. The database consisting of the following tables(where the...

(Consider a relational database for an online hotel booking company. The database consisting of the following tables (where the primary keys are underlined): Hotel (hId, hName, hAddress, hCity)...

Customers customerlD C001 C002 C003 C004 firstName Tony Daniel Jimmy Jimmy lastName Sahama James Jimmy James email tony@gmail.com dan@yahoo com phoneNumber 0432328888 0412348711 0725637822 0488226739...

The W.V Scott Company had sales last year of $600,000, a NOI of $20,000 and DOL of 4. Assume that fixed costs are the same this year as last year. (i) Suppose that next year's sales are $630,000....

Wet solids containing 40% moisture by weight are dried to 10% moisture content by weight by passing moist air over the wet solids. The incoming air is at 93 C and 800 mm Hg pressure and the partial...

1 8 points ) You are provided with the following information on put and call options on a stock: c 0 = $ 6 . 6 4 p = $ 2 . 7 5 X = $ 3 0 T = 2 1 9 days S 0 = $ 3 3 . 1 9 Put - call parity shows the...

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

1. What are your creative strengths?

What metaphors might describe how we work together?

7. I understand that victims of my outbursts will remember my accusatory statements and name-calling long after I have calmed down.