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

Q2. Attempt the following programming tasks.

• 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 run time i. add a column address in the EMP_SELECTIONtable. 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. (500 words)
• 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., may be present in the dataset. (500 words)