1. Consider the following task report for Speedy Lawn Care Service. Normalize the single table database to 3NF following the process detailed in class.

ClientName	Address	ServiceType	Price	Technician	VehicleNo
Kim Jones	Worthington	Mowing	25	Carlos	L2
John Smith	Dublin	Mowing	75	Fred	L1
		Aeration	120	Louie	LT1
Barbara Wentz	Worthington	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

You are not allowed to add any new column to the relation. You should identify the primary key and list all functional dependencies.

Show the schema in each step (1NF, 2NF, 3NF), mark the PKs, and the actual data in each table.

When you finish the 3NF normalization, go tohttps://www.db-fiddle.com/ and create the database with the actual data. Compose a SQL query to retrieve every tuple by natural join all tables to verify if your decomposition is lossless (no spurious tuples after join compared to the original data).

Tip: to natural join multiple tables, you can do

SELECT...

FROM table1

NATURAL JOIN table2

NATURAL JOIN table3

...

Include your SQL DDL commands to create the database (CREATE TABLE, INSERT VALUES, etc. ) and your SQL query of verification (SELECT...) in your submission.