Transform the 3nf lists into a set of database tables

Assignment Help Database Management System

Reference no: EM132150349

(a) Taking an unnormalised list, describe how you would normalise it using the normal forms technique and show how the result of this method is used.

(b) You are currently in the process of developing a RDBMS for a national rail company. They provide train services between various counties and towns in London.

The marketing manager has given you the following form, which is completed for every train journey: (departure_station, arrival_station, date, departure_time, distance, estimated_time, actual_time_taken, number_of_stops, driver_id, driver_name, train_reg_number, number_of_carriages, max_number_of_passengers, actual_number_of_passengers, amount_collected (passenger_num, passenger_name, passenger_address, cost)

Note 1: A combination of Departure Station, Arrival Station, Date and Departure Time identifies each journey.

Note 2: Each passenger is allocated a passenger number when the first travel with the company. Each time they travel, they use the same passenger number.

Note 3: Cost relates to the amount the customer is charged for that journey. From this list, you should:

Normalise the list using the Normal Forms technique. You should explain any changes you are making at each step of the Normal Forms process.

(ii) Transform the 3NF lists into a set of database tables. Include one row of meaningful data for each of the tables

Reference no: EM132150349

Questions Cloud

Create an iterator that will return the memory address : Create an iterator that will return the memory address and value for each integer present in the Array.

Total number of females for the expected frequencies : If these data are used for a chi-square test for independence, what is the total number of females for the expected frequencies?

What can it provide to the business decision-maker : How would you suggest applying Tableau with an even larger database, say of one million records, with 30 fields that include Lat.-Long fields?

Reject the null hypothesis : What P-value was found when determining whether there is a difference in the IQ of girls and boys in problem 6? Should you reject the null hypothesis?

Transform the 3nf lists into a set of database tables : Normalise the list using the Normal Forms technique. You should explain any changes you are making at each step of the Normal Forms process.

Determine how far a car may be driven based on the capacity : Develop a process that will determine how far a car may be driven based on the capacity of the gas tank in gallons and the fuel economy.

Conduct a hypothesis test : The average, or "par" score for an 18 hole golf course is 72. The score is computed by counting the number of swings

What was the primary motivating factor to migrate : What was the primary motivating factor to migrate to IPv6? What are two other advantages of IPv6 over IPv4?

Standard deviation of the sampling distribution : A sample of 100 randomly selected students found that the proportion of students planning to travel home for Thanksgiving is 0.68.

User Account

All Pages