SQL -Structured Query Language - Normalization - 2 NF Tutorial

The table must be in 1 NF.
Each record must be identified by the primary key.

We have divided our 1NF table into two tables i.e table 1 and table 2

In 2 NF

We make user_id as a primary key in Table 1 and foreign key in Table 2.

Table 1 - contain user detail like first name and last name which is uniquely identified by user_id (primary key)

Table 2 – contain user detail like contact no, user_id. Here user_id of Table 2 acts as a foreign key in reference (relationship) with the user_id of Table 1.

About Fresherbell

Best learning portal that provides you great learning experience of various technologies with modern compilation tools and technique

Important Links

Don't hesitate to give us a call or send us a contact form message

Terms & Conditions
Privacy Policy
Contact Us