BCA Semester-V^th - Introduction to DBMS Syllabus

Here you will find the syllabus of first subject in BCA Semester-V^th, 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 3^rd normal form
• Concurrency Control
  • Transaction processing
  • Locking techniques and associated
  • Database recovery
  • Security and authorization
• Recovery Techniques
• Database Security