Propose enhanced database management strategy

Assignment Help Database Management System

Reference no: EM13785856

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:

1. 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.

2. Create naming conventions for each entity and attributes.

3. 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:

1. Construct a trigger that will increase the field that holds the total number of tours sold per salesperson by an increment of one (1).

2. Create a query that can produce results that show the quantity of customers each salesperson has sold tours to.

4. Support the reasoning behind using stored procedures within the database as an optimization process for the database transactions.

Reference no: EM13785856

Questions Cloud

Number of competitors starts to decrease : During the ________ stage of the product life cycle sales reach a peak, profits are declining, and the number of competitors starts to decrease.

What sort of environment conditions-institutional agendas : Based on the material presented in the chapter, what sort of environment conditions, institutional agendas and technology trends support the emergence of the cybercorp?

Levels of cognitive demand issues : What adaptations would you make to the task or lesson in order to increase the potential for higher-level thinking?

Prepear a report that addresses a problem in an organization : Prepear a report that addresses a problem or issue within an organization. For this assignment, you will write a report of 2000-3000 words on a problem or issue within your workplace or community.

Propose enhanced database management strategy : 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.

Describe the overall leadership style of 21 century : Describe the overall leadership style of 21 century

Disposal are important and expensive activities in montreal : Snow removal and disposal are important and expensive activities in Montreal and many northern cities. Although snow can be cleared from streets and sidewalks by plowing and shoveling, in prolonged subfreezing temperatures, the resulting banks of acc..

Electronic communication stimulate healthy self-disclosure : Does electronic communication stimulate healthy self-disclosure? What motivates you, & what do you think your self-actualized self would look like?

Focused cost leadership strategy : Picked Southwest Airlines for this week’s topic since I flew their ABQ to LAX route so many times over the past 4 years and really enjoyed my experience. Before I started researching this week’s topic, I was sure I would be writing about “Focused Cos..

User Account

All Pages