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 SQL
- 3
Part 2 of the syllabusपाठ्यक्रम भाग 2Unit-wise coaching with notes and doubt classes.
Unit 4: NormalisationUnit 5: Transactions and Concurrency
- 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.
Syllabus · पाठ्यक्रम
1 subject · 5 chapters · 24 topics
01Unit 1: Introduction to DBMS
5 topics+
- File system vs DBMS
- Three-schema architecture
- Data independence
- Data models
- DBA and database users
02Unit 2: Entity-Relationship Model
5 topics+
- Entities and attributes
- Relationships and cardinality
- Weak entities
- Generalisation and specialisation
- ER to relational mapping
03Unit 3: Relational Model and SQL
5 topics+
- Keys - super, candidate, primary, foreign
- Relational algebra
- DDL and DML commands
- Joins and sub-queries
- Aggregate functions, GROUP BY and HAVING
04Unit 4: Normalisation
4 topics+
- Anomalies
- Functional dependencies
- 1NF, 2NF and 3NF
- BCNF
05Unit 5: Transactions and Concurrency
5 topics+
- Transaction and ACID properties
- Schedules and serializability
- Lock-based protocols and two-phase locking
- Deadlocks in databases
- Recovery - log-based
About this course
You will be able to
- Explain the advantages of a DBMS, the three-schema architecture and data independence
- Draw ER diagrams and convert them into relational tables
- Write SQL queries - DDL, DML, joins, sub-queries and aggregate functions
- Use relational algebra operations
- Normalise relations up to BCNF using functional dependencies
- Explain transactions, ACID properties, concurrency control and recovery
Who it is for
- BCA students of Semester 5 (UP state universities, Lucknow University pattern)
- Students preparing for developer and database jobs
What you need
- Basic programming and data structures
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 this Database Management System course follow?
It follows the common UP state university BCA syllabus (University of Lucknow pattern) for BCA Semester 5. If your own university's syllabus differs, the centre follows your university's syllabus and unit order.
Which database is used for practice?
MySQL (or Oracle where the college uses it) in the DBMS and Java Lab.
Are SQL queries asked in the theory exam?
Yes - writing queries on a given table is a standard question, along with ER diagrams and normalisation.
