Assignment 5: Tour Operator Agency Database

Assignment 5: Tour Operator Agency Database
May 20, 2016 by
Assignment 5: Tour Operator Agency Database
The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server.
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:
Design a data model that will conform to the following criteria:
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.
Create naming conventions for each entity and attributes.
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.
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.
Using the salesperson table described in the summary above, complete the following:
Construct a trigger that will increase the field that holds the total number of tours sold per salesperson by an increment of one (1).
Create a query that can produce results that show the quantity of customers each salesperson has sold tours to.
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.
Answer not yet available
To have this question done by our pool of professional writers, you can resubmit it here
Categories
Uncategorized
Control Functiont Analysis
International Business

Read more

Machiavelli Medici

Machiavelli Medici
May 17, 2016 by
Machiavelli Medici: What was Machiavelli’s view of the Medici’s in Florence?
How has Machiavelli been perceived by Western society since the publishing of The Prince?
What was Machiavelli’s position on the Roman Catholic Papacy?
What was Machiavelli’s philosophy of God?
Was Machiavelli’s political philosophy evil and immoral? Why or why not?
Use MLA format only 7 paragraphs scholarly source (2)
Click here to view the answer
Categories
Uncategorized
Walmart SWOT Analysis
External and Internal Environments

Read more

Capital Budgeting

Capital Budgeting
May 20, 2016 by
Capital Budgeting
Critically reflect on the importance of capital budgeting. Why is this such a heated subject in many boardrooms? How does capital budgeting promote the financial health of an organization? How will you use the financial techniques you have learned this week to promote the financial health of your organization?
To have this question done by our pool of professional writers, you can resubmit it here
Categories
Uncategorized
Week 3 Discussion 2 Supply Chain
How to Prevent Stress from Shrinking Your Brain

Read more

Project proposal: Augmented Reality

Project proposal: Augmented Reality
May 17, 2016 by
Project proposal: Augmented Reality
Project proposal: Augmented Reality: This is an individual project. Please write a proposal to propose a project which you would like to take on while you matriculate in your respective academic program (Augmented reality). Your proposal should include the following
Title of the Project and your name
Summary: summarize the proposal in 3-5 sentences
Problem statement: what problem you are trying to solve
Related works: how other people are solving it
Methodology: how you are going to solve it
Design of experiment: how you are going to prove your method is working. What dataset / test cases you are going to use, how many dataset/test cases you are going to use
Reference
Resource to find experimental data: http://archive.ics.uci.edu/ml/
Requirements:
Length of the proposal: no more than 2 pages (not including reference).
Formatting: Single space. Font size: 12 point. Margins: 1 inch on each side
Must contain all the sections/information above.
I have upload 4 papers for you, it’s just an example about what you should do and give you some ideas.
Click here to view the answer
Categories
Uncategorized
Health belief model
Discrimination towards minorities

Read more

Queue Portrait Kate Matsudaira

Queue Portrait Kate Matsudaira
May 17, 2016 by
Queue Portrait Kate Matsudaira
View the video interview; Queue Portrait Kate Matsudaira.http://queue.acm.org/detail_video.cfm?id=2488366
Prepare a short synopsis of the article, include reference for your source
Describe how the article relates to the topic(s) covered in the text
Include a summary paragraph about how the topic compares and contrasts with your own experiences
Click here to view the answer
Categories
Uncategorized
Active acquired immunity
Augmented Reality Discussion

Read more

Corporate Social Responsibility

Corporate Social Responsibility
May 17, 2016 by
Corporate Social Responsibility.
Corporate Social Responsibility: Your paper must be 500-700 words and be in APA format
Review the links below about the 2010 oil spill in the Gulf of Mexico:
Article 1: http://www.pbs.org/wgbh/pages/frontline/the-spill/bp-troubled-past/
Article 2: http://www.nytimes.com/2013/08/20/science/earth/new-analysis-of-gulf-oil-spill.html?_r=1
Article 3: https://www.nwf.org/What-We-Do/Protect-Habitat/Gulf-Restoration/Oil-Spill.aspx
Article 4: http://www.nola.com/news/gulf-oil-spill/index.ssf/2013/04/national_wildlife_federation_s_1.html
Article 5: https://archive.epa.gov/bpspill/web/html/
Imagine that you have been hired by a company to improve its image. Complete the following:
Put together an action plan that will help improve its corporate social responsibility efforts and pay more attention to environmental ethics.
The action plan must outline 4 major image issues with its stakeholders and what steps the company can take to improve upon its image.
Apply corporate social responsibility and environmental ethics in your paper.
References
Fountain, H. (2013, august 19). Gulf spill sampling questioned. The New York Times. Retrieved from http://www.nytimes.com/2013/08/20/science/earth/new-analysis-of-gulf-oil-spill.html?_r=1&
National Wildlife Federation. (2014). How does the BP Oil Spill impact wildlife and habitat?Retrieved from https://www.nwf.org/What-We-Do/Protect-Habitat/Gulf-Restoration/Oil-Spill/Effects-on-Wildlife.aspx
PBS. (2010, October 28). BP’s troubled past. Frontline. Retrieved fromhttp://www.pbs.org/wgbh/pages/frontline/the-spill/bp-troubled-past/
Schleifstein, M. (2013, April 2). National Wildlife Federation says environmental effects of BP spill far from over. The Times-Picayune. Retrieved from http://www.nola.com/news/gulf-oil-spill/index.ssf/2013/04/national_wildlife_federation_s_1.html
United States Environmental Protection Agency. (2013, February 12). EPA response to BP spill in the Gulf of Mexico. Retrieved from http://www.epa.gov/bpspill/
Click here to view the answer
Categories
Uncategorized
External and Internal Environments
Advanced Tort Law

Read more

LEARNING THEORIES AND DIVERSITY(Staff Development Educator in a Clinical Facility)

LEARNING THEORIES AND DIVERSITY(Staff Development Educator in a Clinical Facility)
August 22, 2022 by zuixy
Create a 5-7-page high-level teaching plan for a diverse learning environment that is designed around an appropriate educational theory.
Introduction
When beginning to design a course, nurse educators need to identify the learning theory or theories that will form the foundation of a course’s design, and to consider the needs of the population of learners who will take the course.
Note: Assessments in this course build on each other and must be completed in sequential order.
It is important to consider the role of diversity and learning environments when selecting appropriate theories and approaches for a desired learning outcome. For this assessment, you will implement these considerations in an educational environment of your choosing.
Preparation
Take time to review educational theories that you have studied in prior courses or used in your work. Do additional research on educational theories and approaches as necessary.
Optional: Practice implementing these considerations in the Vila Health challenge provided in the Resources before beginning your work here.
As you prepare to complete this assessment, you may want to think about other related issues to deepen your understanding or broaden your viewpoint. You are encouraged to consider the questions below and discuss them with a fellow learner, a work associate, an interested friend, or a member of your professional community.
Note that these questions are for your own development and exploration and do not need to be completed or submitted as part of your assessment.
Think about some of the most effective educators you have learned with and from. What characteristics made these educators “good”?
How can nurse educators tailor their teaching methods in order to foster student engagement across multiple generations?
Have you ever completed a learning style inventory? If so, do you feel like it adequately assessed your learning style? Why or why not? (If you have not completed one, you might want to search for a free inventory online to see how its results align with your self-knowledge.)
How can you prepare yourself to be a culturally competent educator?
Instructions
For this assessment, you will create a 5–7-page high-level teaching plan in which you do the following:
Select a topic for a course that you would like to teach in an educational environment. (For example, maybe you would like to be a nursing instructor in an institution of higher learning, a staff development educator in a clinical facility, or a patient educator in a hospital.) Briefly describe your course and the environment that you will utilize for teaching. Also describe the intended audience for your course.
Select an educational theory that you could use to guide the development of your course. Describe the key points of the theory you selected and explain why you think this theory fits the topic, audience, and context of your course.
Be sure to cite textbooks or articles from peer-reviewed journals to support your choice.
Identify and discuss potential diversity in the group that you anticipate teaching. (Diversity can include multiculturalism, age, gender, ethnicity, socioeconomic status, Limited English Proficiency (LEP), or other cultural barriers that you feel could impact your learning environment.)
Use current research to describe how you will address these issues in your learning environment.
Describe how you will manage conflict in the classroom that may arise from the anticipated diversity among learners.
Additional Requirements
Format: 12-point Times New Roman or Arial font, double-spaced in Microsoft Word.
Length: 5–7 pages, plus a title page and a references page.
Use correct APA format, including running head, page numbers, and a title page.
Writing should be free of grammar and spelling errors that distract from content.
Competencies Measured
By successfully completing this assessment, you will demonstrate your proficiency in the course competencies through the following assessment scoring guide criteria:
Competency 1: Appraise the influence of learner’s culture, gender, and experiences on teaching and learning.
Describe the diversity of an intended group of learners.
Competency 2: Apply educational theory and evidence-based teaching practices when implementing teaching strategies.
Identify a learning theory that applies to a selected educational topic and audience.
Competency 3: Apply a variety of teaching strategies appropriate to diverse learner needs, content, and desired learner outcomes.
Justify the application of a learning theory in a particular context.
Competency 4: Integrate best practices for classroom management
Describe evidence-based strategies for managing conflicts that could arise in a diverse classroom.
Competency 5: Communicate in a manner that is scholarly, professional, and consistent with the expectations of a nursing education professional.
Support a position with effective written communication; use correct spelling, grammar, punctuation and mechanics, and APA style and formatting.
FOCUS WILL BE(STAFF DEVELOPMENT EDUCATOR IN CLINICAL FACILITY
Categories
Uncategorized
LEARNING THEORIES AND DIVERSITY
Articles Critiques

Read more

Try

Try
August 18, 2022 by zuixy
Tdf
Categories
Uncategorized
Well Written email Response
Quality Improvement

Read more

Social Media Marketing Plan

Social Media Marketing Plan
September 2, 2022 by zuixy
word document, 12-point font, times new roman
heading 1- summary
in this paragraph, you give a summary of how you will navigate promoting this item and work up a plan to do such.
heading 2- goals and objectives
under this title, you will discuss the goals and objectives that you will reach by promoting this.
lastly, 3-5 objectives on why you chose the objectives you chose to accomplish with this promotion.
Categories
Uncategorized
Teaching Strategies
Article Summary and Critique

Read more

Managerial Finance Questions

Managerial Finance Questions
May 20, 2016 by zuixy
Managerial Finance Questions
Managerial Finance Questions ***Original Answers Please**** Each question should be labeled and references cited per question. Plagiarism report MUST be attached!!!! Each number answered in full graduate level work required!!!
1. Read the journal article, “Businesses Seeking Working Capital-Survey.” Based on the information presented in the article, discuss the following:
How should a business use working capital analysis?
Which is more important to the short-term lender: the stock of cash or the flow of cash?
Is it possible in today’s business to operate with no current liabilities?
Should be 200-250 words in length.
2. Compare and contrast the Internal Rate of Return (IRR), the Net Present Value (NPV) and Payback approaches to capital rationing. Which do you think is better? Why? Provide examples and evidence from two articles from ProQuest to support your position. Should be 200-250 words in length.
3. Analyze the Capital Asset Pricing Model (CAPM). Using the course text and an article from ProQuest as references, address the following:
Explain how the CAPM assists in measuring both risk and return.
Explain how the CAPM assists in calculating the weighted average costs of capital (WACC) and its components.
Illustrate why some managers have difficulty applying the Capital Asset Pricing Model (CAPM) in financial decision making.
Identify the benefits and drawbacks of using the CAPM.
Develop a 200 – 300 word answer supporting your position.
4. Imagine you are a representative of management in the company you have selected for your Week Six assignment and you must make a capital budgeting decision. The decision is to implement a new computer network system to decrease the time between customer order and delivery. The cost will be 10% of last year’s profits. You are charged with describing the important considerations in the decision-making process to upper management. In your response, be sure to include the following:
A description of the important factors, in addition to quantitative factors, that were considered when making this capital budgeting decision.
An explanation of how these factors are significant to the company.
A summary of how you will determine the criteria to rank capital budgeting decisions and whether some criteria are more important than others.
A calculation of the proposed return on investment based on criteria you select and justification for that ROI.
Develop a 200 – 250 word explanation supporting your recommendations.
Tip: For help with reading an annual report access this handy guide from Money Chimp(http://www.moneychimp.com/articles/financials/fundamentals.htm)
5. Go to MSN Money. (http://investing.money.msn.com/investments/key-ratios) and type in a ticker symbol for a company with the first letter of your last name.
Next, complete the following:
Select “Key Ratios” on the left menu panel.
There are several categories listed for ratios. Select one “Financial Condition Ratio” and one “Management Efficiency Ratio”.
Open the Profile section on the left menu panel and you will see “Industry” is identified. Find a competitive company within that industry and compare those ratios to the ones you just found.
Examine your findings and determine whether your company outperforms its competition based on financial ratios. Identify where your firm seems to lag. Describe how your firm compares with the industry and speculate as to why you believe your firm is performing as it is.
Develop a 200 – 300 word answer supporting your position.
Answer not yet available
To have this questions done by our pool of professional writers, kindly send us an email.
Email to support@yourhomeworksolutions.com
You can also browse for similar questions here
Categories
Uncategorized
Psychology Questions
Management of Working Capital Case Study

Read more
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat

Good News ! We now help with PROCTORED EXAM. Chat with a support agent for more information