Relational Schema
EER diagram:
• Steps to import database from the zip folder.
-
Open MySQL workbench in your device.
-
Add a connection or select an existing one.
-
Make sure that you select user as “root” , hostname as “127.0.0.1” and port as 3306 for a new connection.
-
Enter your password if there is an existing connection.
-
Create a database in your workbench named “projectsystem” and select it.
-
Select Server -> Data-Import, once you open your workbench.
-
Browse for the folder containing .SQL files
-
It will show like this upon clicking.
-
Click on start import here or click import progress above and then click start import.
-
Your data is imported, once verify by running the queries on database.
-
Now, open the SQL.PY file in your compiler which is able to run python programs.
➢ Following are the steps involved into running the program: -
-
First you have to enter the username and password of the database so that you can connect the program to database.
-
User name = root
-
Password = ****** (whatever you set)
-
After, running the program it will ask you to enter username and respective password.
Enter any of the above for the successful authorization.
Finally you will get options, choose as per your choice and you can run queries directly using program.