wonderakwei / northwind-database-design-with-mysql-dbeaver-and-docker Goto Github PK

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:

1. README.md: Project documentation.
2. .env: Environment configuration file.
3. docker-compose.yml: Docker Compose configuration for setting up the MySQL database and dbeaver container.
4. Northwind-ERD.png: Entity-Relationship Diagram (ERD) representing the structure of the Northwind Database.
5. database.dbml: Database Markup Language (DBML) file describing the schema of the Northwind Database.
6. dbdiagram.io.sql: SQL script generated from dbdiagram.io, providing a visual representation of the database schema.
7. insert.sql: SQL script containing sample data insertion queries for populating the database tables.
8. sample_queries.sql: SQL script containing sample queries for data retrieval and manipulation tasks.
9. setup.md: Setup instructions for configuring the MySQL database, DBeaver, and Docker.
10. tables.sql: SQL script for creating the database tables.
11. 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.