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.
Best learning portal that provides you great learning experience of various technologies with modern compilation tools and technique
Don't hesitate to give us a call or send us a contact form message