Question

GTA Landscaping's business is to offer several services to customers. Services include "Lawn Cutting", "Garden Planting", fall "Leaf Clearing", and winter "Snow Shoveling". Each customer may require one or more of these services at a time; and the customer may require the same service repeated several times each year.

GTA Landscaping: User View 1

Below are shown sample invoices for the services our business sells. (An invoice is the same as a receipt). We write a customer invoice once all services are completed for a customer visit. This invoice will itemize many details including the services provided, the time it took to complete those services, the charge for those services, the total of all service charges.

Invoice Statement

INVOICE #:	1355
INVOICE DATE:	5-Jul-19		CUSTOMER:	56 - John Adams
WORK TEAM:	3		ADDRESS:	234 Bloor W
EQUIP. USED:	20 hp John Deer tractor/ mower			M2S 4S3
SERVICES:
SERVICE CODE	DESCRIPTION	HOURLY CHARGE	WORK DURATION (hours)	TOTAL CHARGE
LC	Lawn Cutting	$25.00	0.75	$18.75
LW	Lawn Weeding	$35.00	1.15	$40.25
LF	Lawn Fertilizing	$15.00	0.25	$3.75
TG	Tree Pruning	$45.00	0.50	$22.50
				SUBTOTAL: $85.25

Writes UNF, 1NF, 2NF and 3NF. Also draw data structure/functional dependency diagram and ERD/EER of your 3NF

Answer 1

1) Normalization upto 3NF

2) Functional dependency diagram for the above relations in 3NF

3) ER diagram for the above relations in 3NF