Northwind Database Design with MySQL, DBeaver, and Docker
Project Overview: This project focuses on leveraging MySQL, DBeaver, and Docker to explore database management principles using the Northwind sample database.
Project Files:
- README.md: Project documentation.
- .env: Environment configuration file.
- docker-compose.yml: Docker Compose configuration for setting up the MySQL database and dbeaver container.
- Northwind-ERD.png: Entity-Relationship Diagram (ERD) representing the structure of the Northwind Database.
- database.dbml: Database Markup Language (DBML) file describing the schema of the Northwind Database.
- dbdiagram.io.sql: SQL script generated from dbdiagram.io, providing a visual representation of the database schema.
- insert.sql: SQL script containing sample data insertion queries for populating the database tables.
- sample_queries.sql: SQL script containing sample queries for data retrieval and manipulation tasks.
- setup.md: Setup instructions for configuring the MySQL database, DBeaver, and Docker.
- tables.sql: SQL script for creating the database tables.
- Northwind-data: Folder containing additional data related to the Northwind Database.
Tools Used:
- MySQL: The database management system used for storing and managing the Northwind Database.
- DBeaver: A universal database tool utilized for interacting with the MySQL database.
- Docker: Containerization platform used for deploying and managing the MySQL database container.
- dbdocs.io: Online documentation platform used for documenting the Northwind Database schema.
- dbdiagram.io: Online diagramming tool used for visualizing and designing the database schema.
Additional Resources:
For more detailed documentation on the Northwind Database schema, you can visit dbdocs.io.