/OnlineShopDB

Project for a database course

Primary LanguagePython

Online Shop Database Project

This project contains the files and scripts for an online shop database. The project includes table definitions, sample queries, and scripts to generate fake data.

Directory Structure

  • Code/: Contains the scripts for generating data and creating the database.
    • Faker.py: Generates fake data using the Faker library.
    • OnlineShop.sql: SQL script to create the tables.
    • Queries.py: Contains 10 sample queries.
  • ER/: Contains the ER diagram of the database.
    • ER_Diagram.png: PNG file of the ER diagram.
  • Generated_Data/: Contains the generated data.
    • Data.sql: SQL script with the generated data.

How to Use

  1. Clone the Repository: 
    git clone https://github.com/yourusername/OnlineShopDatabaseProject.git
cd OnlineShopDatabaseProject