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

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

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

RESPOND TO THIS TWO PEERS CITE APA FORMAT RESOURCES {2019-2024) chinoyere Understanding and exploiting my strengths as a nurse is critical for

RESPOND TO THIS TWO PEERS CITE APA FORMAT RESOURCES {2019-2024) chinoyere Understanding and exploiting my strengths as a nurse is critical for providing excellent patient care and effectively contributing to the healthcare team. Upon completing the StrengthsFinder assessment, my top five Clifton strengths are maximizer, connectedness, achiever, belief, and empathy

Prof.  Nursing leadeweek 4 Peers response  respond to peers thoughtfully, add value to the discussion, and apply ideas, insights, or concepts from

Prof.  Nursing leadeweek 4 Peers response  respond to peers thoughtfully, add value to the discussion, and apply ideas, insights, or concepts from scholarly sources, such as: journal articles, assigned readings, textbook material, lectures, course materials, or authoritative websites. For specific details and criteria, refer to the discussion rubric in the

Population Health Nursing week 4 Peers response  respond to peers thoughtfully, add value to the discussion, and apply ideas, insights, or concepts

Population Health Nursing week 4 Peers response  respond to peers thoughtfully, add value to the discussion, and apply ideas, insights, or concepts from scholarly sources, such as: journal articles, assigned readings, textbook material, lectures, course materials, or authoritative websites. For specific details and criteria, refer to the discussion rubric in

Marketing Strategy Online stores use

Marketing Strategy Online stores use <a href=” codes</a> as a powerful marketing tool. They attract new customers and encourage repeat business by offering discounts. These codes can help clear out old inventory and introduce new products. Customer Loyalty Coupon codes are a way to build customer loyalty. Shoppers are more

MBA 620 Module Five Power BI Executive Summary Guidelines and RubricOverview To measure the financial performance of any company, it is important to

MBA 620 Module Five Power BI Executive Summary Guidelines and RubricOverview To measure the financial performance of any company, it is important to analyze its four key financial statements: balance sheets, income statements, cash flow statements, and shareholders’ equity statements. In this assignment, you will: Visually present the balance sheet

OL 600 Milestone Two Guidelines and Rubric Performance Management: Employee and Labor Relations Overview For this milestone, due in Module Five, you will a

OL 600 Milestone Two Guidelines and Rubric Performance Management: Employee and Labor Relations Overview For this milestone, due in Module Five, you will analyze HR strategic initiatives of employee and labor relations that positively impact organizational effectiveness. The three critical elements focus on employee discipline, performance management, and employee and labor