Relational Database Design and Modeling for Software Engineers
Vote

0% completed

​

Exercise 2

A company keeps one row per employee, with the employee's address spread across four columns.

Emp_IDEmp_NameDesignationAreaCityStatePin
101AnitaEngineerAndheriMumbaiMaharashtra400053
102BalaAnalystBandraMumbaiMaharashtra400050
103ChandraEngineerKoramangalaBengaluruKarnataka560034
104DevManagerSalt LakeKolkataWest Bengal700064

Emp_ID is the primary key. Assume for this exercise that one PIN code covers exactly one area, in one city, in one state.

.....

.....

.....

Like the course? Get enrolled and start learning!

Reading Progress

0%

Vote for new content