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

The following unnormalized database schema is given for a flight booking system: BOOKING(FlightNr, CNr, Airline, Destination, DestinationCountry, Departure, FlightDate, BookingDate, Price, CName ) The schema contains the following functional dependencies (FDs): (FD1) FlightNr Destination , DestinationCountry (FD2) FlightNr Airline (FD3) FlightNr Departure (FD4) Destination DestinationCountry (FD5) CNr CName Two travel bookers use different strategies to determine the price for a ticket. Formulated in functional dependencies we have: (FD6) FlightNr , BookingDate , FlightDate Price (FD7) Airline , Destination , BookingDate , FlightDate Price Using these FDs and the inference rules F1-F6, verify whether (FD1-FD5) together with FD6 imply the dependency FD7 and, vice versa, whether (FD1- FD5) together with FD7 imply the dependency FD6. Are FD6 and FD7 equivalent?

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!

Given is a booking relation in a flight booking system (assume attribute values are atomic): BOOKING ( FlightNr, CNr, Airline, Land, Destination, DestinationCountry, Departure, FlightDate,...

Airline Company Case Study This document describes the data requirements for a fictional airline company, Anchor Air. In this case study, the company's key information requirements are identified....

CSIT 1 5 4 Normalization Basics * * Scenario * * Imagine you are tasked with designing a database for a small library. The library has the following information to manage: 1 . Books: Each book has a...

Normalization Basics Scenario Imagine you are tasked with designing a database for a small library. The library has the following information to manage: 1 . Books: Each book has a unique ISBN, a...

Anomalies are problems that can occur in poorly planned, un-normalized databases where all the data is stored in one table. Being a database designer you have been given the task to design a database...

Your Task Developers frequently have to create interfaces that allow non-developers to easily view and interact with information stored in databases. These interfaces are called **content management...

3. NoSQL databases, Normalisation, and Triggers [5 marks] (b) Explain a scenario where a graph database is more appropriate to use [5 marks] (c) Relational databases are often normalised. Explain...

Exercise 2 ( 3 0 % ) Consider the following relational database schema, which describes information about shares that can be owned by employees of companies. Specifically, the database schema...

Fossils are studied for (A) Tracing evolutionary history of organisms (B) Studying extinct organisms (C) Providing jobs to scientist (D) Both A and B

Doakes Corporation uses a job costing system with a single predetermined plant-wide overhead rate based on direct labor hours. The company based its default overhead rate for the current year on the...

6 Sudoku is a popular puzzle. Here are two questions: Are girls better than boys at Sudoku? Are 11-year-olds better than 14-year-olds at Sudoku? a What data do you need to collect to answer these...

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...

3-11 In this exercise, you will use software at car Web sites to find product information about a car of your choice and use that information to make an important purchase decision. You will also...

3-12 In MyMISLab, you will find a Collaboration and Teamwork Project dealing with the concepts in this chapter. You will be able to use Google Drive, Google Docs, Google Sites, Google+, or other...

3-8 Marks & Spencer Group is a leading department store chain in the United Kingdom. Its retail stores sell a range of merchandise. Senior management has decided that Marks & Spencer should tailor...