Description Homework 3 Intro to Normalization

Insert the normalized tables into the original document

Take the unnormalized table below and convert it into its First Normal Form.

Student ID	FirstName	LastName	Phone	SubjectID	Subject
100	Bill	Russell	3171231234	1	Math
				2	Science
101	Larry	Bird	3171231235	3	Biology
102	Michael	Jordan	3171231236	1	Math
				4	English
103	Erving	Johnson	3171231237	1	Math
				4	English
				5	History
104	John	Stockton	3171231238	6	Chemistry
				7	Spanish

First Normal Form

Take the First Normal Form table below and convert it into its Second Normal Form.

CustomerID	CustomerName	OrderID	OrderName	SalesDetail
101	Clark	10	Order1	Baseballs & Gloves
101	Clark	11	Order2	Basketballs
102	Porter	12	Order3	Soccer Balls
103	Dawson	13	Order4	Baseballs & Gloves
103	Dawson	14	Order5	Basketballs
103	Dawson	15	Order6	Soccer Balls

Second Normal Form

Take the Second Normal Form table below and convert it into its Third Normal Form.

StudentID	StudentFirst	StudentLast	AdvisorID	AdvisorFirst	AdvisorLast
101	Johnny	Little	201	Jerome	Clark
102	Amanda	Tandy	201	Jerome	Clark
103	Billy	Bolten	202	Willy	Wonka
104	Jill	Later	203	Luke	Skywalker

Third Normal Form