Convert below table to 2NF. Draw the table(s) with correct values.
|
branchNo |
branchRegion |
branchTelno |
mgrStaffNo |
mgrName |
mgrPosition |
mgrSalary |
|
BR001 |
North |
503-555-3618 |
S1500 |
Daniel Jacobs |
Jr Manager |
50000 |
|
BR002 |
South |
206-555-6756 |
S0010 |
Mary Anderson |
Sr Manager |
55500 |
|
BR003 |
East |
210-371-3444 |
S0145 |
Peter McDonalds |
Sr Manager |
60000 |
|
BR004 |
West |
506-455-2131 |
S2250 |
Sally Stockholm |
Jr Manager |
55000 |
2NF
Functional dependencies :
branchNo -> branchRegion, branchTelNo,mgrStaffNo
mgrStaffNo -> mgrName,mgrPosition, mgrSalary
Tables in 2NF
Branch(branchNo , branchRegion, branchTelNo, mgrStaffNo)
|
branchNo |
branchRegion |
branchTelno |
mgrStaffNo |
|
BR001 |
North |
503-555-3618 |
S1500 |
|
BR002 |
South |
206-555-6756 |
S0010 |
|
BR003 |
East |
210-371-3444 |
S0145 |
|
BR004 |
West |
506-455-2131 |
S2250 |
Manager(mgrStaffNo, mgrName, mgrPosition, mgrSalary)
|
mgrStaffNo |
mgrName |
mgrPosition |
mgrSalary |
|
S1500 |
Daniel Jacobs |
Jr Manager |
50000 |
|
S0010 |
Mary Anderson |
Sr Manager |
55500 |
|
S0145 |
Peter McDonalds |
Sr Manager |
60000 |
|
S2250 |
Sally Stockholm |
Jr Manager |
55000 |
underlined are primary keys and italicised are foreign keys.
Do ask if any doubt. Please upvote.
Convert below table to 2NF. Draw the table(s) with correct values. branchNo branchRegion branchTelno mgrStaffNo mgrName...