GTBay - An online auction system

GTBay is a simple online auction site. The site supports two kinds of users: Regular Users and Administrative Users. Both kinds of users can list items they have for sale, search for items, bid on items, rate items, comment on items, and purchase items. Administrative users have the additional option of viewing two administrative reports.

Purpose of the Project

Analyze, specify, design, implement, document and demonstrate an information system application to support a new online auction system called GTBay. GTBay is similar to, but simpler than, existing online auction sites such as eBay. This system is implemented using a DBMS that supports standard SQL queries.

Delieverables (Directory Contents)

Phase I

1. Enhanced Entity Relationship (EER) Diagram
2. Information Flow Diagram
3. Task Decomposition Diagram
4. Abstract Code
5. A list of logical constraints that will be enforced.
6. Any assumptions made

Phase II

1. ER Diagram (optionally revised)
2. Information Flow Diagram (optionally revised)
3. Relational Schema Diagram
4. Create Table statements, including domain constraints, integrity constraints, primary keys, and foreign keys
5. Abstract Code incorporating SQL statements for each task

Phase III

1. Source code (documented) for your system
2. A functional application with embedded SQL statements that accesses your database

Implementation Details

Backend logic implemented using Java Spring Boot server. Frontend logic implemented using Angular4 Database used: SQLite