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, Relational Algebra 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 5 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 · 30 topics
01Unit 1: Introduction and ER Model
6 टॉपिक+
- Database system vs file system
- DBMS architecture, data models, schema and instances
- Data independence, DDL and DML
- ER model: entities, attributes, relationships, mapping constraints
- Keys: super, candidate, primary
- Generalisation, aggregation and reduction of ER diagrams to tables
02Unit 2: Relational Model, Relational Algebra and SQL
6 टॉपिक+
- Relational model and integrity constraints (entity, referential, domain, key)
- Relational algebra
- Tuple and domain relational calculus
- SQL: DDL, DML, operators, sub-queries and aggregate functions
- Joins, union, intersect, minus, views and indexes
- Cursors, triggers and procedures in PL/SQL
03Unit 3: Database Design and Normalisation
6 टॉपिक+
- Functional dependencies and closure
- 1NF, 2NF, 3NF and BCNF
- Lossless join and dependency preserving decomposition
- Multivalued dependencies and 4NF
- Join dependencies and 5NF
- Alternative approaches to database design
04Unit 4: Transaction Processing and Recovery
6 टॉपिक+
- Transaction concept and ACID properties
- Schedules: conflict and view serializability, precedence graph
- Recoverable and cascadeless schedules
- Log-based recovery and checkpoints
- Deadlock handling
- Distributed databases: data storage, concurrency control
05Unit 5: Concurrency Control
6 टॉपिक+
- Lock-based protocols and two-phase locking
- Timestamp ordering protocol
- Validation based protocol
- Multiple granularity locking
- Multiversion schemes and recovery with concurrent transactions
- Case study of Oracle
About this course
आप यह कर पाएँगे
- Explain DBMS architecture, data models, schemas and data independence
- Draw ER / EER diagrams and reduce them to relational tables
- Write relational algebra expressions and SQL queries with joins, sub-queries, views and aggregates
- Normalise relations up to BCNF / 4NF using functional and multivalued dependencies
- Test schedules for conflict and view serializability and explain log-based recovery
- Explain locking, timestamp and validation based concurrency control protocols
यह किसके लिए है
- B.Tech Computer Science & Engineering, Information Technology students of Semester 5 (AKTU)
- Students of other universities studying the same subject who want unit-wise coaching
आपको क्या चाहिए
- Data Structure and Discrete Structures (Semester 3)
- Basic programming knowledge
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 the Database Management System course follow?
It follows the AKTU (Dr. A.P.J. Abdul Kalam Technical University, Lucknow) B.Tech syllabus for Database Management System. If your own university's syllabus differs, the centre follows your university syllabus.
Will this help in the university examination?
Yes. Teaching is unit-wise as per the AKTU scheme, with previous-year question practice, MCQ tests and doubt sessions before the semester exam.
Is SQL practice included?
Yes. SQL queries are practised on MySQL / Oracle along with the theory, which also prepares you for the DBMS lab and placement tests.
