Create data for the purchase of an automobile. There should be 10 automobiles in your database. You can...

Create data for the purchase of an automobile. There should be 10 automobiles in your database. You can get this from the newspaper or go online and find a site that will give you some possible purchases.

You should use the following fields: Manufacturing, Model, Year, Doors, Cylinders and Sales Price.

1. Print the spreadsheet you created for your data.

2. Create and print 2 pivot tables to find some information you need to help you make your decision.

3. Do a VLOOKUP and a HLOOKUP for the purchase selected. Print a copy of your formula and the result.

4. Use MATCH command to find what position your decision appears on the spreadsheet. Highlight your decision on your spreadsheet.

Expert Solution

V lookup		H lookup
Formula		Formula
Manufacturer	Sales Price	Manufacturer	Model	Sales Price
Honda	"=VLOOKUP(A5,Database!B:G,6,0)"	Honda	Honda City	"=HLOOKUP($E5,Database!$A$17:$K$22,6,0)"
Mahindra	"=VLOOKUP(A6,Database!B:G,6,0)"	Mahindra	Scorpio	"=HLOOKUP($E6,Database!$A$17:$K$22,6,0)"
Audi	"=VLOOKUP(A8,Database!B:G,6,0)"	Audi	A4	"=HLOOKUP($E8,Database!$A$17:$K$22,6,0)"
Porsche	"=VLOOKUP(A9,Database!B:G,6,0)"	Porsche	Cayenne New	"=HLOOKUP($E9,Database!$A$17:$K$22,6,0)"

Value		Value
Manufacturer	Sales Price	Manufacturer	Model	Sales Price
Honda	890000	Honda	Honda City	890,000
Mahindra	930000	Mahindra	Scorpio	930,000
Volkswagen	560000	Volkswagen	Ameo	560,000
Porsche	9500000	Porsche	Cayenne New	9,500,000

Match
Function
Volkswagen	"=MATCH(A22,Database!$B$2:$B$12,0)"
Porsche	"=MATCH(A23,Database!$B$2:$B$12,0)"

Value
Volkswagen	7
Porsche	11

ekkarill92 answered 2 years ago

Create the database with at least 10 employees and 2 managers are populated. Important: your name...

Create the database with at least 10 employees and 2 managers are populated. Important: your name should be in the employee table. Write a Python code that can do the following: 1) Take an employee ID from user 2) Display the output of the SQL, select * from employee; Improve the Python code above that can do the following: 1) Take an employee ID from the user. Let it be idEntered. 2) Get the departmentID for the given employeeID, idEntered....

Redesigning a database involves the process of reverse engineering a legacy database to create a data...

Redesigning a database involves the process of reverse engineering a legacy database to create a data model. There are a host of software tools available to assist with this process. Identify 2 separate tools that will reverse engineer an existing database. What database management systems (Microsoft SQL, Oracle, MySQL, DB2…) will this system work with (list all that apply)? Briefly describe how the tools work for reverse engineering an existing database and the output that the tool provides.

Using your downloaded DBMS (MS SQL Server), create a new database. Create the database tables based...

Using your downloaded DBMS (MS SQL Server), create a new database. Create the database tables based on your entities defining The attributes within each table The primary and foreign keys within each table *****Show your database tables, tables attributes, primary and foreign keys***** Do not forget to check the lesson slides and videos that show you how to convert an ER/EER into a database schema, and how to create a database and tables using MS SQL Server.

Suppose you have decided to purchase an automobile. You analyze your personal budget and decide you...

Suppose you have decided to purchase an automobile. You analyze your personal budget and decide you can afford monthly payments of $506 for five years. If your loan carries an annual interest rate of 12%, what the highest priced car you can afford? a. Excel command ____________ b. answer ____________

Create the Database: The data is the same as was described in the ER Design Project...

Create the Database: The data is the same as was described in the ER Design Project assignment. In that assignment you were asked to map the ER diagram to relations in the database. Here is a formal description of the relations that you will use in this assignment: streamTV Database Relations shows(showID, title, premiere_year, network, creator, category) episode(showID, episodeID, airdate, title) showID is a foreign key to shows actor(actID, fname, lname) main_cast(showID, actorID, role) showID is a foreign key to...

Part 2: You will create five tables in your ColonialAdventureTours database. Please do not write your...

Part 2: You will create five tables in your ColonialAdventureTours database. Please do not write your own SQL Commands for this task, use data found in the following Colonial_create.txt file and copy and paste the commands into MySQL workbench. Then add Primary key, Foreign key, and not null constraints appropriately. Then run your codes. Note: Remember that since you enforced referential integrity (foreign key constraints) that you must create the "primary" tables before you can create the "related" tables in...

A corporate fleet of 30 automobiles costs $900,000. After five years each automobile can be salvaged...

A corporate fleet of 30 automobiles costs $900,000. After five years each automobile can be salvaged for $10,000 each. Each car will be used for 12,000 miles per year. With a MARR of 14%, what is the equivalent annual cost per mile?

Create an example of what a form in a database could look like. The form should...

Create an example of what a form in a database could look like. The form should have 5 fields to get the following information (Music ID, Album Name, Medium Type, Artist Name, and Release Year.) (You can sketch it using Paint, draw it on paper and scan it, use shapes in Word, use wireframe.cc and take a screenshot of the result and turn that in...sky's the limit) Create an example report (same method used as the example form). This report...

Sometimes a data dictionary is called as ‘the database designer’s database’. State and explain your opinion...

Sometimes a data dictionary is called as ‘the database designer’s database’. State and explain your opinion regarding this term and support your position using real-life scenarios.

1- How can database systems improve data quality and data integrity? 2- Discuss database constraints: Primary...

1- How can database systems improve data quality and data integrity? 2- Discuss database constraints: Primary key, check, and referential integrity constraints? Give an example for each.

Question