DormX

DormX is a simple web application for buying and selling, specifically designed for students residing in the university dormitory area. The platform enables students to easily exchange their used or unnecessary items and inquire about products within a specified price range. In both buying and selling scenarios, users can submit competitive bids. Subsequently, the product owner can access the bidder's contact information to facilitate the completion of the transaction. Our primary focus is on efficiently and effectively implementing a Relational Database Management System (RDBMS) in a real-life scenario. We have established relationships between entities and normalized our database to cater to the requirements, ensuring its seamless functionality in various CRUD (Create, Read, Update, Delete) operations.

A Group Project by

• Ayub Ali Emon, Student ID: 202001051911, Email: aaemon98@163.com
• Phonesamay Phoutthavong, Student ID: 202001061406, Email: phphonesamay@gmail.com

Students of Software Engineering 2020(International Students)

Project Reviewed by

• Dr. QianQian Li, Email: sdnuliqian@163.com, Computer Science and Information Department

Shandong Univerity of Science and Technology

Project Tools

• Python 3.12.1
• Python's Flask as Backend
• Bootstrap 5 for frontend
• MySQL as Database

How to Setup?

1. Install the necessary packages from requirements.txt or install them manually one by one.

pip install -r requirements.txt

2. Set up your MySQL database.

   First, create the database, then import dormx_db.sql if you want only tables. But if you want tables along with sample data, import dormx_data.sql Or you can manually create the tables and modify them as you need. Here is the database relationship structure.

   

3. Modify your database information in src/__init__.py file. Change SECRET_KEY, DB_NAME, DB_USERNAME, DB_PASSWORD

4. Then you can run the run.py file to start the server. Debug mode is set to true, set to false if you don't need it.

Screenshots

1. Homepage

2. Login

4. Registration

5. Add Product

7. My Products

8. Update Product

9. Update Profile

10. Product Page

11. Product Page (Product Owner View)

12. Search