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 1 year ago

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 ____________

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?

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.

Using the world_x database you installed on your MySQL Workbench, create a new table named “independence”...

Using the world_x database you installed on your MySQL Workbench, create a new table named “independence” with the following attributes (columns): A field named “id” which has data type auto_increment, A field named “country_name” which has data type varchar(50), and A field named “independence_date” which has type “date.” After you create the table, run the following SQL command: INSERT INTO independence(country_name, independence_date) VALUE (‘United States’,’1776-07-04’) Submit a 1-page Microsoft Word document that shows the following: The SQL command you used...

Database: Question 11 Using the ERD from problem 10, create the relational schema.(Create an appropriate collection...

Database: Question 11 Using the ERD from problem 10, create the relational schema.(Create an appropriate collection of attributes for each of the entities. Make sure you use the appropriate naming conventions to name the attributes.)

in this assignment you will create and use a database to find meanings and synonyms for...

in this assignment you will create and use a database to find meanings and synonyms for given phrases. To do so you will use tables of synsets -- sets of one or more synonyms (specific phrases) that share the same meaning. Your program should: Display a message stating its goal Create a database file using SQLite using your name (i.e. use your name as a file name - for example, my database will be named "nimdvir") In your database, create...

You should explain the confidence intervals you create along with explanations of the meaning of your...

You should explain the confidence intervals you create along with explanations of the meaning of your answers and business implications for each problem. Scenario: You have been asked once again to study the mean tuition at private universities throughout the United States. You will also again study the proportions of universities throughout the United States that regularly award more than 50% of their students some form of financial aid. The specific questions you will be asked to answer are stated...

Question