Questions

Filter

Subject: DBMS

Topic: Normalization & Functional Dependency

Normalize the following table to 2NF:

Name Birth_year Address College_name Birth_place Phone
XYZ 1970 CHABAHIL KANTIPUR PHARPING 9806, 9804
MNO 1980 LOKANTHALI KATHMANDU HETAUDA 9802, 9805
PQR 1970 CHABAHIL KATHMANDU HETAUDA 9806, 9808
XYZ 1990 POKHARA ASCOL HETAUDA 9854
View Answer

Normalize the following relation to 3NF form.

E_ID E_Name E_Post E_Sex E_Salary E_Add
1 Rahul Sr. Engineer M 100000 Kathmandu
2 Sushila Web Developer F 40000 Birgunj
3 Rahul Web Developer M 40000 Balaju
4 Sasim Jr. Engineer M 70000 Dhangadhi
5 John Jr. Engineer M 70000 New York
View Answer