The
Assignment:
Consider the
given relation, Student_CreditHours
|
StuId
|
StuName
|
Age
|
Discipline
|
Credit-hours
|
|
4536
|
Ahmed Faraz
|
21
|
BCS
|
33
|
|
3452
|
Faisal Aslam
|
20
|
BCS
|
48
|
|
6154
|
Ahmed Ali
|
20
|
BBA
|
66
|
|
2112
|
Ahmed Faraz
|
19
|
BBA
|
84
|
|
7823
|
Aqeel Raza
|
24
|
MBA
|
12
|
|
5462
|
Hassan Ali
|
22
|
MCS
|
72
|
Where;
StuId => student Id
StuName => student name
Age => Age of the student
Discipline => The program in which the student is
enrolled
Credit-hours => The number of credit hours earned so far
Primary Key: StuId, Discipline
Question Statement:
What change(s) do you suggest
to normalize the above relation upto the 3rd normal form?
Important! Solution Table
You are required to fill the following table as the solution
of your assignment:
|
Normal Form
|
Yes/No
|
Changes
|
|
First
|
|
|
|
Second
|
|
|
|
Third
|
|
|
How to fill the table:
·
Write “Yes” if the relation is in the
respective normal form
·
Write “No” if the relation is in not in
the respective normal form. In this case, you must suggest some changes which
you want to make in the given relation to bring it into the respective normal
form. These changes must be written in the “Changes” column.
What to Submit
You are simply required to fill
the solution table and send it as your assignment.