Database Documentation

Overview

We have chosen Microsoft SQL Server as our Database Management System (DBMS) due to its seamless integration with the entire Azure Microsoft environment, allowing for better scalability, security, and cloud-based operations.

Main Tables

Below is a list of the main tables in our database:

1. Users: Stores all user-related information such as names, email addresses, and credentials.
2. Products: Contains details about the products available in the store, including names, categories, descriptions, and stock levels.
3. Price: Stores the price history of each product in order to maintain consistency on the purchases when the price is updated.
4. Carts: Manages shopping cart data for users, including the items added to the cart before checkout.
5. CartToProduct: Stores the single items placed on the cart and its amount.
6. Review: Stores comments and reviews that registered users make on the products
7. Favorites: Stores the Wishlist of the users.

Entity-Relationship Diagram (ERD)

The entity-relationship diagram below illustrates the relationships between the tables in our database: