Advance-DataBases project, I am using PostgreSQL for developing the database for TopShop!
- The ER diagram.
- The DDL, which includes the creating the tables and generating fake data for the database.
- Writing some Queries that gonna serve my application.
- I wrote 4 more queries that gonna serve my application and I did optimization by using Indexing!
- I did the STORED PROCEDURES AND TRIGGERS FOR MY APPLICATION
- The web application, that is serving my database. Just open VisualStudio check the connection string again, and you can tried out.
**The point of the project was optimization. We have all of the business logic in the database, the back-end is free. **