I have attached the file

This is a java project that applies principles of object oriented programming in creating the different functionalities of a common e-commerce store.

This is a java project that applies principles of object-oriented programming in creating the different functionalities of a common Bank Application. The Bank Management system has main user is end customer for open an account and enter the customer details. Different functions for each such as Bank Balance, Deposit Balance…

Task-1: ER diagram should be uploaded in draw.io file.   Task-2:  CREATE DATABASE E_commerce;USE E_commerce; CREATE TABLE Register(RegisterId INT,NAME CHAR(20),PhoneNumber INT,city CHAR(10),country CHAR(10),pincoode INT,Email VARCHAR(50),N0n_premium CHAR(5),premium CHAR(5), PRIMARY KEY (premium, N0n_premium,Email,PhoneNumber,RegisterId,city,country,pincoode));…

CREATE DATABASE E_commerce;USE E_commerce; CREATE TABLE Register(RegisterId INT,NAME CHAR(20),PhoneNumber INT,city CHAR(10),country CHAR(10),pincoode INT,Email VARCHAR(50),N0n_premium CHAR(5),premium CHAR(5), PRIMARY KEY (premium, N0n_premium,Email,PhoneNumber,RegisterId,city,country,pincoode)); SELECT * FROM Register;INSERT…

use ecommerce; db.customer.insertMany([{_id:1,"name":"Ganesh","age":23,"city":"amalapuram","type":"premium","cust_id":501},{_id:2,"name":"Bala","age":22,"city":"Vizag","type":"premium","cust_id":502},{_id:3,"name":"Manotej","age":20,"city":"Hyderabad","type":"Non-premium","cust_id":503}]); db.products.insertMany([{Men:["shirts","Jeans","Trousers"],Brand:"Puma"},{Women:["Kurtas","Dresses","Jeans"],Brand:"Gucci"},{Kids:["Infants","Toys","Sets"],Brand:"Roadster"}]);…