Tour

Databasing Inquiries

Design a data model that will conform to the following criteria:

• Propose an efficient data structure that may hold the tour operator's data using a normalization process. Describe each step of the process that will enable you to have a 2nd Normal Form data structure.

The database in question provides sufficient data for operational consistency but the redundancy of certain data impedes the general efficiency of the system in place. Therefore, normalization is a major priority for the tour operating company. Specifically, the database is overburdened by duplicate customer records, each of which is created at the time that a new tour is booked. This denotes that the system is decidedly inefficient in presenting data on the whole of our customer base.

First, we propose the use of framing as a data structure as a way of refining the representation of data. According to the text...
[ View Full Essay]