Description Homework 3 – Intro to Normalization Insert the normalized tables int
ID: 3750610 • Letter: D
Question
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
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
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.
Explanation / Answer
1. First Normal Form (All attributes should be atomic)
2. Second Normal Form( All non key attributes should be fully functionally dependent on primary key)
Customer
Order
Sales
3. Third Normal Form ( No transitive dependency)
Student
Advisor
Do ask if any doubt. Please upvote.
StudentID FirstName LastName Phone SubjectID Subject 100 Bill Russel 3171231234 1 Maths 100 Bill Russel 3171231234 2 Science 101 Larry Bird 3171231235 3 Biology 102 Micheal Jordan 3171231236 1 Math 102 Micheal Jordan 3171231236 4 English 103 Erving Johnson 3171231237 1 Math 103 Erving Johnson 3171231237 4 English 103 Erving Johnson 3171231237 5 History 104 John Stockton 3171231238 6 Chemistry 104 John Stockton 3171231238 7 Spanish