Relational Database Design and Modeling for Software Engineers
Vote

0% completed

​

Solution to Exercise 2

Here is the table again.

Emp_IDEmp_NameDesignationAreaCityStatePin
101AnitaEngineerAndheriMumbaiMaharashtra400053
102BalaAnalystBandraMumbaiMaharashtra400050
103ChandraEngineerKoramangalaBengaluruKarnataka560034
104DevManagerSalt LakeKolkataWest Bengal700064

Step 1. Why it is already in 2NF

The primary key is Emp_ID, one column.

A partial dependency means a non-key column depending on part of the key

.....

.....

.....

Like the course? Get enrolled and start learning!

Reading Progress

0%

Vote for new content