Imagine the U.S. Congress is considering legislation that will ban MTBE, a substance added to gasoline to reduce emissions. This legislation was proposed due to complaints from citizens and interest groups who believe MTBE is a health threat. In a well-written paragraph, analyze whether the benefits of creating this ban are worth the costs. Use examples from the module to support your answer. (9 points)

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Imagine that you work for a pricing strategy consulting business. Select a business to be your next client. Think of a scenario that would result in your client seeking advice from your consulting business. You will use this same business / client for Assignment 2.InstructionsDevelop a report about your client for your boss (two to four pages recommended) that includes the following components:

1. Company Description
   1. Describe the company, the products it makes or services it provides, and the problem(s) or issue(s) that the company is facing related to its pricing strategy.
2. Pricing Strategies
   1. Evaluate the pricing strategies relative to the product life cycle for your client’s three top-selling products.
      1. Summarize the critical factors (e.g., technology, regulation, market information, and consumer preferences) that affect your client’s pricing decisions.
      2. Describe the impact value has on the company’s pricing strategy and profitability, and the importance of market segmentation.
      3. Determine the effectiveness or ineffectiveness of your client’s price and value communication strategies.
3. References
   1. Use at least three quality academic resources in this assignment. Note: Wikipedia and other similar websites do not qualify as academic resources.
4. Your assignment must follow these formatting requirements:Be typed, double-spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and 
5. Examine the key pricing considerations and strategies relative to the product life cycle.
   1. Analyze the critical factors in making pricing decisions. 
   2. Identify the impact assessing value has on pricing strategy and profitability, and the importance of market segmentation.
   3. Identify the effectiveness of price and value communication strategies.
6. Grading for this assignment will be based on answer quality, logic/organization of the paper, and language and writing skills. Click here to access the rubric for this assignment.

  ASSIGNMENT SUBMISSION

1. Create Submission in BlackboardStart Submission
2. Attach Files

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Imagine that you manage human resources for a small business. You have recently prepared a report on the market rate of pay for salespeople, and the company’s owner says the market rate is too high. The company cannot afford this level of pay, and furthermore, paying that much would cause salespeople to earn more than most of the company’s managers. Why is this a problem? Should managers automatically be at the top of the pay scale? Suggest three possible measures the company might take to help resolve this conflict

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Imagine that you have been hired to fulfill their need of enhancing the data repository for their current reservation processing system. Upon reviewing the system, you find that the data structure holds redundant data and that this structure lacks normalization. The database has the following characteristics:

• A table that stores all the salespersons. The table holds their employee id, first name, last name and “Tours sold” field. The “Tours sold” field is updated manually.
• A table that stores tour customer data and tours sold. The table holds customer name, address, city, state, zip code, tour(s) selected, number 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:
   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 with which you are familiar. 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.

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
• Include charts or diagrams created in any chart or drawing tool with which you are familiar. The completed diagrams / charts must be imported into the Word document before the paper is submitted.

Points: 90

Assignment 5: Tour Operator Agency Database 

Criteria

UnacceptableBelow 70% F

Fair70-79% C

Proficient80-89% B

Exemplary90-100% A

1a. Design a data model that will 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.Weight: 10%

Did not submit or incompletely designed a data model that will propose an efficient data structure that may hold the tour operator’ s data using a normalization process. Did not submit or incompletely described each step of the process that will enable you to have a 2nd Normal Form data structure.

Partially designed a data model that will propose an efficient data structure that may hold the tour operator’s data using a normalization process. Partially described each step of the process that will enable you to have a 2nd Normal Form data structure.

Satisfactorily designed a data model that will propose an efficient data structure that may hold the tour operator’s data using a normalization process. Satisfactorily described each step of the process that will enable you to have a 2nd Normal Form data structure.

Thoroughly designed a data model that will propose an efficient data structure that may hold the tour operator’s data using a normalization process. Thoroughly described each step of the process that will enable you to have a 2nd Normal Form data structure.

1b. Design a data model that will create naming conventions for each entity and attributes.Weight: 10%

Did not submit or incompletely designed a data model that will create naming conventions for each entity and attributes.

Partially designed a data model that will create naming conventions for each entity and attributes.

Satisfactorily designed a data model that will create naming conventions for each entity and attributes.

Thoroughly designed a data model that will create naming conventions for each entity and attributes.

1c. Design a data model that will conclude your data model design with an Entity Relationship Model (ERM) that will visually represent the relationships between the tables.Weight: 10%

Did not submit or incompletely designed a data model that will conclude your data model design with an Entity Relationship Model (ERM) that will visually represent the relationships between the tables.

Partially designed a data model that will conclude your data model design with an Entity Relationship Model (ERM) that will visually represent the relationships between the tables.

Satisfactorily designed a data model that will conclude your data model design with an Entity Relationship Model (ERM) that will visually represent the relationships between the tables.

Thoroughly designed a data model that will conclude your data model design with an Entity Relationship Model (ERM) that will visually represent the relationships between the tables.

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.Weight: 20%

Did not submit or incompletely constructed 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. Did not submit or incompletely provided a copy of your working code as part of the paper.

Partially constructed 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. Partially provided a copy of your working code as part of the paper.

Satisfactorily constructed 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. Satisfactorily provided a copy of your working code as part of the paper.

Thoroughly constructed 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. Thoroughly provided a copy of your working code as part of the paper.

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

Did not submit or incompletely constructed a trigger that will increase the field that holds the total number of tours sold per salesperson by an increment of one (1).

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

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

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

3b. Create a query that can produce results that show the quantity of customers each salesperson has sold tours to. Weight: 10%

Did not submit or incompletely created a query that can produce results that show the quantity of customers each salesperson has sold tours to. 

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

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

Thoroughly created 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.Weight: 20%

Did not submit or incompletely supported the reasoning behind using Stored Procedures within the database as an optimization process for the database transactions.

Partially supported the reasoning behind using Stored Procedures within the database as an optimization process for the database transactions.

Satisfactorily supported the reasoning behind using Stored Procedures within the database as an optimization process for the database transactions.

Thoroughly supported the reasoning behind using Stored Procedures within the database as an optimization process for the database transactions.

5. Clarity, writing mechanics, and formatting requirementsWeight: 10%

More than 6 errors present

5-6 errors present

3-4 errors present

0-2 errors present

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

1. Imagine that you have been asked to write a opinion for an environmental magazine about the success of global initiatives in solving environmental concerns, using the Montreal Protocol and ozone depletion as a focus. You can use some of the information in this lesson to help you get started, but you will have to do some additional research on the Internet. Use at least two sources, and list them in a properly formatted bibliography.( 2 mark)

In your opinion piece, clearly indicate whether you feel the Montreal Protocol has been a success or failure (1 mark). Provide three detailed explanations to support your opinion(3 marks). Check your spelling, grammar, and punctuation, and make sure you use scientific terms and symbols correctly (3 marks).

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"