lease use the picture to answer the following question Normalize below user view to the third normal form.  Show all steps (UNF, 1NF, Dependencies, 2NF, 3NF).

Principles of Information Systems (MindTap Course List)
12th Edition
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter12: Systems Development: Investigation, Analysis, And Design
Section: Chapter Questions
Problem 1SAT
icon
Related questions
icon
Concept explainers
Question
100%

please use the picture to answer the following question

Normalize below user view to the third normal form.  Show all steps (UNF, 1NF, Dependencies, 2NF, 3NF).

Team - Employee Reports
TEAM
DESCRIPTION
General Contracting
1
NAME
EMP ID: OHIP
HOME PHONE START DATE SKILLS
General
Cindy Lee
Amy Smith
120 219032002 905-338-1234
1-Jan-98 Contractor
122 34111991 905-338-1234
30-Jun-99 Plumbing
TEAM
DESCRIPTION
2
Pruning and Planting
NAME
EMP ID: OHIP
HOME PHONE START DATE SKILLS
Paula Corelli
Paul Huang
121
325443001 416-458-4562 30-Jun-98 Pruning
123 54222991 416-932-4533 30-Jun-05 Fertilizing
TEAM
DESCRIPTION
General Maintenance
3
EMP ID: OHIP
124 43524532 905-345-5366 23-Aug-98 Electrical
NAME
HOME PHONE START DATE SKILLS
Maria Wong
Phil Ramirez
126 32543555 416-435-6599
3-Mar-17 Lawn
Maintenance
Transcribed Image Text:Team - Employee Reports TEAM DESCRIPTION General Contracting 1 NAME EMP ID: OHIP HOME PHONE START DATE SKILLS General Cindy Lee Amy Smith 120 219032002 905-338-1234 1-Jan-98 Contractor 122 34111991 905-338-1234 30-Jun-99 Plumbing TEAM DESCRIPTION 2 Pruning and Planting NAME EMP ID: OHIP HOME PHONE START DATE SKILLS Paula Corelli Paul Huang 121 325443001 416-458-4562 30-Jun-98 Pruning 123 54222991 416-932-4533 30-Jun-05 Fertilizing TEAM DESCRIPTION General Maintenance 3 EMP ID: OHIP 124 43524532 905-345-5366 23-Aug-98 Electrical NAME HOME PHONE START DATE SKILLS Maria Wong Phil Ramirez 126 32543555 416-435-6599 3-Mar-17 Lawn Maintenance
Expert Solution
steps

Step by step

Solved in 7 steps with 6 images

Blurred answer
Knowledge Booster
Query Syntax
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm…
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Information Technology Project Management
Information Technology Project Management
Computer Science
ISBN:
9781337101356
Author:
Kathy Schwalbe
Publisher:
Cengage Learning