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: Data Models and ER ModellingUnit 3: Relational Model and Relational Algebra
- 3
Part 2 of the syllabusपाठ्यक्रम भाग 2Unit-wise coaching with notes and doubt classes.
Unit 4: SQLUnit 5: Normalisation and Transactions
- 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.
Syllabus · पाठ्यक्रम
1 subject · 5 chapters · 25 topics
01Unit 1: Introduction to DBMS
5 topics+
- File system vs DBMS
- Three-level architecture and data abstraction
- Physical and logical data independence
- Database users and DBA
- DBMS architecture
02Unit 2: Data Models and ER Modelling
5 topics+
- Hierarchical, network and relational models
- Entities, attributes and relationships
- Cardinality and participation
- Weak entities, generalisation and specialisation
- ER to relational mapping
03Unit 3: Relational Model and Relational Algebra
5 topics+
- Relations, tuples and domains
- Super, candidate, primary and foreign keys
- Integrity constraints
- Selection, projection, join, set operations
- Cartesian product and division
04Unit 4: SQL
5 topics+
- DDL, DML, DCL and TCL commands
- Constraints in SQL
- Aggregate functions, GROUP BY and HAVING
- Joins and subqueries
- Views
05Unit 5: Normalisation and Transactions
5 topics+
- Functional dependencies
- 1NF, 2NF, 3NF and BCNF
- Transactions and ACID properties
- Concurrency control: locking
- Recovery basics
About this course
You will be able to
- Explain the advantages of a DBMS, the three-level architecture and data independence
- Draw ER diagrams and convert them into relational tables
- Apply keys, integrity constraints and relational algebra operations
- Write SQL queries using constraints, aggregate functions, GROUP BY, joins, subqueries and views
- Normalise relations up to BCNF using functional dependencies
- Explain ACID properties, concurrency control and recovery basics
Who it is for
- B.Sc Computer Science students of Semester 2 (UP State Universities NEP 2020 common minimum syllabus)
- Students preparing for BCA / MCA entrance and IT job interviews
What you need
- B.Sc Computer Science Semester 1
- Basic computer operation
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 course follow?
It follows the UP State Universities NEP 2020 common minimum syllabus for B.Sc Computer Science, Semester 2. Where your own university's syllabus differs, the centre follows your university's syllabus and question pattern.
Which database software is used?
MySQL or Oracle (as per your university); SQL practised in the Database Management System Lab of the same semester.
Is there a test after the course?
Yes. Unit-wise multiple-choice tests and a final exam paper are included for semester exam practice.
