Question

Player – sample data

Can someone explain to me in more detail how to solve this exercise, that I am very confused about 1NF, 2NF, and 3NF

Thank you

ID	FIRST	LAST	GENDER
1	Jim	Jones	Male
2	Betty	Smith	Female
3	Jim	Smith	Male
4	Lee	Mann	Male
5	Samantha	McDonald	Female

With the Player entity, discussion expands to identify 1NF- 3NF.  

• You need to expand the database fields into tables from 1NF --> 2NF; 2NF --> 3NF.
• What is the name of the tables?
• What are the PK field names?
• What are the field names?
• Solution should be displayed as:  TableName(PKname, fieldname1, fieldname2, etc).
• Additional information is required to expand upon the CKs and FDs.

Answer 1

1. Name of table - Player

2. Primary key for the given relation is (ID)

3. Field name or attribute name are column name.

They are (ID, First, Last, Gender)

4. The FD's possible is

ID -> First, Last, Gender.

First, Last -> Gender

No other functional dependency is possible here.

So the given relation is already in 2NF since it doesn't contain any parti functional dependency.

Relation is not in 3NF since it contains transitive functional dependency.

So decompose it in other relation.

The 3NF decomposed relation is :

( First , Last , Gender)

( ID ,  First, Last)

If you have any questions comment down. Please don't simply downvote and leave. If you are satisfied with answer, please? upvote thanks

( ID  ​​​​​​, First , Last , Gender)