This project is a comprehensive database management system (DBMS) designed for college data management. It provides a web-based interface for managing professors, departments, courses, and students.
- Flask: A Python web framework used for developing the application.
- MySQL: A traditional relational database management system used for data storage and retrieval.
- YugabyteDB: A scalable and distributed cloud database employed for improved performance and reliability.
- AWS EC2: An Amazon Web Services (AWS) Elastic Compute Cloud (EC2) Linux instance utilized for hosting the project.
- Gunicorn: A Python WSGI HTTP server used for efficient web serving.
- Nginx: A high-performance web server and reverse proxy server employed for routing and load balancing.
- User-friendly web interface for managing professors, departments, courses, and students.
- Secure authentication and authorization mechanisms to ensure data privacy.
- Seamless integration with MySQL and YugabyteDB for efficient data storage and retrieval.
- Scalable architecture to handle increasing data and user demands.
- High availability and reliability provided by AWS EC2 hosting.
- Clone the repository.
- Install the required python dependencies listed in the
requirements.txt
file. - Configure the database connections and credentials in every python file.
- First run 'db_schema.py' to create database and its schema.
- Next run 'db_data.py' to insert some data to the tables.
- Start the flask application server using 'python app.py' or 'flask run'.
Contributions to this project are welcome! If you find any issues or have suggestions for improvements, feel free to open an issue or submit a pull request.