Problem Description:

Consider the following task report for Speedy Lawn Care Service. Normalize the report to 3NF.

Client Name	Client Address	Service Type	Cost ($)	Technician Name	Vehicle Ident. #
Kim Jones	Worthington	Mowing	25	Carlos	L2
John Smith	Dublin	Mowing	75	Fred	L1
		Aeration	120	Louie	LT1
Barbara Wentz	Wothington	Mowing	50	Carlos	L2
Charles Lee	Hilliard	Mowing	60	Louie	LT1
Heinz Schmidt	Powell	Aeration	255	Louie	LT1
Carrie Fisher	Columbus	Fertilizing	45	Gina	T25

The purpose of the question is to demonstrate the normalization of relation to third normal form. The proper technique of identifying the functional dependencies in relation and removing them by the process of creating new relations should be used.

I need to Normalize the reports described in the problems section below to 3rd Normal Form explaining each step as applied to the problems.

Also, need to state the assumptions. Nothing can be added to the initial relation beyond the attributes (columns) in the report such as a surrogate key to make the dependencies go away.