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 to DBMSUnit 2: Entity-Relationship ModelUnit 3: Relational Model and Normalization
- 3
Part 2 of the syllabusपाठ्यक्रम भाग 2Unit-wise coaching with notes and doubt classes.
Unit 4: SQLUnit 5: Transactions, Concurrency and Security
- 4
Unit tests & assignmentsयूनिट टेस्टRegular tests in the university / board pattern.
- 5
Semester 3 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.
Syllabus · पाठ्यक्रम
1 subject · 5 chapters · 24 topics
01Unit 1: Introduction to DBMS
4 topics+
- File system vs DBMS
- Three-schema architecture and data independence
- Data models: hierarchical, network, relational
- DBMS users and DBA
02Unit 2: Entity-Relationship Model
5 topics+
- Entities, attributes and relationships
- Types of attributes
- Cardinality and participation
- Keys: super, candidate, primary, foreign
- Weak entity and ER to table conversion
03Unit 3: Relational Model and Normalization
5 topics+
- Relation, tuple, attribute, domain, degree, cardinality
- Integrity constraints
- Relational algebra: select, project, join, union, difference
- Functional dependency
- 1NF, 2NF, 3NF and BCNF
04Unit 4: SQL
5 topics+
- DDL, DML, DCL and TCL commands
- SELECT with WHERE, ORDER BY
- Aggregate functions, GROUP BY and HAVING
- Joins and subqueries
- Views and indexes
05Unit 5: Transactions, Concurrency and Security
5 topics+
- Transaction and ACID properties
- Transaction states and schedules
- Concurrency problems and locking (2PL)
- Deadlock
- Recovery, backup and GRANT / REVOKE
About this course
You will be able to
- Explain the advantages of DBMS over file systems and the three-schema architecture
- Draw ER diagrams and convert them to relational tables
- Identify keys and integrity constraints and apply relational algebra
- Normalize relations up to 3NF / BCNF using functional dependencies
- Write SQL queries with joins, grouping, subqueries and views
- Explain transactions, ACID properties, concurrency control, recovery and security
Who it is for
- Diploma Computer Science & Engineering students of Semester 3 (BTEUP)
- Polytechnic students of other boards studying the same subject who want unit-wise coaching
What you need
- Basic computer knowledge and programming fundamentals of earlier semesters
Online tests & result
Practice and unit tests online; marks and result show in your student login and at the centre.
Student login →
Questions
Which syllabus does the Database Management Systems course follow?
It follows the BTEUP (Board of Technical Education, Uttar Pradesh) diploma syllabus for Database Management Systems (Computer Science & Engineering, Semester 3). If your own board's or institute's syllabus differs, the centre follows your own syllabus.
Will this help in the semester examination?
Yes. Teaching is unit-wise as per the BTEUP scheme, with previous-year question practice, MCQ tests and doubt sessions before the semester exam.
Which database software is used?
SQL is practised on MySQL (or Oracle / PostgreSQL where the institute uses it).
