IGNOU MCSL 210 Solved Assignment 2026-27 English Medium PDF Download

IGNOU MCSL 210 Solved Assignment 2026-27 English Medium Question Paper

MCSL 210 : DBMS and Java Lab

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.

How to Get Your IGNOU MCSL 210 Solved Assignment 2026-27 English Medium PDF?

It only takes a minute: click Add to Cart, complete your payment, and your download button appears right there on screen. We also email your IGNOU MCSL 210 Solved Assignment 2026-27 English Medium PDF download link straight away — so even if you miss it the first time, it’s waiting in your inbox.

You’ll have up to 5 downloads within 7 days of purchase, so save the PDF somewhere safe — your downloads folder, Drive, or email — as soon as you get it.

Want the Original IGNOU MCSL 210 Assignment 2026-27 English Medium Question Paper PDF?

Our PDF includes the full question paper alongside every solved answer, but if you’d like to download the original, blank IGNOU MCSL 210 Assignment 2026-27 English Medium Question Paper PDF straight from IGNOU first, you can get it directly from IGNOU’s official assignment portal.

You sorted this one — now sort the rest

One assignment down. If you’ve got more pending, head to the homepage and search your course code — we’ve probably already got it solved and ready to download.

Important Note: This IGNOU MCSL 210 Solved Assignment 2026-27 English Medium PDF is meant to be used as a study reference, not submitted as-is. Read it, understand how each answer is structured, then write your own version in your own words. We strongly discourage copying or any form of academic dishonesty.