Unit III: Relational Model | BCA 4th Semester Database Management System (DBMS) Notes Pdf

Relational Model (RM) represents the database as a collection of relations. A relation is nothing but a table of values. Every row in the table represents a collection of related data values. These rows in the table denote a real-world entity or relationship.

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

1. Definition of Relational Model
2. The terminology used in Relational Model
3. Table (Relation), Column, Field (Attribute), Row, Record (Tuple), Domain, NULL Values, Database Schema, Database Instance, Integrity Constraints, Database Keys
4. Structure of Relational Database
5. Relation Algebra in DBMS
6. Types of Relation Operation
7. Select Operation, Project Operation, Union Operation, Set Intersection, Set Difference, Cartesian product, Rename Operation
8. Relational Calculus
9. Types of Relational calculus
10. Tuple Relational Calculus (TRC), Domain Relational Calculus (DRC)
11. Anomalies in DBMS
12. Update Anomaly, Insert Anomaly, Delete Anomaly
13. Relational Schema
14. Database Views
15. Data Dictionary
16. Types of Data Dictionary
17. Active Data Dictionary, Passive Data Dictionary

==== Point to Note ====

This article Relational Model - 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 IV: Relational Database Query Languages
• Unit V: Database Constraints and Relational Database Design
• 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