Introducing a bidding feature to the existing Facebook marketplace.
- Rohith Kumar Reddy Kota
- Nikhil Godalla
- Shreya Jayesh Thakur
- Siddhartha Ravilla
- Rehan Khan
P1. Topic & Objectives: Introduction of Bidding System on Facebook Marketplace
P2. Database Design, Initial ERD
P4. Implementation - Database Objects With Screenshots
See theimplementation/database` folder for sql scripts
Object Type | Quantity or Comments | Yes/No |
---|---|---|
Tables | 17 | Yes |
Views | 6 | Yes |
Table Level Check Constraint | 6 | Yes |
Computed Column based on UDF | 2 | Yes |
Non-Clustered Indexes | 14 | Yes |
Stored Procedures | 6 | Yes |
User Defined Functions (UDF) | 3 | Yes |
DML Triggers | 7 | Yes |
Column Data Encryption | 2 | Yes |
BI Data Visualization | Yes | Yes |
GUI for CRUD Operations (optional) | No | No |
Other |
Note: See P4. Implementation for more details and results.