1 / 30

Normalization in Database Management System [Autosaved]

In this video, I had discussed about Normalization in detail

prathiba3
Download Presentation

Normalization in Database Management System [Autosaved]

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Normalization in Database Management System Presented byS.Prathiba

  2. Overview • Purpose of Normalization • Problems • Normalization • Solution • Example

  3. Purpose of Normalization

  4. Minimizes data redundancy

  5. Problems without Normalization

  6. Insertion Anomaly • Deletion Anomaly • Update Anomaly

  7. Solution(Decomposition)

  8. Solution

  9. Example

  10. R(ABCDEF) a. AB →C b. C→ DE c. E→ F d. F → A Step 1: Identify the candidate keys - AB,EB,BC,FB. Step 2: Write all the prime attributes - A,B,C,E,F

  11. Step 3: Write the non prime attributes - D Step 4: Check for the highest normal form - BCNF,3NF,2NF. AB,EB,BC,FB are candidate keys. • AB →C • C→ DE • E→ F d. F → A

  12. Here AB is a key, but the next attribute C is not a super keyset is not in BCNF.

  13. 3NF-LHS should be a super key or RHS should be prime attribute. Here the condition is not satisfied for b as D is not prime attribute.

  14. 2NF- proper subset of CK -> Non-prime attribute. This is known as Partial dependency. • Partial dependency should not exist in second normal form.

  15. Here the condition is not satisfied. C→ DE • Therefore the relation is in first normal form.

  16. The following topic has around 3000 views: https://www.youtube.com/watch?v=WcH3txglwwM&t=26s

  17. The following video has more than 500 views: https://www.youtube.com/watch?v=j0RPblzC8c4&t=702s

  18. Few of my videos have more than 300 views: https://www.youtube.com/watch?v=LCR1Fd79agI&t=515s

  19. https://www.youtube.com/watch?v=4QdTRIxpMcw

  20. https://www.youtube.com/watch?v=8tfVqyRm1vw

  21. https://www.youtube.com/watch?v=_GXF8fFqgmE&t=209s

  22. Click on the following link to access my YouTube channel. https://www.youtube.com/channel/UC22HlSaGRuGRSNA90Kl9LVQ/videos

  23. Thank you

More Related