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.

Relational Model – Database Management System

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 DBMS (Database Management System) Notes Pdf:

  1. Unit I: Introduction To Database Management System (DBMS) - Database Management System
  2. Unit II: Data Models - Database Management System
  3. Unit IV: Relational Database Query Languages - Database Management System
  4. Unit V: Database Constraints and Relational Database Design - Database Management System
  5. Unit VI: Database Security - Database Management System
  6. Unit VII: Query Processing - Database Management System
  7. Unit VIII: File Organization and Indexing - Database Management System
  8. Unit IX: Crash Recovery - Database Management System
  9. Unit X: Transaction Processing and Concurrency Control - Database Management System
  10. Unit XI: Advanced Database Concepts - Database Management System