This Repository contains my database project. It has the commands input to create a database, create tables, edit tables as well as queries made. I also used primary key & foreign key mechanism for joining tables. Queried multiple tables. Prepared complex queries that answer analytical questions. Here i also demonstrate use of transactions and modify and delete data is sql Used join tables to sort out many to many relationships.
It uses the template provided by microverse.
This repository includes files with plain SQL that can be used to recreate a database:
- The schema.sql has been used to create all tables.
- The data.sql has been used to populate tables with sample data.
- The queries.sql has examples of queries that can be run on a newly created database. Important note: this file might include queries that make changes in the database (e.g., remove records). Use them responsibly!
👤 Mumenya Nyamu
- GitHub: @Nyame-Wolf
- Twitter: @mumenyam
- LinkedIn: LinkedIn
Contributions, issues, and feature requests are welcome!
Feel free to check the issues page.
Give a ⭐️ if you like this project!
- Hat tip to anyone whose code was used
- Inspiration
- etc
This project is MIT licensed.