Part 2: Converting a Spreadsheet to a Database You might encounter something akin to the table below in a spreadsheet or file-based application.

Make	Model	ID	Miles Driven	Date Driven	Mileage Cost	Driver ID	License Number
Honda	Accord	10	38.5	10/23/2012	$20.60	101	032 592 173
Honda	Accord	10	38.5	1/17/2012	$20.60	101	032 592 173
Jaguar	I-PACE Concept	20	90	3/1/2012	$48.15	119	331 997 012
Jaguar	I-PACE Concept	20	90	2/22/2012	$48.15	237	419 953 551
Jaguar	I-PACE Concept	209	20	3/6/2012	$10.70	119	331 997 012
Porsche	718	30	18	10/23/2012	$9.63	119	331 997 012
Lamborghini	Roadster	40	40	1/17/2012	$21.40	213	945 459 123
Toyota	Camry	50	35	1/17/2012	$18.73	314	123 476 991
Kia	Optima	60	40	1/17/2012	$21.40	101	032 592 173
Kia	Optima	60	40	1/24/2012	$21.40	149	842 248 842

Imagine that you want to convert this to a relational database. Answer the following questions, which are progressively more difficult:

How many records does this file contain?

How many fields are there per record?

What are the field names?

What do the records in this table probably represent?

Is there data redundancy in the table? If so, describe it.

Does this table contain data that is part of different entities? If your answer is yes, identify and briefly describe the entities.

Are there any fields you would add when converting this spreadsheet to a database? If your answer is yes, identify each field then briefly describe the reason why you would choose to add it.

Are there other problems you would you need to address in converting this data to a relational database? If your answer is yes, identify and briefly describe each problem.