Database Management Systems (MCA)

Data models, ER modelling, relational algebra, SQL, normalisation, transactions and concurrency control.

6 MonthsDuration 5Chapters29Topics

Enquire now

Syllabus · पाठ्यक्रम

Download PDF

01Unit 1: Introduction and ER Model 6 topics

File system versus DBMS
Data models, schema and instances
Three-schema architecture and data independence
Database languages and DBA
ER model: entities, attributes, keys and relationships
Generalisation, specialisation, aggregation and ER to tables

02Unit 2: Relational Model and SQL 6 topics

Relational model concepts and integrity constraints
Relational algebra operations
Tuple and domain relational calculus
SQL DDL and DML commands
Joins, aggregate functions, GROUP BY and subqueries
Views, indexes, triggers and cursors

03Unit 3: Database Design and Normalisation 5 topics

Functional dependencies and Armstrong's axioms
Attribute closure and candidate keys
Normal forms: 1NF, 2NF, 3NF and BCNF
Multivalued dependencies and 4NF; join dependencies and 5NF
Lossless join and dependency-preserving decomposition

04Unit 4: Transaction Processing and Recovery 6 topics

Transaction concept and ACID properties
Schedules: serial and non-serial
Conflict and view serializability
Recoverable and cascadeless schedules
Log-based recovery and checkpoints
Deadlock handling in databases

05Unit 5: Concurrency Control 6 topics

Lock-based protocols: shared and exclusive locks
Two-phase locking and its variants
Timestamp-ordering protocol and Thomas write rule
Validation-based protocols
Multiple granularity locking
Multi-version schemes

About

You will be able to

Explain DBMS architecture, data models and data independence
Draw ER diagrams and convert them into relational tables
Write relational algebra expressions and SQL queries with joins, subqueries and views
Find attribute closures and candidate keys and normalise relations up to BCNF
Test schedules for conflict serializability and recoverability
Explain locking, timestamp protocols and log-based recovery

Who it is for

MCA students of Semester 2 (AKTU, Lucknow)
Students preparing for GATE, UGC-NET and database-related placement interviews

What you need

Basic set theory and any programming language

Questions

Which syllabus does this Database Management Systems course follow?

It follows the AKTU (Lucknow) MCA syllabus for Semester 2. If your own university's syllabus differs, the centre follows your university's syllabus and unit order.

Do we practise SQL on a computer?

Yes. SQL queries are run on MySQL / Oracle in the Database Management Systems Lab alongside theory.

How are students tested at the centre?

Unit-wise MCQ tests, numerical / problem practice, previous AKTU question papers and a final mock paper before the semester exam.