abhisheknagaraju126
11 views
3 slides
Oct 08, 2024
Slide 1 of 3
1
2
3
About This Presentation
this is the presentation on normalization concepts on 5nf
Size: 351.52 KB
Language: en
Added: Oct 08, 2024
Slides: 3 pages
Slide Content
5 th normal form(5NF) BY, ABHISHEK K N 4MN21AD002
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. Example
Make The Table Into 5NF, We Can Decompose It Into Three Relations P1, P2 & P3: P1 P2 P3