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

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

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…

17-05-2005 11:56am

#1

lad12

Registered Users, Registered Users 2 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