Our Services

Get 15% Discount on your First Order

In this assignment you will create the FINANCING_PLANS, SALES_FINANCINGS, and

November 4, 2021

In this assignment you will create the FINANCING_PLANS, SALES_FINANCINGS, and SALESPERSONS tables and fully populate them. You will not be creating the other tables in the ERD.

You will be making up your own data and in many cases you will need to reuse the same customer, vehicle, and financing plan data for your sales.

Project 2 is based on Project 1 information

You should use one or more SQL script files to complete this assignment.

Here are the specific assignment steps. In order to earn full credit you must keep your steps in order, number your steps, and put everything in a single file.

1) Create the FINANCING_PLANS table and populate it with at least 5 (five) rows of data.

2) Add more rows as necessary to your VEHICLES table so that you have at least 50 (fifty) rows of data total. Execute a “SELECT COUNT(*) FROM vehicles” statement after you have added all your new data. Show the INSERT SQL statements you used and the SELECT COUNT(*) statement.

3) Create the SALESPERSONS table and populate it with at least 10 (ten) rows of data. Add a Dealer_ID column but don’t set it as a foreign key to the DEALERSHIPS table yet since you won’t be creating that table until a later project.

4) Add more rows as necessary to your CUSTOMERS table so that you have at least 100 (one hundred) rows of data total. Execute a “SELECT COUNT(*) FROM customers” statement after you have added all your new data. Show the INSERT SQL statements you used and the SELECT COUNT(*) statement.

5) Add more rows as necessary to your SALES table so that you have at least 200 (two hundred) rows of data total. Execute a “SELECT COUNT(*) FROM sales” statement after you have added all your new data. Show the INSERT SQL statements you used and the SELECT COUNT(*).

Share This Post

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

Related Questions

In what way has the situation of the Australian aborigines changed

The work to be done can be divided into three different parts: 1. Culture Studies/Research The very first thing to do is to look at the goals above and then choose a subject that you find interesting. Secondly, you should narrow things down a bit, formulating a question/problem that you

The case is: Enron Case! Please check the instructions in the uploaded file below and make sure to use Harvard style. 1 ACC3155 FINANCIAL

The case is: Enron Case! Please check the instructions in the uploaded file below and make sure to use Harvard style. 1 ACC3155 FINANCIAL STATEMENT ANALYSIS AND VALUATION ACADEMIC YEAR 2023-2024 Detailed requirements and marking criteria for Group Assignment You are required to work in a group of 2-3 members

Week 3 Assignment – Value Proposition in Patient Care Paradise

Week 3 Assignment – Value Proposition in Patient Care Paradise Hospital, Inc., is a for-profit hospital. As the facility’s new hospital administrator, you have been tasked with improving the service value of the hospital. The administration has not done this process since the hospital began operating in 1995. The investors

Paper – Drug Control policy Controlling the use and abuse

Paper – Drug Control policy Controlling the use and abuse of drugs has been a long standing battle in our society. What theories have the most relevance in addressing drug use and addiction? Describe and explain how theories can help us formulate effective polices for addressing drug use in the

This week, let’s look at safety and policies in the

This week, let’s look at safety and policies in the lab environment. Safety in the workplace is extremely important. Several government agencies oversee this in addition to corporate or business policies. What is the difference between guidelines and regulations? Where would you look to find rules and regulations in order to meet

Based on your reading about Michelle (Case Study #1): 1)

Based on your reading about Michelle (Case Study #1): 1) Briefly describe how the therapist demonstrated two techniques common to psychodynamic therapy that you saw the therapist use in Case Study #1. 2) If Michelle were your client, what would you identify as the issue to address first? Why?

TOPIC: Promotional Materials Continue with the organization and situation you

TOPIC: Promotional Materials Continue with the organization and situation you selected for your Topic 2 assignment. Based on your selected organization and situation, design one of the following promotional materials to communicate and promote your solution to the situation: a social media post a flyer a poster internal newsletter Use

, summarize four selected and approved research articles. Sources must

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

Write a 2-3 page paper in which you: Explain the

Deliverable 5 – Interpreting Key Performance Indicators Assignment Content Competency

CompetencyEvaluate operational performance using analytic and comparative techniques. Student Success CriteriaView the grading rubric for this deliverable by selecting the “This item is graded with a rubric” link, which is located in the Details & Information pane. ScenarioYou are the manager of a financial planning and analysis team. The executive

American Association of Critical-Care Nurses

Research a Professional Nursing Association that is relevant to your practice or professional role. • Template for Professional Nursing Association discussion assignment: 1. State the Name of the Association in the title of your post. 2. Provide the mission/purpose of the association, web site and cost of membership. 3. Discuss

Please answer each question in complete paragraph. Do not repeat the questions. All answers should be followed by a reference

https://webapps.srm-app.net/CanvasContent/SF/WCU_NURS_440_OL_TEMPLATE/Presentations/Nurs440%20Overstaffing/story_html5.html After you view the case study, reflect upon what

https://webapps.srm-app.net/CanvasContent/SF/WCU_NURS_440_OL_TEMPLATE/Presentations/Nurs440%20Overstaffing/story_html5.html After you view the case study, reflect upon what you have learned and how it is related to the learning materials. Compare the case study to your nursing practice and give a similar example from your experience in which you might have run into staffing issues. Your reflection content

Explore the elements of poetry

English Composition II Poetry Paper Assignment Three Rough Draft Due: see syllabus Final Draft Due: see syllabus Minimum: Three Full pages or more (Max 5) Two outside sources. (not including Works Cited) For this assignment, you will explore the elements of poetry. You will concentrate your main argument for this

Select at least two medications

You will select an article from an academic, peer reviewed journal on any of the topics that were presented as case studies. For example you may select the topic of CHF, Diabetes, Hypertension, etc. You will select at least two medications to research that pertain to the chosen topic The

Now that you have completed a series of assignments that

Now that you have completed a series of assignments that have led you into the active project planning and development stage for your project, briefly describe your proposed solution to address the problem, issue, suggestion, initiative, or educational need and how it has changed since you first envisioned it. What

Please respond directly to the below classmate post. Minimum of

Please respond directly to the below classmate post. Minimum of 100 words. In this new age, it seems like technology is taking things towards a height that most people wouldn’t have imagined it reaching 50 years ago. When you think of New Age Technology is the first that you

Much as modern travelers rely on tools to plan, research,

Much as modern travelers rely on tools to plan, research, and implement journeys, nurse informaticists, and others have at their disposal tools to best approach the evaluation of HIT and healthcare information systems. But not every tool is appropriate for every situation, so an understanding of goals and which measures