Define Normalization? Explain 1NF, 2NF and 3NF with example

4.8kviews

written 7.3 years ago by

meghalikalyankar • 2.3k

modified 4.0 years ago by

pedsangini276 • 4.8k

database management systems

ADD COMMENT EDIT

1 Answer

67views

written 7.3 years ago by

meghalikalyankar • 2.3k

First Normal Form

• A relation is in 1NF, if every row contains exactly one value for each attribute.

Example

Faculty code	Faculty Name	Date of Birth	Subject	Hours
100	Yogesh	17/07/64	DSA	16
			SS	8
			IS	12
101	Amit	24/12/72	MIS	16
			PM	8
			IS	12

Consider a table …

Create a free account to keep reading this post.

and 2 others joined a min ago.

ADD COMMENT EDIT

Please log in to add an answer.