Project 1

TASK NO 1 : Create new schema as alumni. -- Go to MYSQL workbench -> Right click on the navigator -> Click on create new schema -> Name the new schema as alumni. TASK NO 2 : Import all .csv files into MySQL. -- Right click on Tables -> Click on Table Data Import Wizard -> Select file to import -> Import…

TASK NO 1 : Create new schema as ecommerce Open SQL workbench -> Right Click on the navigator -> Create a new schema called "ecommerce".   TASK NO 2 : Import .csv file users_data into MySQL Right click on ecommerce schema -> Table Data import Wizard -> Give path of the file -> Next -> choose…

EDA on Vehicle Insurance Customer Data A company has customer data that contains 8 columns of customer details and another table having name customer_policy data contains the policy details of the customer. The company intends to offer some discount in premium for certain customers. To do that they ask their Data scientist…

Question no 1 A : This project uses the skills learnt from week 1 to week 6. The aim of this project is to create an English Dictionary app that returns definitions of English words. When the application is started, it displays a menu as follows: Main Menu Add a new word Find the meaning Update a word Exit Enter Choice:…