Help?
PLEASE MATCH YOUR ASSIGNMENT QUESTIONS ACCORDING TO YOUR SESSION
IGNOU MCSL-210 (July 2025 – January 2026) Assignment Questions
Section 1: DBMS Lab
A Payroll management is a critical component, ensuring timely and accurate payment of salaries, benefits, and allowances to the employees of an orgenization. A construction company which undertakes various infrastructure projects such as buildings, roads, and bridges wants to develop payroll management system for covering various employee categories and associated payroll details. The company employs a diverse workforce consisting of both technical and non-technical staff. The database records manage details of Employees and their associations with Departments, Basic Salary, Attendance, Allowances/Incentives and Deductions, Leave Records, Employee type (Contract Details /Permanent/Part time etc.)
Question 1: List the entities, their attributes and relationships for the description given (10 Marks) above and make an ER-diagram for this Payroll Management System. You may use the concept of keys, aggregation, generalization, cardinality etc. as per need. Design the 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 wherever require
Question 2: Implement the database design (create tables) that you have created in question (4 Marks) 1 using a RDBMS with proper integrity constraints. Enter about 8- 10 meaningful records in each of your table.
Question 3:
1. List all permanent employees with their department name
2. Show the June 2025 salary details of all employees who are working in Maintenance Department
3. Get employee names along with their basic salary and employee type
4. Find top 5 highest paid employee (highest basic salary) in August 2025
5. Show average allowances per employee for July 2025
6. Show employees whose tax deductions exceed ₹20,000 in July 2025
7. Count the number of employees in each department
8. Find employees who were absent between June 10, 2025 and Jule 15, 2025
9. List engineers with net salary > ₹75,000 in August 2025
10. Find the sum of net salary paid to all the employees
11. Find average salary of employees in July 2025 for maintenance department
12. Find total number of employees working in the company in May 2025.
Section 2: Java Lab
Question 1: Write a program to demonstrate use of different data types in Java.
Question 2: Write java programs to demonstrate use of abstract class and interface. Make necessary assumptions.
Question 3: Write a java program to demonstrate interthread communications.
Question 4: Write java program to demonstrate useJavaFX in GUI development.
Question 5: Write a program using JDBC for simple CRUD application for billing of a general store. Make necessary assumptions.
IGNOU MCSL-210 (July 2024 – January 2025) Assignment Questions
Section 1: DBMS Lab
An e-Commerce portal provide online product purchase/shopping facility to its customers. It maintains the database of Products( including product category, price, discont to prime members) Customers (regular customer, prime customer) , Orders and Order Details . Customers need to register themselves by providing their address and contact details including email id and mobile number before placing any order. To become a prime customer a membership fee is charged to the customer. Customer order may include more than one products and a customer can place more than one orders. This shopping portal provides facility of both online payment and cash on delivery (COD).
Question 1:
List the entities, their attributes and relationships for the description given above and make an ERdiagram for this e-Commerce Portal. You may use the concept of keys, aggregation, generalisation, cardinality etc. as per need. Design the 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 wherever require.
Question 2:
Implement the database design (create tables) that you have created in question 1 using a RDBMS with proper integrity constraints. Enter about 8- 10 meaningful records in each of your table.
Question 3:
Write and run the following queries for your database using SQL commands:
1. List all the customers whose pin code is “ 110068” and have prime membership.
2. List the order id and amount of those orders which are placed during 2nd week of the month and are of amount less than 20,000.
3. List the customer details, who has placed their orders on 10-8-2024 and order value is more than 5000.
4. List all the customers whose name starts with alphabet ‘P’ and are not prime member.
5. Find the total price of the order id O00105 .
6. List the “Home & Kitchen Appliences” products information in the increasing order of discount rate ( in terms of percentage of price) for prime members.
7. Find the detail of products which not have been ordered even once during first week of the month.
8. List the order details of the orders which are placed by prime members on 10-8-2024 and payment mode is COD.
Section 2: Java Lab
Question 1:
Write a program to demonstrate use of different access specifiers in Java.
Question 2:
Write a java program to demonstrate constructor overloading, method overloading and method overriding. Make necessary assumptions.
Question 3:
Write a java program to create and use user defined exception
Question 4:
Write java programe to demonstrate use of StringBuider class methods ensureCapacity, setLength, append and replace.
Question 5:
Write a program using JDBC for simple CRUD application.
