of persons in tour , and total amount paid . The current structure will show the customer more than once , if the customer books multiple tours .
• A tour table that is used as a tour rate sheet which holds the tours offered and the cost per person . Tour rates vary every three ( 3 ) months depending on the tourist season .
Write a three to four ( 3-4 ) page paper in which you propose an enhanced database management strategy . Your proposal should include the following :
1 . Design a data model that will conform to the following criteria :
a . 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 .
b . Create naming conventions for each entity and attributes .
c . Conclude your data model design with an Entity Relationship Model ( ERM ) that will visually represent the relationships between the tables . You may make use of graphical tools in Microsoft Word or Visio , or an open source alternative such as Dia . Note : The