Introduction
There are issues that are seen and evident with the database that are used by the tour operator. One issue is that there is repeating data in the database. This is an issue that should be looked into when proposing a new data structure. There should not be any repeating values in the database. This paper will focus on procedures on how to refine the data structure for the tour operator’s database.
The tables that are there in the database are the following:
1st Normal form
The table has repeating values that should be altered to eradicate redundancy. If one customer chooses ...