IGNOU PGDCA MCS 207 Database Management Systems Previous Years Unsolved Papers

Preface

The field of Database Management Systems (DBMS) is a cornerstone of modern information technology, playing a critical role in how data is stored, managed, and retrieved in today's data-driven world. As organizations across the globe increasingly rely on efficient data management to drive their operations, the demand for skilled professionals in DBMS continues to grow. Recognizing the significance of this field, the Indira Gandhi National Open University (IGNOU) has incorporated Database Management Systems as a key component of its curriculum, challenging students to master both the theoretical frameworks and practical skills necessary to excel in this domain.

This book, IGNOU Database Management Systems Previous Years Unsolved Papers (MCS-207), is a thoughtfully compiled collection of unsolved question papers from previous years. It is designed to serve as an indispensable resource for students preparing for their exams in DBMS. The primary aim of this book is to equip students with a comprehensive tool to self-assess their understanding, pinpoint areas that require further study, and enhance their problem-solving capabilities.

We believe that practicing with previous years’ question papers is one of the most effective strategies for exam preparation. It not only familiarizes students with the types and formats of questions they may encounter but also deepens their grasp of the subject matter by applying concepts to practical, real-world scenarios. By working through these unsolved papers, students will be able to evaluate their readiness, improve their time management skills during exams, and build the confidence needed to tackle complex questions.

The choice to leave the papers unsolved is intentional. We encourage students to engage actively with the material, think critically, and explore various approaches to solving the problems presented. This method promotes independent learning and ensures that students are well-prepared to adapt to the diverse question formats and difficulties they may face during the actual exams.

This book covers a broad spectrum of topics within Database Management Systems, including relational database design, SQL, transaction management, normalisation, and data security. Each paper has been carefully selected to provide comprehensive coverage of the syllabus, offering students a thorough understanding of the core concepts essential for success in their exams.

We hope that this book will not only support students in their academic pursuits but also inspire them to delve deeper into the field of Database Management Systems. As technology continues to evolve, the knowledge and skills gained in DBMS will be instrumental in shaping the future of data management and information systems.

We would like to extend our sincere thanks to the IGNOU faculty and students who contributed to the development of this book. Your feedback and insights have been invaluable in ensuring that this book meets the needs of today’s learners.

I wish you success in your studies and your future endeavours in the field of database management systems.

Table of Contents

Preface

Chapter 1: Term-End Examination, December, 2021

Chapter 2: Term-End Examination, June, 2022

Chapter 3: Term-End Examination, December, 2022

Chapter 4: Most Asked Important Questions Part-A

Chapter 5: Most Asked Important Questions Part-B

MCS-207

Post Graduate Diploma in Computer Application (PGDCA)

Chapter 1: Term-End Examination, December, 2021

MCS-207: Database Management Systems

Time: 3 Hours

Maximum Marks: 100

Weightage: 70

Note:       (i) Question No. 1 is compulsory.

(ii) Answer any three Questions from the rest.

1. (a) A university is planning to maintain the following details :

i. A unique student identification.

ii. Name of the student.

iii. Programme code in which student has enrolled.

iv. Programme names of all the programmes.

v. Programme duration.

vi. Programme fee.

vii. The contact phone number of the student.

viii. The fee paid by the student along with date of payment.

Perform the following tasks for the description given above:

(i) List all the entities, as per the description.                                     2

(ii) List all the attributes of the entities, as per the description.                         2

(iii) Relationship between/among the entities of the description given.                   2

(iv) Draw an ER diagram, as per the description given.                               2

(v) List all the constraints-including primary and foreign keys.                         2

(vi) Convert the E-R diagram to relations.                                           2

(b) Write SQL commands for the queries on the following relations:                  8

Account (account-number, name, balance) Bank (branch-code, account-number, phone)