Git Product home page Git Product logo

ecommerce-database's Introduction

ecommerce-database

this is database design and queries for ecommerce .

prerequisites:

  • postgresql.
  • docker or any other sql client.

Topics:

  • DDL
  • DML
  • Erd diagram
  • Stored Procedures.
  • Triggers.
  • Denormalization
  • Indexing
  • Concurrency control
  • Locking
  • Isolation levels
  • Query optimization techniques
  • views
  • explain analyze
  • tasks / challenges

database erd:

image

Project Structure:

├── Query Optimization Techniques.
│   ├── query_optimization.sql
│   ├── QUERY_OPTIMIZATION_TECHNIQUES.md
│
├── Denormalization
│   ├── denormalization.sql
│   ├── DENORMALIZATION.md
│
├── Indexing
│   ├── create_indexes.sql
│   ├── show_indexes_info.sql
│   ├── INDEXING.md
│
├── Concurrency Control
│   ├── concurrency_control.sql
│   ├── CONCURENCY_CONTROL.md
│
├── Locking
│   ├── locking.sql
│   ├── LOCKING.md
│
├── Isolation Levels
│   ├── isolation_levels.sql
│   ├── ISOLATION_LEVELS.md
│
├── DDL
│   ├── create_table.sql
│   ├── create_procedure.sql
│   ├── DDL.md
│
├── DML
│   ├── dml.sql
│   ├── DML.md
│
├── explain_analyze
│   ├── explain_analyze.sql
│   ├── EXPLAIN_ANALYZE.md
│
├── ERD
│   ├── ecommerce.png
│
├── tasks
│   ├── task1.sql
│   ├── task2.sql
│   ├── task3.sql
│   ├── task4.sql
│   ├── TASKS.md
├── README.md

Database Design:

  • Database Name: ecommerce
  • Tables:
    • users
    • products
    • orders
    • order_items
    • categories
    • reviews
    • product_reviews
    • cart
    • cart_items
    • addresses

Read more Details in each topic:

ecommerce-database's People

Contributors

osama-mahmoud-h avatar

Stargazers

Ahmed Abdlehafez  avatar Neven Ahmed avatar Khalid ElSayed avatar Shehab Waleed avatar  avatar  avatar Khalid Rashad avatar Houdaifa Bouamine avatar Ahmed maher avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.