Question

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

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.

15 Apr 2024
Answer :
Word Count : 369

Sure, let's break down your question and address each part individually.

### I) C Program to Perform Database Operations:

```c
#include <stdio.h>
#include <stdlib.h>
#include <mysql/mysql.h>

void execute_query(MYSQL *conn, char *query) {
    if (mysql_query(conn, query)) {
        fprintf(stderr, "Error: %s\n", mysql_error(conn));
        mysql_close(conn);
      _________ __________ ____ _______ _________ __________ __________ ___ __________.
__________ _______ ______ _______ ________ _______ ____ ________.
_____ __________ ____ ________ _____ _________ ____ ______.
______ ______ ________ ___ _______ ____ ___ _______ ___ _______ ________ ____.
___ ________ ____ ________ _____ ___ __________ ____ ___ _____ _________ ________.
___ _________ ____ ___ ___ ____ ______.
_____ _________ ______ _____ _____ _______ __________ __________.
__________ ______ _______ ______ _____ _______ _____ ________ _____.
__________ ___ ______ ______ ________ _____ __________ ________ _________ __________ ____ ________.
________ _____ _____ _________ _________ _______ _______ __________ ______ ______ _______ ________.
________ ___ __________ _________ ______ __________ ________ ________ ____ ______.
_____ __________ _______ ___ ______ _______ ____ __________ ______ ______ _________ ________.
______ _____ __________ _______ ______ ___ _______ ___ _____ ____ ___.
___ __________ _____ ___ ___ ____ _________ _________ ___.
__________ ________ _____ ______ ________ _________ __________ _____ __________ ___.
____ ________ ______ ___ _____ _______ ____ _______ _________ _______ ___ ________.
____ _____ ___ _______ _______ __________ ________.
__________ _____ ________ ____ _______ _____ ________ _____.
______ _______ ________ ______ ____ ________.
__________ _________ _________ __________ __________.
__________ ______ ________ ____ _____ ____ _____ _____ _________ _________ ________ _________.
____ ___ ____ __________ _________ ___ _________ ______ _________.
_____ _________ ____ ______ ______ __________ _________ __________.
________ _____ __________ ___ ______ ___ ________ ______ ______.
_________ ___ _____ __________ ______ _________ ____ ______ ______ _________ ________ __________.
__________ ______ __________ _________ ___ _____ __________ _______ _____ ____ _______ __________.
______ _____ __________ _________ ___ _________ ______.
_______ ________ ____ __________ _____ ___ _____ _______ ______.
_______ _______ _________ ____ ________.
_____ ______ _________ ____ ___ ___ _______ _____.
__________ _________ _____ ___ _____.
________ _____ ___ ______ ___ _______ __________ ___ ____ ____ ___.
_______ ___ __________ _____ _________ ______.
____ __________ ____ ____ ____ _________ ________ __________.
Get Full Answer on WhatsApp

IGNOU NEWS
Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★
Top
📞
Call Support Instant phone assistance I)  Write Program to perform following tasksa. Create a datab
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→