Ques 1.

List the entities, their attributes and relationships for the description and make an ER-diagram for this e-Commerce Portal. You may use the concept of keys, aggregation, generalisation, cardinality etc. in a proper way. Design the suitable RDBMS tables for the ER-diagram created by you. The database design should include keys, foreign keys, constraints and referential integrity constraints. Your database design must be normalized up to 3rd Normal form. Make necessary assumptions wherever require.

Ques 2.

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

Ques 3.

Write and run the following queries for your database using SQL commands:
1. List all the customers whose pin code is “1100067”.
2. List the order id and amount of those orders which are placed in first week of the month and are of
amount more than 10,000.
3. List the customer name and contact number of those customers who have placed more than one
order in October 2023.
4. List the customer details, who has placed their orders on 10-10-2023.
5. List all the customers whose name starts with alphabet ‘A’.
10
6. Find the total price of the order id O0011 .
7. List the electronic products information in the increasing order of price.
8. Find the detail of products which have been ordered more than once.
9. ist the order details of the orders placed on 11-10-2023 and payment mode is COD.
10. List the different types (such as electronic, grocery, cloth etc.) of items available for shopping.

Ques 4.

Write a program to demonstrate use of different data types and operators in Java.

Ques 5.

Write a java program to create an abstract class Student. Inherit UG_Student class and PG_Student class from the Student class. Define constructors and appropriate methods to display details of students. Make necessary assumptions.

Ques 6.

Write a java program to demonstrate use of Set and Map collection interfaces in problem solving.

Ques 7.

Write a program to demonstrate use of commit and rollback methods in JDBC programming.