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!
[vet_clinic database] is a database which is having the data structure for a vet clinic and a complete database.
SQL
Database
- [Get info about animals]
- comming soon...
To get a local copy up and running, follow these steps.
In order to run this project you need:
- Laptop
- Internet
- Github
- Command Line
Clone this repository to your desired folder:
cd my-folder git clone https://github.com/Esmatullah12/vet-clinic-database.git
Install postgreSQL [https://www.postgresql.org/download/]
👤 Esmatullah Qadeemi
- GitHub: @githubhandle
- Twitter: @twitterhandle
- LinkedIn: LinkedIn
- [query and update animals table]
- [query multiple tables]
- [add "join table" for visits]
- [database performance audit]
- [add database schema diagram]
Contributions, issues, and feature requests are welcome!
Feel free to check the issues page.
If you like this project give me a ⭐️.
I would like to thank the Microverse Team.
This project is MIT licensed.