Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
Make and state any reasonable assumptions for each of the 2 problems described below. Treat each problem separately. Do not assume the problem away!...
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