In this project, We have used a relational database to create the initial data structure for a vet clinic. We have created a table to store animals' information, insert some data into it, and query it. Moreover, we have used the query optimization techniques to improve performance of the queries.
This repository includes files with plain SQL that can be used to recreate a database:
- Use schema.sql to create all tables.
- Use data.sql to populate tables with sample data.
- Check queries.sql for 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!
👤 Haji Bamsi
👤 Toussaint Saraza
- GitHub: @sarazaToussaint
- Twitter: @Toussaint Saraz1
- 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.