Your roadmap · आपका रोडमैप
- 1
Admission & first meetingप्रवेश और पहली मुलाकातEnquire at your nearest NDSS centre, meet the teacher, fix the batch time and get your study material.
- 2
Part 1 of the syllabusपाठ्यक्रम भाग 1Unit-wise coaching with notes and doubt classes.
Unit 1: Introduction and ER ModelUnit 2: Relational Model and SQLUnit 3: Database Design and Normalisation
- 3
Part 2 of the syllabusपाठ्यक्रम भाग 2Unit-wise coaching with notes and doubt classes.
Unit 4: Transaction Processing and RecoveryUnit 5: Concurrency Control
- 4
Unit tests & assignmentsयूनिट टेस्टRegular tests in the university / board pattern.
- 5
Semester 2 exam (university / board)विश्वविद्यालय / बोर्ड परीक्षाPrevious papers and full revision before the exam.
- 6
Online tests & resultऑनलाइन टेस्ट और रिज़ल्टTake the tests online; your marks and result show in your student login and at the centre.
सिलेबस · पाठ्यक्रम
1 subject · 5 chapters · 29 topics
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
About this course
आप यह कर पाएँगे
- 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
Online tests & result
Practice and unit tests online; marks and result show in your student login and at the centre.
Student login →
सवाल
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.
