Unit V: Database Constraints and Relational Database Design | BCA 4th Semester Database Management System (DBMS) Notes Pdf

Constraints are a very important feature in a relational model. In fact, the relational model supports the well-defined theory of constraints on attributes or tables.

Constraints are useful because they allow a designer to specify the semantics of data in the database. Constraints are the rules that force DBMSs to check that data satisfies the semantics.

In this “Database Constraints and Relational Database Design – Database Management System” you will learn about the following topics:

1. Introduction of Database Constraints
2. Types of Integrity Constraints
3. Domain Constraints, Entity Integrity Constraints, Referential Integrity Constraints, Key Constraints or Uniqueness Constraints
4. Relational Database Design (RDD)
5. Relational Database Design Process
6. Assertions
7. Triggers
8. Difference between Assertions and Triggers
9. Functional Dependency
10. Types of Functional Dependencies in DBMS
11. Multivalued Dependency, Trivial Functional Dependency, Non Trivial Functional Dependency, Transitive Dependency
12. Inference Rule (IR)
13. Reflexive Rule (IR₁), Augmentation Rule (IR₂), Transitive Rule (IR₃), Union Rule (IR₄), Decomposition Rule (IR5), Pseudo transitive Rule (IR₆)
14. Normalization
15. Types of Normal Forms
16. First Normal Form (1NF), Second Normal Form (2NF), Third Normal Form (3NF), Boyce Codd Normal Form (BCNF), Fourth Normal Form (4NF), Fifth Normal Form (5NF)
17. Decomposition of Relational Schemas
18. Types of Decomposition
19. Lossless Decomposition, Dependency Preserving

==== Point to Note ====

This article Database Constraints and Relational Database Design – 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 [email protected].

See your article appearing on BCA Notes (Pokhara University) main page with your designation and help other BCA Students to excel.

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

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

• Unit I: Introduction To Database Management System (DBMS)
• Unit II: Data Models
• Unit III: Relational Model
• Unit IV: Relational Database Query Languages
• Unit VI: Database Security
• Unit VII: Query Processing
• Unit VIII: File Organization and Indexing
• Unit IX: Crash Recovery
• Unit X: Transaction Processing and Concurrency Control
• Unit XI: Advanced Database Concepts