Please watch the video to help you with site navigation.
Learnings include but not limited to
Design and create a database to solve business problems
Write SQL commands to retrieve data from the database with criteria and conditions
Write SQL commands to insert, update and delete data in a database with criteria and conditions
Create Views and utilize them for reporting purposes
Understand Stored Procedures, Functions and Triggers
Understand the concept of CRM system
The current design allows applying promo code on the entire order. However, the solution is scalable to handle any new use cases as required.
Current design does not include order fulfillment use cases. However, Orders table contains references to shipping and tracking information
The project scope is limited to DBMS design.