IGNOU MCSL-205 C and Python Lab - IGNOU Solved Assignment (Latest)

Section 1: C Programming Lab

Question 1: 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

Section 2: PYTHON Programming Lab

Question 2: Attempt the following

I) Write Program to perform following tasks

a. Create a database SELECTION_DB

b. Set connection with mysql.connector.connect.

c. Create a table EMP_SELECTION in database SELECTION_DB with following data
FIRST_NAME,LAST_NAME,AGE,GENDER,INCOME.

d. Change table structure (add,edit,remove column of a table)at runtime

i. Add a column address in the EMP_SELECTION table.
ii. 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.
iv. 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.

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