Consider the following task report for Speedy Lawn Care Service. ClientName |  C

Consider the following task report for Speedy Lawn Care Service.
ClientName |  ClientAddress | ServiceType | Cost($) | Technician Name | Vehicle Ident. #
Kim Jones      Worthington          Mowing          25.00             Carlos                        L2
John Smith         Dublin               Mowing         75.00              Fred                           L3
John Smith         Dublin               Aeration         120.00           Fred                          L3
John Smith         Dublin               Fertilizing        75.00           Albert                         L4
Barbara Wentz  Worthington       Mowing          50.00            Carlos                         L2
Charles Lee       Hilliard              Mowing          60.00             Louie                       LT1
Heinz Schmidt    Powell              Aeration          255.00           Louie                      LT1
Carrie Fisher      Columbus         Fertilizing        45.00             Gina                         T25
James Count       Dublin              Mowing           60.00             Sam                          L21
Assumptions: The task report is for a particular day or week. Client Name is okay as multivalued
attribute for this problem.
Identify Relation in equation form and 1NF dependency
diagram2 (repeat table with all fields filled in … see Figure 6.3 in the text for an example of a 1NF dependency diagram):
Identify Primary Key(s):
Identify Partial Functional Dependencies (A partial functional dependency exists when one or
more nonkey attributes are functionally dependent on part [but not all] of the primary key.) :
Covert to 2NF by removing Partial Functional Dependencies and show in 2NF table structures
and dependency diagrams [see figure 6.4 in the text for an example of 2NF table structures and
dependency diagrams] (If a relation is in first normal form and every nonkey attribute is fully
functionally dependent on the primary key, the relation is said to be in 2NF):
Identify Transitive Dependencies (Transitive dependencies are those where there exists a
functional dependency between two [or more] nonkey attributes) :
Convert to 3NF by Removing Transitive Dependencies and show in 3NF tables structures and
dependency diagrams [see figure 6.5 in the text for an example of3NF tables structures and
dependency diagrams] (A relation is in 3NF if it is in second normal form and no transitive
dependencies exist.).

"Get 15% discount on your first 3 orders with us"
Use the following coupon
"FIRST15"

Order Now