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

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 ____________

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.

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.)

Question