BCA Semester-Vth - Introduction to DBMS Syllabus

Here you will find the syllabus of first subject in BCA Semester-Vth, which is Introduction to DBMS.

Important - The syllabus may vary from college to college.

Introduction to DBMS Units

This course/subject is divided into total of 6 units as given below:

  1. Introduction
  2. E-R Modelling
  3. File Organization
  4. Relational Data Model
  5. EER and ER to Relational Mapping
  6. Data Normalization

Now let's expand the above listed units with its syllabus.

Unit-I Syllabus - Introduction

Here are the list of topics that comes under the syllabus of unit-I, that is introduction:

  • Characteristics of database approach
  • Data models
  • DBMS architecture and data independence

Unit-II Syllabus - E-R Modelling

Here are the list of topics that comes under the syllabus of unit-II, that is E-R modelling:

  • Entity types
  • Entity set
  • Attribute and key
  • Relationships
  • Relation types
  • Roles and structural constraints
  • Weak entities
  • Enhanced E-R and object modelling
  • Sub classes
  • Super classes
  • Inheritance
  • specialization and generalization

Unit-III Syllabus - File Organization

Here are the list of topics that comes under the syllabus of unit-III, that is file organization:

  • Indexed sequential access files
  • Implementation using B and B++ trees
  • Hashing
  • Hashing functions
  • Collision resolution
  • Extendible hashing
  • Dynamic hashing approach implementation and performance

Unit-IV Syllabus - Relational Data Model

Here are the list of topics that comes under the syllabus of unit-IV, that is relational data model:

  • Relational model concepts
  • Relational constraints
  • Relational algebra
  • SQL
    • SQL queries
    • Programming using SQL

Unit-V Syllabus - EER and ER to Relational Mapping

Here are the list of topics that comes under the syllabus of unit-V, that is EER and ER to relational mapping:

  • Data base design using EER to relational language

Unit-VI Syllabus - Data Normalization

Here are the list of topics that comes under the syllabus of unit-VI, that is data normalization:

  • Functional Dependencies
  • Normal form up to 3rd normal form
  • Concurrency Control
    • Transaction processing
    • Locking techniques and associated
    • Database recovery
    • Security and authorization
  • Recovery Techniques
  • Database Security

« Previous Course Next Course »

Like/Share Us on Facebook 😋