# How to identify whether the table is in 5 th normal form or not ?

Page 1 of 1

## 1 Replies - 2039 Views - Last Post: 04 February 2013 - 05:19 PMRate Topic: //<![CDATA[ rating = new ipb.rating( 'topic_rate_', { url: 'https://www.dreamincode.net/forums/index.php?app=forums&module=ajax&section=topics&do=rateTopic&t=311087&amp;s=b09353112748083e53200029b9e43f29&md5check=' + ipb.vars['secure_hash'], cur_rating: 0, rated: 0, allow_rate: 0, multi_rate: 1, show_rate_text: true } ); //]]>

### #1 chn512

Reputation: 0
• Posts: 1
• Joined: 04-February 13

# How to identify whether the table is in 5 th normal form or not ?

Posted 04 February 2013 - 07:10 AM

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,

Is This A Good Question/Topic? 0

## Replies To: How to identify whether the table is in 5 th normal form or not ?

### #2 e_i_pi

• = -1

Reputation: 879
• Posts: 1,893
• Joined: 30-January 09

## Re: How to identify whether the table is in 5 th normal form or not ?

Posted 04 February 2013 - 05:19 PM

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.