This repository documents the databse design and implementation for an omline auction site GTbay.
The first part of the project will start from analyzing the business requirement document and conceptualizing business processes involved in online bidding, this is modelled using the Extended Entity Relationship model.
The second part of the project is to map EER model to entity relationship model for practical deployment, a database schema was proposed and fine tuned. The overall information flow logic is shown in IFD:
The third part of the project is to build the website database and website UI using MySQL and PHP. An effor has been made to return the desired tables directly from database using sophsticated nested queries, rather than doing any hard coded in PHP. The website functionalities includes account gmanagement, auction/bidding mechanisms, comment/review/rating system, item/account summary and statistics
