IGNOU MCSL-210 Assignment 2026–27 | DBMS and Java Lab
Looking for the latest IGNOU MCSL-210 Assignment for
the 2026–27 session? This page provides a complete overview of the
course, assignment details, submission information, key DBMS and Java Lab
concepts, and FAQs to help you prepare your assignment with confidence.
About MCSL-210
MCSL-210: DBMS and Java Lab is the practical component of the PGDCA programme
that helps students apply the concepts of Database Management Systems (DBMS)
and Java programming through hands-on laboratory exercises. The course
focuses on writing SQL queries, designing databases, implementing database
operations, and developing Java programs that demonstrate object-oriented
programming concepts. It strengthens both database management and Java
programming skills through practical assignments.
Assignment Details
|
Particular |
Details |
|
Course Code |
MCSL-210 |
|
Programme |
PGDCA (New) |
|
Assignment Code |
PGDCA_NEW(II)/210/Assignment/2026-27 |
|
Submission Deadline |
31 October 2026 (July Session) / 30
April 2027 (January Session) |
What You'll Learn in
MCSL-210
This lab course focuses on the practical implementation of Database
Management Systems (DBMS) and Java programming, including SQL
queries, database design, CRUD operations, Java classes and objects, exception
handling, file handling, and basic GUI programming through hands-on exercises.
IGNOU MCSL-210 DBMS
and Java Lab | Solved Assignment 2026-27
Note: This assignment has two sections. Answer all
questions in each section. Each Section is of 20 marks. Also, your Lab Records
will carry 40 Marks (20 Marks for each section). The remaining 20 marks are for
viva voce (10 marks for each section). You may use illustrations and diagrams
to enhance the explanations. You must execute the program and submit the
program logic, sample input and output along with the necessary documentation.
Assumptions can be made wherever necessary. Please go through the guidelines
regarding assignments given in the programme guide for the format of
presentation.
Section 1: DBMS Lab
A destination management company provides an online reservation facility for custom tour packages. This system maintains a relational database tracking Tour Packages (including package categories, base pricing, and specialised discounts for premium corporate partners and frequent regular customers), Travellers (classified into Standard Class and Premium Class), Bookings, and Itinerary Line Items.
To confirm any itinerary,
travellers must complete a profile registration by providing their primary dispatch
address, contact details, a verified email ID, and a mobile number. To manage
corporate premium status and loyalty discounts, an organisational subscription
fee is billed to the account. An individual booking can aggregate multiple
distinct tour packages as per their choice, and a traveller can manage multiple
active bookings simultaneously. The system processes transactions via online
payment gateways or deferred Cash-on-Arrival (COA) vouchers at the destination
terminal.
Question 1:
List the entities, their attributes and
relationships for the description given above and make an ER diagram for this
system. You may use the concept of keys, aggregation, generalisation,
cardinality etc. as per need. Design suitable RDBMS tables for the ER-diagram
you have created. The database design should include keys, foreign keys,
constraints and referential integrity constraints. Your database design should
be normalized up to 3rd Normal Form. Make necessary assumptions and list them
wherever required.
Question 2:
Implement the database design (create tables)
that you have created in Question 1 using an RDBMS with proper integrity
constraints. Enter about 8- 10 meaningful records in each of your tables.
Question 3:
Write and run the following queries for your
database using SQL commands:
Query 1: List all travellers whose PIN code is
"110068" and who possess corporate premium status.
Query 2: List the booking ID and aggregate invoice
amount of reservations confirmed during 01-06-2026 to 30-08-2026.
Query 3: Display traveller profiles who finalised the
bookings on 10-8-2026 with an aggregate invoice threshold amount exceeding Rs.
25,000.
Query 4: Filter traveller records whose names begin
with the alphabetical character ‘A’ and operate under standard non-corporate
accounts.
Query 5: Identify tour package records that have zero
booking entries during the initial week of July 2026.
Query 6: Find the total number of packages booked by
corporate premium customers between 01-07 2026 and 31-07-2026.
Query 7: Find the average cost of packages booked
during July 2026.
Section 2: Java Lab
Question 1:
Write a Java program to demonstrate data access
control. Use two separate classes to show/display the visibility levels of
private, default, protected, and public data members.
Question 2:
Write a Java program to simulate a
hospitality/tourism application scenario to demonstrate constructor
overloading, method overloading (compile-time polymorphism), and method
overriding (runtime polymorphism). Make necessary assumptions.
Question 3:
Write a Java program to create a custom
exception InvalidAgeException to validate traveller registration profiles for a
hospitality/tourism application scenario. Make necessary assumptions.
Question 4:
Develop a standalone hospitality/tourism
application using JDBC. This standalone application implements full Create,
Read, Update, and Delete operations on database tables created by you. Make
necessary assumptions.
Frequently Asked
Questions
Q. What is MCSL-210?
MCSL-210 is the DBMS and Java Lab, a practical PGDCA
course that enables students to apply database management and Java programming
concepts through laboratory-based exercises.
Q. What is the
assignment code?
PGDCA_NEW(II)/L-210/Assignment/2026-27
Q. How many marks is
the assignment worth?
The assignment carries 100 marks and contributes 30%
weightage to the final course evaluation.
Q. What is the
submission deadline?
- 31
October 2026
(July Session)
- 30
April 2027
(January Session)
Q. What are the key
topics covered in MCSL-210?
The course covers SQL, database design, CRUD operations,
Java programming, object-oriented programming (OOP), exception handling, file
handling, and basic GUI development through practical laboratory exercises.
Need More Help?
For the latest IGNOU
assignment updates, study guides, and academic support, visit MyExamSolution.com
or connect with us on WhatsApp: 9310183377.
0 comments:
Note: Only a member of this blog may post a comment.