Auctionbase database
Techniques used: SQL, Python, web.py, Jinja2, JSON
- Design database relational schema for the ebay data that conforms with the Fourth Normal Form
- Wrote a python parser that transforms the JSON data into SQLite load files that are consistent with the relational schema.
- Added constraints and triggers to the schema, including constraints for users, items, bidding and time.
- Designed a set of functionalities (queries and updates) for the system and created a simple web interface.
- Automated the process
- Design database relational schema for the ebay data that conforms with the Fourth Normal Form
- Wrote a python parser that transforms the JSON data into SQLite load files that are consistent with the relational schema.
- Added constraints and triggers to the schema, including constraints for users, items, bidding and time.
- Designed a set of functionalities (queries and updates) for the system and created a simple web interface.
- Automated the process