You can check all questions of this assignment below for more clarification before taking this IGNOU MCSL 205 Solved Assignment 2024 pdf download facility.
IGNOU MCSL 205 Assignment 2024 Question Paper
Whereas, You can easily take the IGNOU MCSL 205 solved assignment 2024 pdf download facility. But , Here we shared all the questions of this assignment for more clarification.
- Using Structures write an interactive program in C language to create an application program for a small office to maintain the employee’s database. This application should be having menu options like
- Creating a New Record
- Reading/Listing of Records
- Modify the record
- Delete the record
Each employee record should have Employee Name, Employee ID, Department Name, Salary, Position, Date of Joining, etc. The application should be designed user-friendly.
Note: You must execute the program and submit the program logic, sample input and output along with the necessary documentation for this question. Assumptions can be made wherever necessary
-
- I) Write Program to perform following tasks
- Create a database SELECTION_DB
- Set connection with mysql.connector.connect.
- Create a table EMP_SELECTION in database SELECTION_DB with following data
FIRST_NAME,LAST_NAME,AGE,GENDER,INCOME.
- Change table structure (add,edit,remove column of a table)at runtime
- Add a column address in the EMP_SELECTION table.
- Execute SQL INSERT statement to create a record into EMP_SELECTION table
iii. run the query to updates all the records having GENDER as ‘M’, and increase AGE of all the males by one year.
- Delete all the records from EMP_SELECTION Table where AGE is less than 18.
- II) Write a python code to read a dataset (may be CSV file) and print all features i.e. columns of the dataset. Determine the descriptive statistics i.e. Maximum, Minimum Mean Median, Count, Variance, Standard Deviation etc. of the numeric features like age, salary etc., maybe present in the dataset. (10 Marks)
Note: You must execute the program and submit the program logic, sample input and output along with the necessary documentation for this question. Assumptions can be made wherever necessary
IGNOU MCSL 205 Solved Assignment 2024 Pdf Download Facility
At last, Vidyanju hopes that you all are happy with our IGNOU MCSL 205 Solved Assignment 2024 pdf download facility. Please, visit our store for more assignments.