A website to design databases:
Topics to research:
what is spars in sql?
normalize data :
to install mysql driver:
pip install mysqlclient
if you seen any errors in debian or fedora, Install this packages:
sudo apt install libmysqlclient-dev default-libmysqlclient-dev
to run mysql
mysql -u root -p
Remember to create a user for each database. even if you're only on local: