Question: A denormalized database table is given below. Normalize this table for all: INF but not 2NF, 2NF but not 3NF, 3NF but not BCNF, BCNF.

 A denormalized database table is given below. Normalize this table for

A denormalized database table is given below. Normalize this table for all: INF but not 2NF, 2NF but not 3NF, 3NF but not BCNF, BCNF. All the given records must be inside the related tables for each normal form. Customer Name Customer Surname Transport Company Transport Vehicle Departure Location Destination Location Departure Destination Time Time Imma Daniela Daniela Daniela Danuta Danuta Mykhail Mykhail Mykhail Mykhail Vencel Vencel Vencel Vencel Vencel Vencel Cobb Brown Brown Brown Bailey Bailey Hoffman Hoffman Hoffman Hoffman Mcgee Mcgee Mcgee Megee Megee Megee Burntwood Bingham Clifton Burntwood Cranwell Bingham Bingham Burntwood Cranwell Clifton Bingham Burntwood Clifton Bingham Burntwood Cranwell Plane Train Ship Plane Ship Ship Plane Bus Train Train Plane Train Ship Plane Train Plane Istanbul New York Athens Budapest New York Lisbon Athens New York London Tokyo Istanbul Tokyo Baghdad Milan Almaty Istanbul Istanbul New York Budapest Paris Bordeaux Miami New York New York Los Angeles Miami Seattle Paris Oxford Paris Cambridge 10:55 09:20 04:20 05:10 10:20 09:05 20:30 11:10 12:20 11:40 08:20 00:00 08:30 02:45 01:20 20:55 18:30 11:35 13:35 08:20 11:30 19:35 08:20 18:35 15:50 19:10 11:35 23:40 22:20 05:35 05:45 23:55 Lyon

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!