Question 1

List the entities, their attributes and relationships for the description given 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 cr

Accepted Answer

To design a Payroll Management System, we first need to define the scope and functionality. Since no specific description is provided, we will assume a standard system that handles employee details, department and designation information, various salary components (earnings and deductions), attendance tracking, loan management, and payslip generation. This system will also account for individual variations in salary structure.

### Entities, Attributes, and Relationships (ER-Diagram Description)

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.

Accepted Answer

To implement the database design from question 1, we establish a relational database for a university system, comprising `Students`, `Courses`, and `Enrollments` tables. This structure demonstrates core RDBMS concepts like primary keys, foreign keys, and various integrity constraints, crucial for maintaining data consistency and validity, as discussed in MCSL-210 Unit 2 on Data Definition Language (DDL).

First, we create the `Students` table with `StudentID` as the primary key. `Name` is declar

Question 3

Answer the following queries based on the Payroll Management System:

Accepted Answer

This analysis of the Payroll Management System assumes a standard relational database schema, typical for a DBMS lab course. The primary tables are `Employees` (EmpID, EmpName, DepartmentID, EmpType, BasicSalary), `Departments` (DeptID, DeptName), `SalaryDetails` (SalaryID, EmpID, MonthYear, Basic, Allowances, Deductions, NetSalary), and `Attendance` (AttendanceID, EmpID, AbsentDate).

Foreign keys link employees to departments (Employees.DepartmentID references Departments.DeptID) and salary/at

Question 4

Write a program to demonstrate use of different data types in Java.

Accepted Answer

To design a Payroll Management System, we first need to define the scope and functionality. Since no specific description is provided, we will assume a standard system that handles employee details, department and designation information, various salary components (earnings and deductions), attendance tracking, loan management, and payslip generation. This system will also account for individual variations in salary structure.

### Entities, Attributes, and Relationships (ER-Diagram Description)

Question 5

Write java programs to demonstrate use of abstract class and interface. Make necessary assumptions.

Accepted Answer

To implement the database design from question 1, we establish a relational database for a university system, comprising `Students`, `Courses`, and `Enrollments` tables. This structure demonstrates core RDBMS concepts like primary keys, foreign keys, and various integrity constraints, crucial for maintaining data consistency and validity, as discussed in MCSL-210 Unit 2 on Data Definition Language (DDL).

First, we create the `Students` table with `StudentID` as the primary key. `Name` is declar

Question 6

Write a java program to demonstrate interthread communications.

Accepted Answer

This analysis of the Payroll Management System assumes a standard relational database schema, typical for a DBMS lab course. The primary tables are `Employees` (EmpID, EmpName, DepartmentID, EmpType, BasicSalary), `Departments` (DeptID, DeptName), `SalaryDetails` (SalaryID, EmpID, MonthYear, Basic, Allowances, Deductions, NetSalary), and `Attendance` (AttendanceID, EmpID, AbsentDate).

Foreign keys link employees to departments (Employees.DepartmentID references Departments.DeptID) and salary/at

Question 7

Write java program to demonstrate useJavaFX in GUI development.

Accepted Answer

JavaFX enables GUI development. The program below shows its fundamental structure: extending `Application`, implementing `start(Stage)`, and displaying components via `Scene` on a `Stage`.

```java
import javafx.application.Application;
import javafx.scene.Scene;
import javafx.scene.control.Label;
import javafx.scene.layout.StackPane;
import javafx.stage.Stage;

public class BasicFX extends Application {
    @Override
    public void start(Stage ps) {
        Label lbl = new Label("Hello JavaFX

Question 8

Write a program using JDBC for simple CRUD application for billing of a general store. Make necessary assumptions.

Accepted Answer

The MCSL-210 course emphasizes Java Database Connectivity (JDBC) for interacting with relational databases. A simple CRUD (Create, Read, Update, Delete) application for a general store billing system demonstrates these fundamental operations. This program would allow managing product information within a database, crucial for accurate billing and inventory control.

For this application, we assume a MySQL database named `general_store_db` is set up with a `products` table. The `products` table w

MCSL-210 Solved Assignment — January 2026 / July 2025

Untitled | IGNOU Bachelor of Computer Applications (BCA_NEWOL)

MCSL-210—January 2026 / July 2025

Untitled

Questions & Answers

Download Study Materials

Related Courses

MCSL-210 Assignment Questions — January 2026

Q2. 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.

Q3. Answer the following queries based on the Payroll Management System:

Q1. Write a program to demonstrate use of different data types in Java.

Q2. Write java programs to demonstrate use of abstract class and interface. Make necessary assumptions.

Q3. Write a java program to demonstrate interthread communications.

Q4. Write java program to demonstrate useJavaFX in GUI development.

Q5. Write a program using JDBC for simple CRUD application for billing of a general store. Make necessary assumptions.