IGNOU MCSL-210 Assignment 2026-27
DBMS and Java Lab
Last updated by IGNOU: 15 Jul 2026. Guide written from the official PDF on 08 Nov 2026, 08:55 pm.
Downloads need a free login with your Google account.
Make the MCSL-210 assignment front page →| Course code | MCSL-210 |
|---|---|
| Course title | DBMS and Java Lab |
| Programme | Post Graduate Diploma in Computer Applications (PGDCA-NEW)PGDCA_NEW |
| School | School of Computer and Information Sciences |
| Assignment code | PGDCA_NEW(II)/L-210/Assignment/2026-27 |
| Session | July 2026 and January 2027 |
| Maximum marks | 100 |
| Weightage | 30% |
| Last date (June exam) | 30 Apr 2027 |
| Last date (December exam) | 31 Oct 2027 |
| Medium | English |
About the MCSL-210 assignment
The assignment covers relational database design and SQL using a tour reservation scenario, followed by Java programs on access control, polymorphism, exceptions and JDBC.
It has two sections worth 20 marks each, with three DBMS questions and four Java questions. Lab records carry 40 marks and the compulsory viva carries 20 marks.
What the assignment asks
| Question | Marks | Topic |
|---|---|---|
| Section 1, Question 1 | 8 | Design an ER diagram and normalized relational tables for the tour reservation system, including keys and integrity constraints. |
| Section 1, Question 2 | 5 | Implement the database tables with integrity constraints and add meaningful records. |
| Section 1, Question 3 | 7 | Write and run seven SQL queries about travellers, bookings, invoices and tour packages. |
| Section 2, Question 1 | 3 | Demonstrate Java data-member access levels using two classes. |
| Section 2, Question 2 | 6 | Demonstrate constructor overloading, method overloading and method overriding in a tourism or hospitality scenario. |
| Section 2, Question 3 | 5 | Create a custom Java exception to validate traveller ages during registration. |
| Section 2, Question 4 | 6 | Build a standalone tourism or hospitality application that performs database CRUD operations using JDBC. |
This is a summary of each question. Download the official PDF above for the exact questions and word limits.
How to write and submit it
- Answer every question in both sections.
- Execute the programs and submit their logic, sample inputs and outputs, and necessary documentation.
- State any assumptions made where needed; illustrations and diagrams may be used to clarify explanations.
- Follow the assignment presentation guidelines in the PGDCA Programme Guide.
- Submit the assignment to the Coordinator of your Study Centre by the applicable due date.
- Attend the compulsory viva: an assignment submitted without attending it is treated as incomplete and marked zero.
- For the lab practical examination, meet the minimum attendance requirements and submit the assignment on time.
Submission dates: 30 April 2027 (June term-end exam); 31 October 2027 (December term-end exam). Dates can differ by session; these are the current listing dates.
Frequently asked questions
What is the MCSL-210 assignment for July 2026 and January 2027?
It is the DBMS and Java Lab assignment for the Post Graduate Diploma in Computer Applications (PGDCA-NEW).
How many marks and what weightage does the assignment carry?
The assignment carries 100 marks and has a weightage of 30%.
How are the 100 marks divided?
The two question sections carry 20 marks each, lab records carry 40 marks, and the viva carries 20 marks.
Is the viva compulsory?
Yes. If a student submits the assignment but does not attend the viva, the assignment is treated as incomplete and marked zero.
Where should I submit the assignment?
Submit it to the Coordinator of your Study Centre by the applicable due date.
What are the submission dates?
The current listing gives 30 April 2027 for the June term-end exam and 31 October 2027 for the December term-end exam. The PDF gives different dates by session.
Other IGNOU PGDCA_NEW assignments
- MCS-201: Programming in C and Python
- MCS-206: Object Oriented Programming Using Java
- MCS-207: Database Management Systems
- MCS-208: Data Structures and Algorithms
Assignment details and PDFs come from IGNOU's official website; the guide is a summary of the official PDF. Always check the latest instructions and last dates on ignou.ac.in or with your Regional Centre before submitting.