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 graphically depicted solution is not included in the required page length .
2 . Construct a query that can be used on a report for determining how many days the customer ’ s invoice will require payment if total amount due is within 45 days . Provide a copy of your working code as part of the paper .
3 . Using the salesperson table described in the summary above , complete the following :
a . Construct a trigger that will increase the field that holds the total number of tours sold per salesperson by an increment of one ( 1 ).