What are Pandas ? Write steps to import, read and print a CSV file using Pandas. Also, transform your steps in to suitable code in Python. 

Discuss the connect( ) method of MySQL. Connector interface. List the
arguments involved with connect( ) method. Write Python code to create
database student_DB and to connect to student_DB (make suitable assumptions
wherever necessary).

Write an algorithm to find the HCF (Highest     Common     Factor) of
the two   numbers entered    by   a    user.    Transform   your   algorithm   into a C
program, support your program with suitable comments.

Write an algorithm to find the slope of a line segment whose end point
coordinates are (x1, y1) and (x2, y2). The algorithm gives output whether the slope
is positive, negative or zero. Transform your algorithm into C program.

Note : Slope of line segment = (y2 – y1)/ (x2 – x1).

Briefly discuss the relation between pointers and arrays, giving suitable example. Write a program in C, to print transpose of a 2D matrix entered by a user. Also give comments. 

Briefly discuss the concept of “Call by value” and “Call by reference”. Give example code in C for each. Support your code with suitable comments.

Write a program using JDBC for simple CRUD application.

Write java programe to demonstrate use of StringBuider class methods ensureCapacity, setLength , append and replace.

Write a java program to create and use user defined exception 

Write a java program to demonstrate constructor overloading, method overloading and method overriding. Make necessary assumptions. 

Write a program to demonstrate use of different access specifiers in Java

List the order details of the orders which are placed by prime members on 10-8-2024 and payment mode is COD. 

Find the detail of products which not have been ordered even once during first week of the month

. List the “Home & Kitchen Appliences” products information in the increasing order of discount rate ( in terms of percentage of price) for prime members. 

 Find the total price of the order id O00105 .

. List all the customers whose name starts with alphabet ‘P’ and are not prime member.

List the customer details, who has placed their orders on 10-8-2024 and order value is more than 5000. 

List the order id and amount of those orders which are placed during 2nd week of the month and are of amount less than 20,000.

Write and run the following queries for your database using SQL commands: 1. List all the customers whose pin code is “ 110068” and have prime membership.

Implement the database design (create tables) that you have created in question 1 using a RDBMS with proper integrity constraints. Enter about 8- 10 meaningful records in each of your table.