Scribd
Upload
75 views1 page

Database Normalization Exercise

This document discusses normalizing a flat file containing tourist data into 1st, 2nd, and 3rd normal form. It contains the original flat file layout and proposed solutions for decomposing the data into tables in each normal form. The flat file includes fields for client information, destination details, booking details, and travel agent commissions. The proposed solutions break the flat file into multiple tables to remove functional dependencies and isolate entities in third normal form.

Uploaded by

Fanelo Felicity
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
75 views1 page

Database Normalization Exercise

This document discusses normalizing a flat file containing tourist data into 1st, 2nd, and 3rd normal form. It contains the original flat file layout and proposed solutions for decomposing the data into tables in each normal form. The flat file includes fields for client information, destination details, booking details, and travel agent commissions. The proposed solutions break the flat file into multiple tables to remove functional dependencies and isolate entities in third normal form.

Uploaded by

Fanelo Felicity
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

INF 214

Class Activity 6: Normalisation


Dependency Diagrams

Design the dependency diagram for the data given below in 1st, 2nd and 3rd normal form. You are given the following flat
file with tourist data:

PROPOSED SOLUTION

1NF
ClientNr ClientName ClientSurname ClientCell ID NrOfPeople DestinationNr DestinationDescr DailyCost AgentNr TravelAgent CommissionPerc DaysSold AdminFee

2NF
ClientNr ClientName ClientSurname ClientCell ID

ClientNr DestinationNr NrOfPeople AdminFee DaysSold

AgentNr TravelAgent CommissionPerc

DestinationNr DestinationDescr DailyCost

3NF
ClientNr ClientName ClientSurname ClientCell ID

DestinationNr DestinationDescr DailyCost AgentNr

ClientNr DestinationNr NrOfPeople AdminFee DaysSold

AgentNr TravelAgent CommissionPerc

You might also like