CS-4400-Atlanta-Zoo-Database

In this project, we constructed a relational database using python 3.5, qt designer and mysql. The mysql servers is a remote server setup by the Georgia Institute of Technology. Thus, after this Fall 2018 semester the database might not be able to be accessed anymore.

Project Purpose

Analyze, specify, design, implement, document and demonstrate an online system. You are required to use the classical methodology for database development. The system will be implemented using a relational DBMS that supports standard SQL queries. The TAs will provide you with information about how to access a college-managed MySQL server in order to implement your database and the application. We will also provide you with a list of approved technologies for your implementation, and the professor must approve the use of any other alternative technologies. Under no circumstances can you use a tool that automatically generates SQL or automatically maps programming objects into the database. You also cannot use any other software like Access or SQLite. Ask the professors or TAs if you have questions about which tools/languages/software are allowed.

EER Diagram

IFD Diagram

Relational Schema Diagram

Setting up the enviroment for QTDesigner

1. Download QT Designer

Setting up the environment for Anaconda

1. Download Anaconda
2. Create Virtual Environment

• For Mac, Go to Anaconda Navigator and create a python 3.5 virtual environment. Open the py35 virtual environment from Anaconda Navigator.

• For Windows, open anaconda prompt.

  • i. Type conda create -n py35 python=3.5 anaconda

  • ii. To activate the environment, type activate py35

Installing pyqt to the environment

1. Open your python 3.5 virtual environment.
2. Type conda install -c anaconda pyqt
3. Tutorial webpage

• PyQt Documentation

Installing packages for accessing remote MySQL server using python

1. Open your python 3.5 virtual environment.
2. Install mysql-connector-python. Type pip install mysql-connector-python==8.0.11.

MySQL Python Connector Tutorials

Please install the mysql-connector-python in order to run the API to connect to MySQL database. pip install mysql-connector-python==8.0.11

1. Pynative
2. W3School

References:

• GeekforGeek
• MySQL Connector/Python Developer Guide
• TutorialPoints
• Installation

How to use the tools?

1. Open the QTDesigner. Complete your design. There are some tutorials available in the youtube. After completing your design you can Preview your ui through From -> Preview or Ctrl + R. Next, save your .ui file in the folder that you stores your github code.

2. Open your python 3.5 environment. Go to the directory that you have saved your .ui file. Then type pyuic5 -x <nameOfTheUIFile> -o <nameOfTheUIFile>. For example. pyuic5 -x loginPage.ui -o loginPage.py. The python file will be generated in the same folder as your .ui file.

Access the Remote MySQL off campus

1. Download Cisco or other VPN softwares that is able to connect to the campus ip address.
2. Established your VPN connection
3. python connect.py