Question

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

13 Sep 2024
Answer :
Word Count : 595

To create a table named `EMP_SELECTION` in a database called `SELECTION_DB` with the specified columns (`FIRST_NAME`, `LAST_NAME`, `AGE`, `GENDER`, `INCOME`), you will need to perform the following steps using both C and Python. Below, I will provide code examples for both languages to demonstrate how to achieve this task.

### Using Python

In Python, you can use the `sqlite3` module for working with SQLite databases, or other modules like `pymysql` for MySQL, depending on your database system. Below is an example using SQLite:

```python
import sqlite3

# Connect to SQLite database (or create it if it doesn't exist)
conn = sqlite3.connect('SELECTION_DB.db')

# Create a cursor object
cursor = conn.cursor()

# SQL statement to create the table
create_table_sql = '''
CREATE TABLE IF NOT EXISTS EMP_SELECTION (
    FIRST_NAME TEXT NOT NULL,
    LAST_NAME TEXT NOT NULL,
    ________ ______ _____ __________ _______ _________ ______.
_________ _________ ____ ____ ___ _____ ___ _______ ___.
___ __________ ___ ___ ___ ____ _____ _________ __________ ________ ___.
____ ___ ___ _______ __________ _______ ____ ___ __________ ___ _______.
_____ ________ _____ _______ ____ ________ _____ ____.
_____ _____ _____ ___ __________ __________.
________ ______ _____ ________ ___ _____ __________ ______ ______ _______ _______ _____.
___ ___ ______ ____ ___ _______ _____.
________ ___ ___ __________ _______ ____.
__________ _______ _________ ___ _____ ________ ________ ______ ____ __________ __________ __________.
______ _____ _______ _______ ______ _____ ___ ___ _____ ________ ____.
_________ ___ _______ ________ _____ ___ _________ _____.
_______ _______ __________ _________ ____ _________ ________ __________ ________.
______ __________ __________ ____ __________ ______ ______ _____ ___.
_____ _________ __________ ___ __________ _____ __________ _____ ________ ____.
______ ______ ______ _________ ____ _______.
_______ ________ _________ ______ ____ _________ _______ _______ _____ _________ ____.
___ _________ _______ ____ _______ _____.
______ ______ _________ ___ ________ ____ ______ __________.
_____ _______ _______ ____ ______ ____ _______ _______ ______ __________.
______ _______ ________ ______ ______ _________ ______ _______.
________ _____ ______ __________ __________ _______ ________.
_____ _________ ______ __________ _________.
____ __________ __________ _____ ______ ____.
__________ _______ ________ _____ ___ ____ _____ _____ _________ _______ _________ __________.
_______ _________ _________ ______ ____ _________ ________ ______ ________ __________ ______ ________.
__________ ___ __________ ___ ________ __________ __________ _______ _____ __________ ____.
______ __________ _______ ___ __________ _____ ___ _____ ______ _______ ___ _______.
__________ ___ __________ ___ _________ _________ _________ _______ ______.
___ _______ ________ ___ _______ _______ ___ __________ _________ ________.
___ _______ ___ ________ ____ __________.
_______ __________ ____ ______ ____ ______ ____.
________ __________ ____ ________ ______.
_____ ______ _______ _____ __________.
______ ______ __________ __________ __________ __________ ____ _____ __________ _____.
________ _____ ______ _________ _____.
___ _______ ____ ____ _______ ______ _______ _______ ____ _____.
______ ________ __________ ___ ______.
________ _________ ____ ________ ___ ________ ____ ________ _____ ____ ____.
_________ ________ ________ _____ ____ __________ _________ _____ __________ ________.
_______ ________ ____ ________ _____ ____.
_____ __________ _______ ___ ______.
_____ ________ _____ _______ ________ ____ _________ __________ _______ ________.
_______ _____ ____ _____ __________ _______ ________ __________ ________ ____ ___ __________.
_______ __________ __________ ________ __________ ___ _____ _____ ________ _______.
___ ________ ____ ______ ________ ______ _______ _________ __________ ______.
__________ __________ __________ ___ _____ _____ _____ ______ _______ _______ ________ _________.
_____ _________ ______ _____ ____ ___ ________ ____ __________ _____ ____ ___.
________ _________ __________ ___ ____ _____ _______ ____ ________ ________ ______ __________.
_______ __________ ____ __________ ________ _____ ____ _________.
_______ __________ ______ ___ ________ _____ _________.
Get Full Answer on WhatsApp

Related Questions

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.

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

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

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.

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.

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers
Login Cart
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 Create a table EMP_SELECTION in database SELECTION_DB with following d
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→