E-Commerce-Application

Overview

1. Introduction
2. Entity Relationship Diagram
3. Schema DDL
4. Sample Queries
   • 4.1 Revenue Report
   • 4.2 Top Selling Report
   • 4.3 Customers Orders > $500
   • 4.4 Text Searching
   • 4.5 Recommend Products
5. Indexing
6. Challenges Faced
   • 6.1 Handling Recursive Categories
   • 6.2 High Read Operations - Denormalization
   • 6.3 Null Values and Union Operation

1. Introduction

This section provides an introduction to the E-Commerce Application.

2. Entity Relationship Diagram

Here is the entity relationship diagram for the database...

3. Schema DDL

The following script creates the database schema...

4. Sample Queries

4.1 Revenue Report

This query generates a daily revenue report...

4.2 Top Selling Report

This query lists the top-selling products...

4.3 Customers Orders > $500

This query retrieves customers who have placed orders over $500...

4.4 Text Searching

This query demonstrates how to search for text in product names or descriptions...

4.5 Recommend Products

This query suggests popular products...

5. Indexing

Details on the indexing strategy...

6. Challenges Faced

6.1 Handling Recursive Categories

Discussion on handling recursive categories...

6.2 High Read Operations - Denormalization

Approaches for optimizing high read operations...

6.3 Null Values and Union Operation

How to handle null values during union operations...