If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Normal Forms-Functional Dependencies

lad12 · 2005-05-17 11:56:21

Would anyone be able to give me some help with the following question please. Give the functional dependencies for the table SE(SNo, ENo, EName, City, Country) with primary key (SNo, ENo) such that 1) SE is in the 1NF and not in 2NF 2) SE is in the 2NF and not in 3NF 3) SE is in the 3NF and not in BCNF How would i use…

Options

17-05-2005 12:56pm

#1

lad12

Registered Users Posts: 488 ✭✭

Join Date: March 2004

Posts: 397

Would anyone be able to give me some help with the following question please.

Give the functional dependencies for the table
SE(SNo, ENo, EName, City, Country) with primary key (SNo, ENo) such that

1) SE is in the 1NF and not in 2NF
2) SE is in the 2NF and not in 3NF
3) SE is in the 3NF and not in BCNF

How would i use functional dependency diagrams for illustrations?

0