Header Ads Widget

Top Billboard Ads

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.

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

Post a Comment

0 Comments