Solution:- Here am making a complete function of Ecommerce store which has Customer, Seller and Admin. Customer - Can add and view products, add products to cart, checkout and get receipt with customer id. Seller - to be able to add products, view products and delete products. Admin - see all the products which has added…

In this application we have used different features of OOPs concept which are as follows: 1.  Inheritance: All the banks, SBI, PNB, ICICI are inheriting the base class RBI and its features. 2. Encapsulation: We have binded the data members and methods to the class and its sub types. 3. Polymorphism: In our code we…

1) Ans:-SELECT * FROM customer ORDER BY cust_city; 2) Ans:-ALTER TABLE product RENAME COLUMN NAME TO prod_name,RENAME COLUMN color TO prod_color,RENAME COLUMN size TO prod_size,RENAME COLUMN quantity_avil TO prod_quantity_avil,RENAME COLUMN price TO prod_price,RENAME COLUMN STATUS TO prod_status,RENAME COLUMN tags TO prod_tags;SELECT…

QUESTIONS:- Ans:- 1db.products.aggregate([{$group:{_id:'product_cost', avg:{$avg:'$product_cost'}}}]) Ans:- 2db.customers.aggregate([{$sort: {purchase_amount:-1}]) Ans:- 3db.order.aggregate([{$group:{_id:'Total_cost', sum:{$sum:'$product_cost'}}}]) Ans:- 4db.customers.aggregate([{$group:{_id:'customer_city', {$match:{customer_city}}}])…

Solution:-  Here am making Bank_Application_Maven project. in this project have Accounts, Cards, Config, Insurances and Loans spring boot application. each appliction have own cutomers data details. I am adding appliction in Github repository and creating Docker image in dockerhub all application are woking n fetch…