Database Management Systems (MCA)

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

6 महीनेअवधि 5Chapters29टॉपिक

अभी पूछताछ करें

सिलेबस · पाठ्यक्रम

Download PDF

01Unit 1: Introduction and ER Model 6 टॉपिक

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 टॉपिक

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 टॉपिक

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 टॉपिक

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 टॉपिक

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

परिचय

आप यह कर पाएँगे

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

यह किसके लिए है

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

आपको क्या चाहिए

Basic set theory and any programming language

सवाल

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.