5th normal form in data base manage.pptx

abhisheknagaraju126 11 views 3 slides Oct 08, 2024
Slide 1
Slide 1 of 3
Slide 1
1
Slide 2
2
Slide 3
3

About This Presentation

this is the presentation on normalization concepts on 5nf


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
Tags