Answered step by step
Verified Expert Solution
Link Copied!

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Business Communication questions