Our Services

Get 15% Discount on your First Order

You will be given access (read-only) to an existing database

December 16, 2022

You will be given access (read-only) to an existing database – the schema is called “accounting” in the Instructor’s Online Server. You can take a look at the EER diagram here: Accounting ER.mwb Download Accounting ER.mwb (Just don’t use the EER diagram to create your tables – it won’t work – all data is in the Instructor’s Online Server)

You will need to build queries and insert results into tmp views to create the Profit and Loss (P&L) and Balance Sheet (B/S) statements

Your queries must achieve the following:

Receive the year in which the user wants to produce the P&L and the B/S for.
Do the necessary calculations to obtain the net profit or loss for that year.
Use that value, to produce the B/S.
Demonstrarte that A = L + E
Print both the P&L and B/S as clear as possible on the Result Grids
Show the % change vs. the previous year for every major line item on the P&L and B/S
Give some headings to each major account line item. And to each section of the P&L and B/S
Add any additional financial metrics and ratios that could be useful to analyze this start-up.
- Wanna ensure an “A”? Produce a cash flow statement as an added challenge

Students will submit the following:

(60 points) SQL script (if you save it as txt, be sure to keep the adequate indentations – you will receive points for correct syntax, following best practices, comments in the code, correctness, efficiency ):
- While there are multiple ways to approach the building of their P&L and B/S statements, most likely you will need need analytical queries
- be sure to include the comprehensive list of queries in ONE single .sql script that if the instructor runs on their computer, they will be able to obtain exactly the same results as per your P&L and B/S screenshots from #2.
(20 points) Screenshot of their resulting P&L and B/S outputs. You will receive points for correct results, 10 points for correct B/S and 10 points for correct P&L.

https://docs.google.com/spreadsheets/d/1r9CCEYd_KipVA6hhD_-LSe1hAL8KYxkeHas9NFDLU-E/edit?usp=sharing

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Read the following article: Community Health Center Efficiency: The Role

Read the following article: Community Health Center Efficiency: The Role of Grant Revenues in Health Center Efficiency https://pubmed.ncbi.nlm.nih.gov/24117318/ Complete a detailed case study analysis of the given case, using the process described in Analyzing Strategic Health Care Cases in your course textbook Strategic Management of Health Care Organizations. Your completed case

in a 2- to 4-page, create an interview transcript of

in a 2- to 4-page, create an interview transcript of your responses to the following interview questions: Tell us about a healthcare program, within your practice. What are the costs and projected outcomes of this program? Who is your target population? What is the role of the nurse in

1) A deeper understanding of how and why we engage

1) A deeper understanding of how and why we engage in politics the way we do, and how we can act otherwise 2) Some tools for acting in solidarity around our shared needs (Feb 10, 2020). Passion Isn’t Enough: The Rise Of ‘Political Hobbyism’ in the United States (Links to an

Module 04 Content A strategic plan is a document used

A strategic plan is a document used to structure and communicate organizational goals. It is also used to mitigate risks and alleviate the potential for legal cases. Barbara receives information that there is an additional, more pressing issue at a satellite clinic that is not documented in the original UCCO

Introducing Pearson Edexcel NVQ/Competence-based qualifications

National Vocational Qualifications (NVQs) or Competence-based qualifications reflect the skills and knowledge needed to do a job effectively. They are work-based qualifications that give learners the opportunity to demonstrate their competence in the area of work or job role to which the qualification relates. NVQs/Competence-based qualifications are outcomes-based with no

While components such as plot, staging, theme, and setting are

While components such as plot, staging, theme, and setting are valuable, the characters offer a unique opportunity for expression and creativity. For this assignment, you will create a character. You will need to loosely select a time period and location setting in order to best develop a realistic character, but

As we have seen in the cases of The Rights

As we have seen in the cases of The Rights and Treatment of Patients, Abortion,Organ Transplants, Genetic Technology and now Death and Dying issues. There are many ethical issues involved concerning right and wrong actions. The issues involving Euthanasia can make it a difficult procedure to control and regulate.

Review the various specialties within the field of Nursing Assignment Help

Review the various specialties within the field of psychology (this list isn’t exhaustive) and discuss which one you would be interested in pursuing if you had to. There is also the option of simply being a general clinical psychologist and that’s fine! After all, that can be its own specialty

St. Thomas University Response to peer; minimum/max 200 words; use correct APA format Nursing Assignment Help

Response #1 Advocacy in the Nursing Profession Advocacy is a fundamental element of nursing. Nurses instinctively advocate for the sick in their homes and at work. Patients usually rely on nurses to guide them through the healthcare system (Kazemnejad, A. 2019). A nurse’s role is to ensure that the patient

Mystic Brewery is a local start-up company formed by two

Mystic Brewery is a local start-up company formed by two brothers and partners, Jake and Pete. Each has their own brewing equipment and they have recently purchased a small building that was once a car sales/body shop to combine their previous disparate businesses into one microbrewery. Your team with

Overview: As a public historian, I fully believe that history

Overview: As a public historian, I fully believe that history is useless without action. It’s not enough to just know about a topic; you need to make people care about and do something with that knowledge. For your final, I want YOU to be a public historian. Figure out a

Based on the work of WestEd for the USDOE, describe

Based on the work of WestEd for the USDOE, describe five common elements of successful magnet high schools and provide examples of ways high schools achieve each element. What are Bush’s main findings regarding the magnet program at “Jefferson High School”. Discuss ways to improve the education of all

Company is: LA fitness Methods (3 potential countries you think

Company is: LA fitness Methods (3 potential countries you think may be feasible to enter; company cannot be in these countries yet) 3-Country Analysis (be detailed and support by data) discuss why you selected the 3 countries discuss the 3 countries selected based on the factors you decided as

The objective of this assignment is to create a press

The objective of this assignment is to create a press kit for a company you are interested in potentially working for. This assignment will require you to conduct research on the company you have selected. Please note this is an “aspirational” assignment, thus meaning you should be approaching this assignment

1. Nicholas Wolterstorff thinks that there are two dualities that

1. Nicholas Wolterstorff thinks that there are two dualities that characterize the political allegiances of Christians. What are these two dualities and what is their relationship with each other? In your answer, please reference at least two biblical passages and/or theological commitments that Wolterstorff uses to ground his two

Developing a Purchasing Process Overview For a hospitality business to

Developing a Purchasing Process Overview For a hospitality business to be successful, the management team must have a strong purchasing process that includes both selection and procurement. This process must be well established in order to control costs and deliver the best possible product or service for its target

In a four-page scholarly paper, address the following: Provide a

In a four-page scholarly paper, address the following: Provide a succinct overview of the model you have selected and discuss how the selected model addresses the four concepts within the nursing metaparadigm (person, health, nursing, environment). Discuss how the selected model qualifies as a theoretical framework within the profession of

You are a principal conducting an informal observation of Ms.

You are a principal conducting an informal observation of Ms. Avery’s eighth grade history classroom. It is the last 10 minutes of class and upon entering the classroom, you observe Ms. Avery seated behind her desk and the students working independently on a worksheet pertaining to the Civil War.