Consider the social issue identified in the previous week. (Cell Phone usage while driving)

Identify your target audience ( High School students, and highlight their key characteristics and concerns.

Develop a campaign to persuade the high school students to adopt the solutions that you identified during the previous week.  (You may modify the solutions that you proposed if you wish).

Select the most appropriate media tools to persuade your intended audience to accept your proposed solution to your chosen social issue. Possible tools include a political campaign, a city council proposal, an editorial article, a commercial, a radio-style podcast, a comprehensive political pamphlet, an interactive game, a website, and so forth. Focus on creativity and on solid persuasive technique.

Create a presentation to summarize your campaign. Include the following in your presentation:

• A discussion of the key characteristics of your target audience
• An explanation of the main persuasive strategies and arguments that you will employ, and why you expect these to be effective
• Organize your work in a Microsoft^® PowerPoint^® presentation of 3 to 4 slides. (This slide count does not include bookkeeping slides: title page, notes, etc. The slide count listed above should only include content slides.) Include detailed descriptions of audio/visual, internet, or other media used in your persuasive campaign.  

Format your assignment according to appropriate course level APA guidelines.

 YOU NEED A MINIMUM OF 3 REFERENCES (BIBLIOGRAPHY) THAT SUPPORT WHAT YOU ARE SAYING/TRYING TO PROVE. 1 SOURCES CAN COME FROM THE INTERNET. THE REST OF THE SOURCES NEED TO COME FROM BOOK(S), ARTICLES, ETC. THAT CAN BE EBOOKS OR ONLINE BOOKS.  FOLLOW APA FORMAT FOR CITING SOURCES AND PUTTING TOGETHER A SUCCESSFUL BIBLIOGRAPHY.

A multinational tour operator agency has gained new business growth in the North American market through the use of social media. Its operation has expanded by 50% within six months and the agency requires an enhanced data management strategy to sustain their business operations. Their existing data repository for its reservation processing system is limited in business intelligence and reporting functionalities. The tour operator seeks a database management specialist to assist them in leveraging their data sources to enable them to forecast and project tour sales appropriately.

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

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 Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice. The completed diagrams / charts must be imported into the Word document before the paper is submitted.

The specific course learning outcomes associated with this assignment are:

• Explain the fundamentals of how data is physically stored and accessed.
• Compose conceptual data modeling techniques that capture information requirements.
• Design a relational database so that it is at least in 3NF.
• Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.
• Use technology and information resources to research issues in the strategic implications and management of database systems.
• Write clearly and concisely about topics related to the strategic planning for database systems using proper writing mechanics and technical style conventions.

Resources: The University Library or the Electronic Reserve Readings

Identify a business research project in your own business or locate a business research article in the library. This project should be one that you perceive to be conducted in an ethical manner.

Write a 700- to 1,050-word paper in which you create a set of ethical research guidelines for the research:

• Summarize the business research project or article.
• What unethical research practices should be avoided in this project?
• Which particular parties involved in the research could face injury? What injuries could occur?
• How could unethical behavior in this research affect the organization, the individual, and society?
• How could the unethical behavior be monitored or resolved if found to be occurring?

Format your paper consistent with APA guidelines.

Utilize two citations

essay about the engineering of the pyramids

Assignment 5: Business Admin 
Due Week 10 and worth 400 points

Select a publicly traded corporation for which you would like to work or are currently working.

Research the corporation on its own Website, the public filings on the Securities and Exchange Commission EDGAR database (http://www.sec.gov/edgar.shtml), in the University’s online databases, and any other sources you can find. The annual report will often provide insights that can help address some of these questions.

Write an eight to ten (8-10) page paper in which you:

1. Determine the impact of the company’s mission, vision, and primary stakeholders on its overall success.
2. Analyze the five (5) forces of competition to determine how they impact the company.
3. Create a SWOT analysis for the company to determine its major strengths, weaknesses, opportunities, and threats.
4. Based on the SWOT analysis, outline a strategy for the company to capitalize on its strengths and opportunities, and minimize its weaknesses and threats.
5. Discuss the various levels and types of strategies the firm may use to maximize its competitiveness and profitability.
6. Outline a communications plan the company could use to make the strategies you recommend above known to all stakeholders.
7. Select two (2) corporate governance mechanisms used by this corporation and evaluate how effective they are at controlling managerial actions.
8. Evaluate the effectiveness of leadership within this corporation and make at least one (1) recommendation for improvement.
9. Assess efforts by this corporation to be a responsible (ethical) corporate citizen and determine the impact these efforts (or lack thereof) have on the company’s bottom line. Provide specific examples to support your response.
10. Use at least five (5) quality references. Note: Wikipedia and other Websites do not quality as academic resources.

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; 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 page length.

The specific course learning outcomes associated with this assignment are:

• Determine ways in which the vision, mission, and stakeholders of a firm impact that firm’s overall success.
• Identify how the six segments of the general environment affect an industry and its firms.
• Identify the five forces of competition.
• Analyze the external environment for opportunities and threats that impact the firm.
• Analyze the internal environment of a company for strengths and weaknesses that impact the firm’s competitiveness.
• Identify various levels and types of strategy in a firm.
• Predict ways in which corporate governance will affect strategic decisions.
• Assess the relationship between strategy and organizational structure.
• Use technology and information resources to research issues in business administration.
• Write clearly and concisely about business administration using proper writing mechanics.