Question
From the table below. Draw 1NF diagram. Also indicate partial dependencies and transitive dependencies. The table uses a 2 key composite primary key. Client Name
From the table below. Draw 1NF diagram. Also indicate partial dependencies and transitive dependencies. The table uses a 2 key composite primary key.
Client Name | Client Address | Service Type | Cost | Technician | Vehicle ID |
Kim Johnson | Worthington | Mowing | 25.00 | Carlos | L2 |
John Jacob | Dublin | Mowing | 75.00 | Lulu | L3 |
John Jacob | Dublin | Aeration | 120.00 | Lulu | L3 |
John Jacob | Dublin | Fertilizing | 75.00 | Albert | L4 |
Barbara Waller | Worthington | Mowing | 50.00 | Carlos | L2 |
Charles Leafy | Hilliard | Mowing | 60.00 | Louie | LT1 |
Heinz Katch | Powell | Aeration | 255.00 | Louie | LT1 |
Carrie Fishman | Columbus | Fertilizing | 45.00 | Gina | T25 |
James Summer | Dublin | Mowing | 60.00 | Sam | L21 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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