[chn512]

Hi every one,

I am preparing for exam , i need info for fifth normal form, in our exam we need to identify whether the table is in Fifth normal form or not . can some body explain how to recognize whether the table is in fifth normal or not ?

Sample question :
Given is a table with three columns named "StudyProgramme", "Lecture" and "Subject". This table provides information about subjects which need to be contained in the given lecture for a study programme. As an example, the lecture "Programming" may cover the programming of "Sockets" for students of the study programme "Computer Science". On the other hand the lecture "Programming" for students from the study programme "Management" will probably not include this topic. Discuss whether this table is in fifth normal form.

I went through many examples but i am not be able to get a formula to break all similar type of questions... if there is any such type of thing exists please let me know.

Thanks,

[e_i_pi]

Have you read the Wikipedia page on 5NF? The example given there is remarkably similar to your example. I believe the example you have given is not 5NF. Consider the Wikipedia example with equivalencies to your example like so:

Travelling Salesman = Study Programme
Brand               = Lecture
Product             = Subject

I may be wrong, but they seem to be the same case.