The image file named 'Data' in this repository contains the project data. It was saved as a PDF from GiraffeAcademy and then converted to an image for easy usage.
In this project, I created a database schema from start to finish using MySQL Relational Database Management System. I created the database tables with their columns, and mapped the primary and foreign keys for each table. There are columns that are both primary and foreign keys, these columns were mapped appropriately. I then inserted row values into each table as shown in the data source.
The work process was well documented using appropriate comments for easy understanding. You can take a look at the SQL file named 'Comp Database' on this repository to see the work done. The database created is adequate for further SQL analysis, and can also serve as a model for creating other databases.
Here are some of the SQL codes used in this project.
This project was built by Chidiebere David Ogbonna.
Here are his details:
| Detail | Link |
|---|---|
| eberedavid326@gmail.com | |
| chidieberedavidogbonna | |
| GitHub | iameberedavid |
| Medium | eberedavid |
| iameberedavid |
I went further to explain the work process of this project in an article published on Medium. Click on this link to find the article: Database Schema Creation Using SQL
This project is licensed under the MIT License. See the LICENSE file for details.
Thanks for taking the time to go through this Readme.md file and reviewing this project. Please feel free to browse through other repositories on this GitHub account for other projects on SQL, Excel, Power BI, Tableau, Python, R, and Machine Learning.
Feel free to send your reviews, suggestions, questions and collaboration requests to eberedavid326@gmail.com