IGNOU MCS 207 Database Management Systems: Assignment, Question Papers and Study Blocks

Part of IGNOU Study Material: IGNOU Study Material 2026: How to Check Book Status and Download eSLM PDF?

MCS 207 Database Management Systems at a glance

MCS 207 subject name and where it sits in 3 IGNOU programmes

MCS 207 Database Management Systems is a 4-credit course requiring 120 hours of learner study. It is part of three IGNOU programmes. The course is listed in the Master of Science (Data Science and Analytics) (MSCDSA) programme, appearing in the First Year, First Semester. Students in this MSCDSA term also study MCS 061 Mathematical Foundations- I, MCS 062 Introduction to Data Science, MCS 063 Data Structures using Python, MCSL 064 Data Structures using Python Lab, and MCSL 065 Data Science Lab.

MCS 207 is also part of the Bachelor of Computer Applications (BCA) programme, placed in the Third Semester. In the same BCA term, learners take MCS 208 Data Structures and Algorithms, MCSL 209 Data Structures and Algorithms Lab, BCS 131 Programming in C++, BCSL 135 DBMS and C++ Lab, and BCS 040 Statistical Techniques. For the Master of Science (Artificial Intelligence and Machine Learning) (MSCAIML) programme, MCS 207 is listed in Semester II. Other courses in this MSCAIML term include MCS 066 Mathematical Foundation –II, MCS 084 Machine Learning, MCS 085 Pattern Recognition, MCSL 086 Machine Learning and Pattern Recognition Lab, and MCSL 087 Database Management Systems Lab. All three programmes are offered through the School of Computer & Information Sciences (SOCIS) and use English as the medium of instruction.

The whole programme: IGNOU MSCDSA fees, eligibility and admission, IGNOU BCA syllabus and IGNOU MSCAIML fees, eligibility and admission.

MCS 207 syllabus: the 4 study blocks on eGyanKosh

The MCS 207 Database Management Systems course material is available on eGyanKosh. This platform hosts the official study blocks for the 4-credit course.

The course is structured into four study blocks. Block 1, “The Basic Concepts,” introduces fundamental database ideas. Block 2, “Database Normalisation and Database Query,” then builds on this foundation by covering data organisation and retrieval methods.

The 4 blocks hold 16 units between them:

1. Block 1: The Basic Concepts
   • Unit 1: Database Management System–An Introduction
   • Unit 2: Relational Database
   • Unit 3: Entity Relationship Model
   • Unit 4: File Organisation in DBMS
2. Block 2: Database Normalisation and Database Query
   • Unit 5: Database Integrity, Functional Dependency and Normalisation
   • Unit 6: Higher Normal Forms
   • Unit 7: Structured Query Language
   • Unit 8: Structured Query Language (Part-II)
   • Unit 9: Advanced SQL
3. Block 3: Database Transactions and Query Processing
   • Unit 10: Transactions and Concurrency Management
   • Unit 11: Database Recovery and Security
   • Unit 12: Query Processing and Evaluation
4. Block 4: Introduction to Advanced Database Models
   • Unit 13: Object-Oriented Database
   • Unit 14: Data Warehousing and Data Mining
   • Unit 15: NoSQL Database
   • Unit 16: Emerging Database Models

Getting the printed books and e-books: IGNOU study material.

MCS 207 assignment: download, submission and marks

IGNOU posts each session’s assignment files programme by programme on its assignments page.

Learners must write and submit assignment responses before taking the Term-End Examination (July 2026). The assignments for the current session are put on the website for download (July 2026). Tutor Marked Assignments go to the Coordinator of the learner’s Learner Support Centre (July 2026).

MCS 207 is also part of IGNOU Bachelor of Computer Applications (BCA) in III Semester. All these programmes are offered in English medium by the School of Computer & Information Sciences (SOCIS).

A failed assignment must be re-submitted. Once an assignment is passed, it cannot be re-submitted to improve the grade.

Assignment rules that apply to every IGNOU course: front page format, paper and margin rules, binding and envelope and checking assignment status.

MCS 207 question papers and the term-end exam

IGNOU posts previous term-end question papers for MCS 207 on its Previous Question Papers page. These papers are arranged by programme and course. The term-end examination sessions for MCS 207 are held twice a year, in June and December. For example, the July 2026 session and the December 2026 TEE both follow this schedule. Examination centres are available across the country and abroad.

The examination fee for MCS 207 is Rs. 200 per theory course, as seen in the December 2026 TEE. Learners may write the exam in Hindi even if registered in English medium, except for language programmes. Hall tickets are uploaded on the University website and are not sent by post. Numerical marks and division (I, II or Pass) are provided for bachelor’s and master’s degrees upon request. Only term-end theory exams can be re-evaluated; projects, practicals, workshops, assignments, or seminars are not eligible for re-evaluation.

MCS 207 previous year question papers

The last 6 term-end papers on IGNOU’s question paper site:

MCS 207 exam pattern

The June 2026 paper runs 3 hours and carries 100 marks. The instruction at the top reads: “Question No. 1 is compulsory and carries 40 marks. Attempt any three questions from Question Nos. 2 to 5.”

MCS 207 topics asked in more than one exam

Read across the 6 papers, these subjects came back:

How the questions in these papers spread over the blocks (30 of 30 questions match a unit):

For the exam itself: previous year question papers by programme, the exam form, the date sheet and results and grade card.

Official IGNOU links for MCS 207

• eGyanKosh: MCS-207 Database Management Systems
• IGNOU previous term-end question papers
• IGNOU assignments page

Common IGNOU Questions