Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following task report for Speedy Lawn Care Service. You are not allowed to add any new column to the relation. You should
Consider the following task report for Speedy Lawn Care Service. You are not allowed to add any new column to the relation. You should identify the primary key and list all functional dependencies. Specify the relation(s) schema with the primary key attribute(s) underlined for 1NF, 2NF & 3NF. 1. Convert the original report to 1NF relation(s) 2. Normalize your 1NF schema to 2nd normal form (2NF). 3. Normalize your 2NF schema to 3rd normal form (3NF) Client Name Kim Jones John Smith Barbara Wentz Charles Lee Heinz Schmidt Carrie Fisher Client Address Worthington Dublin Worthington Hilliard Powell Columbus Service Type Mowing Mowing Aeration Mowing Mowing Aeration Fertilizing Cost ($) Technician Name 25 Carlos 75 Fred 120 Louie 50 Carlos 60 Louie 255 Louie 45 Gina Vehicle Ident. # L2 L1 LT1 L2 LT1 LT1 T25
Step by Step Solution
★★★★★
3.39 Rating (155 Votes )
There are 3 Steps involved in it
Step: 1
Answer I First the table needs to be converted to the first normal form for which we will get Client ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started