Unit III: Data Normalization - Database Management System

BCA 4th Semester DBMS (Database Management System) Notes Pdf, Data Normalization - Database Management System

Data Normalization – Database Management System

In this unit named Data Normalization – Database Management System” readers and viewers will get information regarding the following topics:

  1. Relational Database Management System
  2. Components of Relational Database Management System (RDBMS)
  3. Database Schema
  4. Database Instance
  5. Integrity Constraints
  6. Domain Constraints, Entity Integrity Constraints, Key Constraints, Referential Integrity Constraints
  7. Database Keys
  8. Super Key, Candidate Key, Primary Key, Composite Key, Foreign key, Secondary or Alternative key, Non-key Attributes, Non-prime Attributes
  9. Relation Algebra in DBMS
  10. Types of Relation Operation
  11. Select Operation, Project Operation, Union Operation, Set Intersection, Set Difference, Cartesian Product, Rename Operation
  12. Join Operations
  13. Types of Join Operations
  14. Natural Join, Outer Join, Equi join
  15. Relational Calculus
  16. Types of Relational calculus
  17. Tuple Relational Calculus (TRC), Domain Relational Calculus (DRC)
  18. Functional Dependency
  19. Inference Rule (IR)
  20. Reflexive Rule (IR1), Augmentation Rule (IR2), Transitive Rule (IR3), Union Rule (IR4), Decomposition Rule (IR5), Pseudo transitive Rule (IR6)
  21. Types of Functional Dependencies in DBMS
  22. Multivalued Dependency, Trivial Functional Dependency, Non-Trivial Functional Dependency, Transitive Dependency
  23. Anomalies in DBMS
  24. Update Anomaly, Insert Anomaly, Delete Anomaly
  25. Normalization
  26. Types of Normal Forms
  27. First Normal Form (1NF)
  28. Second Normal Form (2NF)
  29. Third Normal Form (3NF)
  30. Boyce Codd Normal Form (BCNF)
  31. Fourth Normal Form (4NF)
  32. Fifth Normal Form (5NF)
  33. Relational Decomposition
  34. Types of Decomposition
  35. Lossless Decomposition, Dependency Preserving
  36. Business Rules and Its Effects
  37. Field Constraints, Relationship Constraints
  38. Data Dictionary
  39. Types of Data Dictionary
  40. Active Data Dictionary, Passive Data Dictionary
  41. Transform ER or Class Diagram into Tables

This article Data Normalization - Database Management System is contributed by Rashita Gurung, a student of LA GRANDEE International College.

If you like to contribute, you can mail us BCA Notes, BCA Question Collections, BCA Related Information, and Latest Technology Information at See your article appearing on BCA Notes (Pokhara University) main page with your designation and help other BCA Students.

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.

BCA 4th Semester DBMS (Database Management System) Notes:

Unit I: Operating System Overview - Database Management System

Unit II: Designing A Database - Database Management System

Unit IV: Queries In Database - Database Management System

Unit V: Advanced Queries In Database - Database Management System

Unit VI: Developing Stored Procedures - Database Management System

Unit VII: Creating DML Triggers - Database Management System

Unit VIII: Physical Design - Database Management System

Unit IX: Database Application Types - Database Management System

Unit X: Distributed Database System - Database Management System

Unit XI: Object Oriented Database - Database Management System

No comments

Post a Comment

Share your honest opinion and feedback about this website, through the comment box.

Don't Miss
© 2019 - All Rights Reserved
Lots of BCA Notes (Pokhara University)