

- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Explain 5NF with examples in DBMS
It is also called as project join normal form. A relation R is in 5NF if it is in 4NF and there is no join dependency. No join dependency means lossless-join decomposition.
Decomposition is lossless-join decomposition if it preserves all the data in original relation and does not result in additional tuples.
A relation R satisfies join dependency iff R is equal to the join of R1,R2,.....Rn where Ri are a subset of the set of attributes of R.
Relation R
Dept | Subject | Name |
---|---|---|
CSE | C | Ammu |
CSE | C | Amar |
CSE | Java | Amar |
IT | C | bhanu |
Here,
dept ->-> subject
dept->-> name
The above relation is in 4NF. Anomalies can occur in relation in 4NF if the primary key has three or more fields. The primary key is (dept,subject, name). Sometimes decomposition of a relation into two smaller relations does not remove redundancy. In such cases it may be possible to decompose the relation in three or more relations using 5NF.
The above relation says that dept offers many elective subjects which are taken by a variety of students. Students have the opinion to choose subjects. Therefore, all three fields are needed to represent the information.
The above relation does not show non-trivial MVDs since the attributes subject and name are dependent; they are related to each other (A FD subject->name exists). The relation cannot be decomposed in two relations (dept, subject) and (dept,sname).
Therefore the relation can be decomposed into following three relations −
R1(dept, subject)
R2(dept, name) and
R3(subject, name) and it can be shown that decomposition is lossless.
R1
Dept | Subject |
---|---|
CSE | C |
CSE | Java |
IT | C |
R2
Dept | Name |
---|---|
CSE | Ammu |
CSE | Amar |
IT | Bhanu |
R3
Subject | Name |
---|---|
C | Ammu |
C | Amar |
Java | Amar |
C | Bhanu |
In above decomposition of table reduction of redundancy is not apparent, but it can be realized when tables contain large amounts of data.
Let's have a look at all Normal forms can be understood in single picture as shown below −
- Related Questions & Answers
- What is 1NF in DBMS? Explain with examples
- Explain the concept of DBMS schema with examples?
- Explain the concept of foreign keys with examples(DBMS)?
- Explain Python Matrix with examples
- Explain Stack in Python with examples
- Explain 3NF with an example in DBMS
- Explain BCNF with an example in DBMS
- Explain the stages and their examples of database development lifecycle (DBMS)?
- Explain about 2NF with an example in DBMS
- What is JavaScript closure? Explain with examples.
- Explain JavaScript Regular Expression modifiers with examples
- Fifth Normal Form (5NF)
- Explain Select command in DBMS
- Explain set operators in DBMS
- Explain join dependency in DBMS