Table #1

GameID	GameName	CharacterID	GameCharacter	CharacterPlayable
1	Sonic The Hedgehog	26, 27	Sonic, Robotonik	Y, N
2	Super Mario Brothers 3	28, 29, 30, 31	Mario, Luigi, Bowser, Peach	Y, Y, N, N
3	Super Mario Brothers 2	28, 29, 31	Mario, Luigi, Peach	Y, Y, Y
4	Mortal Kombat 1	32, 33, 34	Shang Tsung, Sub Zero, Scorpion	N, Y, Y
5	Mortal Kombat 2	32, 33, 34	Shang Tsung, Sub Zero, Scorpion	Y, Y, Y

Table #2

BookID	Book Title	Book Condition	Book Trade in Price	Book Selling Price
1	Database Design	New,Fair,Bad	20, 15, 10	30,25,20
2	Algebra I	New,Fair,Bad	50,45,40	60,55,50
3	Cloud Computing	N,F,B	30,25,20	50,45,40
4	C# for Dummies	N,F,B	70,65,60	100,95,90

1. Convert the data in table 1 to 3NF

2. Convert the data in table 2 to 3NF