Account Comparison
Create a diagram comparing accrual and cash accounting.
Also include a 350- to 700-word summary of the differentiation and uses of the two.
Cite 3 peer-reviewed, scholarly, or similar references to support your paper.
Week 6 Assignment 5 Submission
https://pslogin.strayer.edu
If you are using the Blackboard Mobile Learn iOS App, please click “View in Browser”
Click the link above to submit your assignment.
Students, please view the “Submit a Clickable Rubric Assignment” in the Student Center.
Instructors, training on how to grade is within the Instructor Center.
Assignment 5: Tour Operator Agency Database
Due Week 6 and worth 90 points
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:
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 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.
2. 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.
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.
Click here to view the grading rubric.
Select an organization as the target for your Electronics Management Plan. This organization will be used as the basis for the individual assignments; feel free to identify a hypothetical organization
1.Explain the purpose and importance of an Electronics Management Plan.
2.Give a brief description of the organization (can be hypothetical) where the Electronics Management Plan will be implemented. Include the company size, location(s), and any other pertinent information.
3.Identify the type of investigation that the organization is conducting (e.g., fraud, insider threat, etc.).
4.Discuss the potential types of media that could be involved in the case (e.g., the architecture of seized media).
5.Discuss the different architecture of seized media depending on the use or industry (e.g., government, military, or police)
This is the guidelines for this comprehensive exam, please read this carefully before starting to work on questions/cases:
The Questions
• The exam has six questions to be answered and submitted separately, dealing with Strategy, Marketing, Operations Management, Managerial Economics and Quantitative Analysis, Finance, and Human Resource Management.
• Read the case, all of the questions, and any specific instructions that accompany them. The requirements of the question will usually determine the general structure of your essay.
• Sort question requirements into major and minor points.
• Determine if there are clues to the type of analysis or presentation to be used and whether you are required to give a recommendation or conclusion.
Case Information
• One case is used for the exam, and all questions are based on this case.
• Organize the case information. First read the case and immediately start answering questions. This is inadvisable. Organize the information according to the functional areas – Strategy, Human Resource, Marketing, Finance, Operations and Managerial Economics.
• Rely on data that is in the case even if you know what happened later or elsewhere. Unless otherwise noted, assume you are writing at about the same time as the events in the case occur.
• Finding more information about the organization in the case usually is not productive unless specifically requested in an exam question. Outside references may be used to make reasonable assumptions about the general business environment.
• Find a focus or filter for analyzing the relevant material from the case. For instance, are chains of causality evident? Can points of view be contrasted and compared? Are there trends, gaps, or blind spots?
Course Methods and Frameworks
• Identify what concepts and theories from your textbook(s), courseware, and discussions can be brought to bear on the particular question.
• Select methods or frameworks with which to organize your case data.
• Limit yourself to material from the specific course the question is based upon.
Organization and Presentation
• Review the information below:
Remember that exceeding the 1,000-word limit by more than 5% will result in a penalty. The marker/evaluator will delete the excess words from the end of the document and will then evaluate the assignment. For example, if the “Recommendations” section is deleted, no marks will be given for “Recommendations.”
A cover sheet, executive summary, table of contents, and bibliography are not required, but a list of references is required
Presentations in tables or any other format placed in the main part of the paper are included in the word count.
Appendices are not included in the word count, but it is important that they are used appropriately and in a limited way. The markers will not peruse the appendices to find important answers. For instance, having a table detailing calculations in an appendix is fine as long as the important points are distilled and included in the main body of the response. If there is an error, these details help the coach to see whether the error was a conceptual error or a simple calculation or typing error.
Likewise, endnotes and footnotes are not included in the word count. Like appendices, they should not provide critical content information, but only non-essential information that may be referenced by the reader.
While the percentages for each part and sub-question are a guide, how you want to divide the work limit among the various parts of a question is up to you, unless otherwise specified in the exam question.
Where point form or bulleted lists are used, make sure that these adequately communicate your thoughts.
Save your answers for each question of the exam in separate MS Word documents using the following file name format: Q#.docx (where Q# refers to the question number). For example, your answer to Question 1—Strategy would be saved as Q1.docx.
• It is helpful to prepare an outline of your answer, using the parts and sub-questions to create headings and sub-headings in the outline. List the major points of your answer to each part or sub-question along with notes on the sources you wish to cite from your course materials and relevant parts of the case. This outline can keep you on track when you begin writing your answer so that key points are not missed and minor points do not derail your thought process. Noting your sources helps you check that you have the correct facts and figures from the case, that you are drawing on the relevant concepts and theories from your course materials, and that you have referenced your sources properly.
• Use the précis style when writing your answers:
Keep introductions and conclusions short.
Clearly state any assumptions.
Make each paragraph one complete unit of thought. The first sentence of each paragraph should state what it is about. Break up long paragraphs.
Avoid copying long passages into your essay. Incorporate them by reference.
Use the active voice (good resources are Strunk’s The Elements of Style [4th ed.] referred to in your MBAO Study Guide or your Prentice Hall Reference Guide for Canadian Writers).
Use grammar and spell checkers as necessary. Review and edit your work as needed.
• Check your citations for correct APA format and prepare a Reference list (for only those sources you actually cited, a bibliography is not needed).
Ways to Increase Your Mark
• Each question must be awarded a 70% grade to be considered a pass. Students are allowed only one sub-70% mark to successfully pass the exam. It is acceptable to submit only five answers. Any answer not submitted will be treated as a fail.
• Based on marker feedback, papers receiving lower marks typically have the following problems:
Do not display a logical thought process that proceeds from statement of the issue to presentation and analysis of relevant data and then to a firm conclusion.
Fail to differentiate between highly important and less important issues. As a result, too many objectives are addressed. Read the question carefully to understand what is being asked.
Indicate that students have difficulty reading or following instructions – for example, adhering to word limits or using appropriate font and font size.
Step 1:
Step 2:
Step 3:
Step 4:
The deliverables for this project are as follows:
Case Analysis – British Airways
Instructions
Read the “Changing the Culture at British Airways” case and submit a case analysis paper using the following guidelines:
PAPER FORMAT
I. Problem(s) you identified from the case
a. Macro: These are the major, overarching problems you see. You should strive to identify three primary issues
b. Micro: These are the less obvious, more nuanced issues that may be inferred. These may also be root causes of the greater aforementioned, “Macro”
issues above
II. Causes: Detail the reasons (causes) for these Macro and Micro problems. Address what caused these problems to arise in the first place (every
problem has a cause). Use the text findings as well as insert YOUR OPINION. Explain in detail why things you present/identify are a problem. Expand a bit
on diagnoses. As a business thinker, you are in the “business” of not only identifying problems, but explaining why they are an issue.
III. Organizational Systems Affected: These are specific factors that caused the organizational problems and/or exacerbated the Macro and Micro
problems. Explain each of these particular areas in your analysis.
a. Structural: Hierarchy, Organizational Structure, Reporting Structures, etc.
b. Psychosocial: Culture, Leadership, Team Dynamics, Morale, etc.
c. Technical: Systems, Technology, Hardware, Supporting Tools, etc.
d. Managerial: Approaches to management, oversight, measurement, monitoring, problem correction
e. Goals and Values: Organizational goals, Values or Mores of the Organization
IV. Recommendations and Implementation Plans: Your recommendations, as if you were the CEO of the organization and how you would implement these
recommendations. Be specific.
Electoral College Essay
Write an essay of 750-1,000 words in which you:
1. Describe the structure and function of the electoral college.
•How and when was it created in the U.S.?
•Why was it created, and by whom?
2. Compare the electoral college to a popular vote approach for elections.
•How does the electoral college system operate/function?
•What are consequences of using an electoral college system versus a popular vote? Use the 2000 presidential election as an example.
3. Assess the value of an individual citizen’s vote under the electoral college system.
•Why does the U.S. still use the electoral college for presidential elections today?
|
Please carefully read through the uploaded document for more detailed instructions. I have attached my usual assignments through the course and a sample research paper to help guide you in your assignment.
Kindly read the sample paper carefully, noting how the writer addresses all the requirements of the paper. In addition, it is better to use quotes from the Northouse’s textbook to explain the basic tenets of the theories/concepts used. You will strengthen your paper if you provide at least some summary of the basic tenets of the theories/concepts used; acknowledge what might be some specific limits/weaknesses and/or assumptions the theories in analyzing the leader. This paper is not about leadership in general. The assignment requires you to discuss this leader through the specific lenses of the theories stated in the assignment. This will require you introduce and explain each theory and then provide specific examples from this leader’s performance as a leader. The paper should (1) include relevant descriptive facts about the individual, (2) provide an analysis of his/her approach to leadership using the leadership theories/concepts discussed to provide insight into what makes the person an effective leader (traits, skills, followership, behaviors and styles), (3) offer a summary of leadership lessons to be gleaned from this individual’s experiences. In addition, your research sources should be from Academic Journals, well-researched articles, and books. (Number of Sources: at least 9; can be more than 9). For anything that relates to the explanation of the theories in the paper, it is better to quote or paraphrase the words of Northouse (textbook) instead of outside source. I would like to write my analysis paper on Jack Ma, who is the founder and executive chairman of Alibaba Group. Ma used to be an English teacher earning tiny wage in early 1990s in China. In 1999, he founded the website Alibaba.com, a B2B portal to connect Chinese manufacturers with overseas buyers. Within 20 years, in July 2017, Alibaba’s market cap reached to USD$389 billion. My suggestion is to analyze Ma’s leadership through trait approach, skills approach, LMX theory, transformational theory, authentic theory, and possibly behavioral approach. If you can relate Ma’s leadership examples to any other theories, you are welcome to do that.P(5.u) Prime Essay Services , written from scratch, delivered on time, at affordable rates! |
Paraphrase the attached file: 1- without changing the meaning 2- must not add new ideas from the author 3- Avoid long sentences 4- must include in text citation 5- make sure it is well paraphrase in order to approve the file without asking for modification 6- keep the same order of the file 7- no need to use complicate words 8- the way of the paraphrasing must be like the order 155229007
P(5.m)
Prime Essay Services , written from scratch, delivered on time, at affordable rates!
Awesome! We will spare no effort to give you a most pleasant experience.
But, that’s not all
You get a massive 35% on your first order
Get Discount NowOur record is the best in the industry but this is hardly a surprise; we handpick our writers after they are proven to be consistent, reliable and completely able in their areas of expertise.
Order your custom essay paper, research paper NOW and we’ll turn your frustrations into a sigh of relief
Order Now