Questions

Filter

Subject: All Subjects

Topic: All Topics

Normalize the following table.

Pid Pname Price Mid Mname Address Phone
1 ABC 1000 101 EFG Ktm, Bkt 4412
2 XYZ 2000 101 EFG Bkt 4561
1 ABC 3000 102 MNP Ltp, Ktm 2341
3 ABC 1000 105 IBD Brt, Bkt 2169
4 XYZ 1000 105 IBD Ktm 6635
View Answer

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