PlayerInfo Player ID Position Player_Name Coach Player_Grade 01 FB Earl Joe 3.0 02 G John Ed 2.0 03 FB Tony Pete 2.5 04 T Carl Jim 2.0 05 FB Carl Joe 3.0 01 G Earl Ed 3.0 Player ID A Position Player_Name Player_Grade Coach B 1. Referring to the functional dependency diagram below, indicate the functional dependencies depicted by A and B. 2. Referring to the table PLAYERINFO above, in what normal form is the relation? 3. Referring to the functional dependency diagram below, systematically decompose the relation into a set of 3 NF relations.
PlayerInfo Player ID Position Player_Name Coach Player_Grade 01 FB Earl Joe 3.0 02 G John Ed 2.0 03 FB Tony Pete 2.5 04 T Carl Jim 2.0 05 FB Carl Joe 3.0 01 G Earl Ed 3.0 Player ID A Position Player_Name Player_Grade Coach B 1. Referring to the functional dependency diagram below, indicate the functional dependencies depicted by A and B. 2. Referring to the table PLAYERINFO above, in what normal form is the relation? 3. Referring to the functional dependency diagram below, systematically decompose the relation into a set of 3 NF relations.
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter2: Data Models
Section: Chapter Questions
Problem 3P
Related questions
Question
I need help only with number three. I need to convert it to 2NF then to 3NF. For 2NF is this right?
- Player (Player_ID (PK), Player_Name, Player_Grade)
- Info (Player_Name, Player_Grade)
How do I convert to 3NF?
Transcribed Image Text:PlayerInfo
Player ID
Position Player_Name Coach Player_Grade
01
FB
Earl
Joe
3.0
02
G
John
Ed
2.0
03
FB
Tony
Pete
2.5
04
T
Carl
Jim
2.0
05
FB
Carl
Joe
3.0
01
G
Earl
Ed
3.0
Player ID
A
Position Player_Name Player_Grade Coach
B
1. Referring to the functional dependency diagram below, indicate the functional dependencies
depicted by A and B.
2. Referring to the table PLAYERINFO above, in what normal form is the relation?
3. Referring to the functional dependency diagram below, systematically decompose the
relation into a set of 3 NF relations.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
C++ for Engineers and Scientists
Computer Science
ISBN:
9781133187844
Author:
Bronson, Gary J.
Publisher:
Course Technology Ptr
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning