dbms Normalization

-

 Normalization



Types

Normal Form

Description

1NF

A relation is in 1NF if it contains an atomic value.

2NF

A relation will be in 2NF if it is in 1NF and all non-key attributes are fully functional dependent on the primary key.

3NF

A relation will be in 3NF if it is in 2NF and no transition dependency exists.

BCNF

A stronger definition of 3NF is known as Boyce Codd's normal form.

4NF

A relation will be in 4NF if it is in Boyce Codd's normal form and has no multi-valued dependency.

5NF

A relation is in 5NF. If it is in 4NF and does not contain any join dependency, joining should be lossless.

Comments

Post a Comment

Popular posts from this blog

Jonita Gandhi

-
Image
  Jonita Gandhi, the talented singer with a melodious voice, has made a mark in the music industry. Born and raised in Canada , Jonita has captivated audiences with her soulful renditions in both Hindi and English. Her journey to success began when she uploaded cover songs on YouTube, which gained immense popularity. This led to her collaboration with renowned composers such as A.R. Rahman and Pritam, further establishing her as a versatile singer. Jonita's mesmerizing vocals have graced numerous Bollywood soundtracks, including hits like "Gilehriyaan" from the movie "Dangal" and "The Breakup Song" from "Ae Dil Hai Mushkil." Her ability to effortlessly switch between genres is commendable, making her a sought-after artist in the industry. Apart from Bollywood playback singing, Jonita has also performed live at various concerts around the world. Her stage presence and ability to connect with the audience make her performances unforgettable. W...
Read more

Current Affair 2023

-
   November 2023 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. October 2023 1. 4th Asian para games houngzhu China 111 medel 2. Nilavu Kodicha simhagal- book - aatmkatha S Somnath ISRO(malyalam) 3. Rugby World Cup 2023 South Africa winner in france 4. Global hunder Index Rank 111/125 Bharat (first Belarus) 5.( 1991 -Start )Saraswati Samman 2022 se Shiv Shankari ( Tamil writer)- " Suryavansham" (#1st 🎂 Harivansh Rai Bacchan) 6. - Summer Olympic 2028 Los Angel USA, cricket T20, baseball, squash ,baseball 7. Christopher luxon appoint Prime Minister of New Zealand 8. 16 October 1945 world food Day celebrate 9. Bathukamma festival organised in Telangana 10. Kidami Shrikant and Chirag Shetty badminton player rank 1 11. Bhopal women police station ISRO certified 12. World Health Summit organised in Germany 2023 13. Tumpa Tiger Reserve Mizoram found frog variety Toad 14. First Medical College of Nagaland 15. Amol Mazumdar is Indian women ...
Read more

Cyber Security (Syllabus )

-
BCA 4 Cyber security Unit-1 Information security --overview, information security importance , information security components ( English ). threats to information system -external and internal threat, security threat vulnerability--overview, malware, type of Malware: virus,worms, Trojan, rootkits, robots adware's spyware's, ransom wares , zombies etc. Desktop security Unit Third -- cloud computer and security , social network site security , attack prevention-Password ,protection against attack in social media, securing wireless network ,security threats. Unit - 2  application security - database security, e-mail security ,internet security, principles of security -confidentiality, integrity ,availability, introduction to cryptography -symmetric key cryptography ,asymmetric key cryptography, message authentication , application of cryptography. security technology- firewall, type of firewall, firewall benefit , VPN antivirus software . Unit- 5 ISO-international organisation...
Read more