Data Base Management System (MCA-102)
Program: Master of Computer Applications
Category:
Semester: 1
Credits: 4
L-T-P: 4- 0- 0
Description
Database Management System (DBMS) is the study of software systems designed to efficiently store, manage, and retrieve data. It involves understanding the organization, structure, and manipulation of data in databases. Key concepts include data models, normalization, and SQL for querying data. DBMS ensures data integrity, security, and supports concurrent access by multiple users.
Instructor

Ms. Arti Kotru

Associate Professor
Department Of Computer Applications
Course Outcomes
  • Identify the basic concepts, architecture and various data models used in Database Management Systems
  • Design ER-models to represent simple database application
  • Understand normalization theory and apply such knowledge to the normalization of a database.
  • Articulate the basic issues of transaction processing and concurrency control
  • Implement advanced database queries using Structured Query Language (SQL)
Resources
Course Handout Lesson Plan Syllabus
Evaluation Scheme
MST 20
Assignment 10
Attendance 10
Total Internal 40
Total External 60
Overall Total 100