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 with number three. I am trying to convert it to 3NF and is this correct?
- Player (Player_ID, Player_Name)
- Info (Position, Coach)
- Team (Player_ID, Position, Player_Grade)
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.
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
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