Nepal's open education portal

ResultsScholarships
EduNepalEduNepal

Database Management System Syllabus - BCA (TU)

View and download full syllabus of Database Management System

Course Description

Course Description

Database Management System (CACS202) is a core credit course structured under the official university academic syllabus for Bachelor of Computer Application.

Objective

The objective of this course is to introduce the basic principles, techniques, and applications of Database Management System. Upon the completion students will be able to:

  1. Equip students with deep theoretical foundations in Database Management System.
  2. Develop practical problem-solving, laboratory, and implementation skills.
  3. Prepare graduates for industry careers, research, and national university examinations.

Learning Outcomes

  1. Demonstrate rigorous technical knowledge and conceptual mastery of Database Management System.
  2. Design, implement, and analyze efficient algorithms and practical frameworks.
  3. Solve representative theoretical proofs and complex applied problems independently.

Unit Contents

Course Contents

Unit 1: Introduction to Database Systems Architecture[6 Hrs.]

Unit 1:Comprehensive study notes, key principles, and examples for Introduction to Database Systems Architecture.

Unit 2: Entity-Relationship (ER) Modeling[8 Hrs.]

Unit 2:Comprehensive study notes, key principles, and examples for Entity-Relationship (ER) Modeling.

Unit 3: Relational Model and Relational Algebra[8 Hrs.]

Unit 3:Comprehensive study notes, key principles, and examples for Relational Model and Relational Algebra.

Unit 4: SQL: DDL, DML, and Advanced Queries[10 Hrs.]

Unit 4:Comprehensive study notes, key principles, and examples for SQL: DDL, DML, and Advanced Queries.

Unit 5: Relational Normalization[8 Hrs.]

Unit 5:Comprehensive study notes, key principles, and examples for Relational Normalization.

Unit 6: Transactions and Concurrency Control[8 Hrs.]

Unit 6:Comprehensive study notes, key principles, and examples for Transactions and Concurrency Control.

Teaching Method

Classroom lectures (3 hours/week), practical laboratory assignments (3 hours/week), and project work.

Evaluation Scheme

Internal Assessment (40 Marks: Theory Exam, Practical Exam, Attendance, Assignments) and Final University Board Examination (60 Marks).

Reference Books

  1. Database System Concepts by Silberschatz, Korth, Sudarshan (McGraw Hill)
  2. Fundamentals of Database Systems by Elmasri and Navathe
Official Syllabus Source:View official university document