This table is in 1NF. The composite PK consists of PlayerID and Year.

PlayerID	PlayName	Year	Jersey	DOB	Points/Yr	GamesPlayed	TeamID	TeamName	Loc
1	Bryant	1997	8	8/23/78	539	71	5	Lakers	LA
1	Bryant	2003	8	8/23/78	2461	82	5	Lakers	LA
1	Bryant	2008	24	8/23/78	2323	82	5	Lakers	LA
2	Chamberlain	1960	13	8/21/36	2708	72	7	Warriors	Philly
2	Chamberlain	1962	13	8/21/36	4029	80	7	Warriors	Philly
2	Chamberlain	1973	33	8/21/36	1084	82	5	Lakers	LA
3	Bird	1980	33	12/7/56	1745	82	1	Celtics	Bos
3	Bird	1985	33	12/7/56	2295	80	1	Celtics	Bos
3	Bird	1991	33	12/7/56	1164	60	1	Celtics	Bos
4	Malone	1990	32	7/24/63	2540	82	9	Jazz	Utah
5	Jordan	1985	23	2/17/63	2313	82	6	Bulls	Chic
5	Jordan	1987	23	2/17/63	3041	82	6	Bulls	Chic
5	Jordan	2003	45	2/17/63	1640	82	8	Wizards	Wash
6	Hardaway	1993	5	9/1/66	1893	81	11	Warriors	Gold.
7	Archibald	1973	10	9/2/48	2719	80	15	Kings	KC
8	Russell	1961	6	2/12/34	1436	76	1	Celtics	Bos
8	Russell	1969	6	2/12/34	762	77	1	Celtics	Bos
9	McHale	1987	32	12/19/57	2008	77	1	Celtics	Bos

Do the following:

1. List all fields that are totally dependent on the PK fields (PlayerID and Year):

2. List all fields that have partial dependence (on one or the other PK fields), and tell which of the PK fields it is dependent on:

3. List all fields that have transitive dependence, and tell which field it is dependent on:

4. Change the DB from 1NF to 2NF. Write the tables on separate lines, with PKs first (indicate by PK), and other fields to the side (indicate by FK the foreign key fields). Ive put the tables (and some fields) in to help. All fields must be accounted for.

PLAYER PlayerID (PK/FK),

PLAYER/YEAR PlayerID (PK), Year (PK),

5. Change the DB from 2NF to 3NF (just like the above).