Relational Database Management (BCAMJ-401)
Program: Bachelor of Computer Applications(Hons)
Category: Professional Core Course
Semester: 4
Credits: 4
L-T-P: 4- 0- 0
Description
The RDBMS syllabus covers the fundamentals of databases, focusing on the relational model, normalization, and SQL commands (SELECT, INSERT, etc.). It teaches constraints, keys, and relationships for data integrity. Topics like indexing, views, transactions, and concurrency control are explored for efficient database management. Security, backups, and recovery mechanisms are also emphasized. Advanced topics include distributed databases and performance tuning for real-world applications.
Instructor

Dr. Archana Sharma *

Assistant Professor
Department Of Computer Applications
Course Outcomes
  • Describe the key concepts of database systems.
  • Evaluate data model concepts, database architecture, and roles with in database Management.
  • Explain relational database principles and E-R models to design and optimize database systems.
  • Demonstrate relational model concepts and SQL to manage databases.
  • Apply normalization techniques and functional dependencies to design efficient database schemas.
Resources
Course Handout Lesson Plan Syllabus
Evaluation Scheme
Assignment 10
Attendance 10
Sessional 20
Total Internal 40
Total External 60
Overall Total 100