Scribd
Upload
9 views1 page

Database Normalization: 1NF, 2NF, 3NF

The document discusses the normalization process of a table containing student information, including fields like StudID, Name, Gender, courseCode, CourseName, Grade, year, and building. It outlines the steps to achieve the First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF) for the provided data structure. The table has multiple entries for course codes and grades, indicating the need for normalization to eliminate redundancy and ensure data integrity.

Uploaded by

melkameandebet
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
9 views1 page

Database Normalization: 1NF, 2NF, 3NF

The document discusses the normalization process of a table containing student information, including fields like StudID, Name, Gender, courseCode, CourseName, Grade, year, and building. It outlines the steps to achieve the First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF) for the provided data structure. The table has multiple entries for course codes and grades, indicating the need for normalization to eliminate redundancy and ensure data integrity.

Uploaded by

melkameandebet
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

(Normalization )Show the 1NF,2NF and 3NF of the following table

StudID Name Gender courseCode CourseName Grade Grade year building


Equivalent
01 Abebe M IS100,IS200 DB,Java A,C 4,2 1st B1
Belay
02 Aste Awoke F IS100 DB F 0 2nd B2
03 Helen Abeje F IS400 IP B 3 3rd B3
04 Wasihun M IS201,IS100 VB,DB D,A 1,4 4th B4
Dagne

(Normalization )Show the 1NF,2NF and 3NF of the following table


StudID Name Gender courseCode CourseName Grade Grade year building
Equivalent
01 Abebe M IS100,IS200 DB,Java A,C 4,2 1st B1
Belay
02 Aste Awoke F IS100 DB F 0 2nd B2
03 Helen Abeje F IS400 IP B 3 3rd B3
04 Wasihun M IS201,IS100 VB,DB D,A 1,4 4th B4
Dagne

(Normalization )Show the 1NF,2NF and 3NF of the following table


StudID Name Gender courseCode CourseName Grade Grade year building
Equivalent
01 Abebe M IS100,IS200 DB,Java A,C 4,2 1st B1
Belay
02 Aste Awoke F IS100 DB F 0 2nd B2
03 Helen Abeje F IS400 IP B 3 3rd B3
04 Wasihun M IS201,IS100 VB,DB D,A 1,4 4th B4
Dagne

1. (Normalization )Show the 1NF,2NF and 3NF of the following table


StudID Name Gender courseCode CourseName Grade Grade year building
Equivalent
01 Abebe M IS100,IS200 DB,Java A,C 4,2 1st B1
Belay
02 Aste Awoke F IS100 DB F 0 2nd B2
03 Helen Abeje F IS400 IP B 3 3rd B3
04 Wasihun M IS201,IS100 VB,DB D,A 1,4 4th B4
Dagne

You might also like