This project uses a relational database to create the initial data structure for a vet clinic. This includes a table to store animals' information, insert some data into it, and query it.
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!
- PostgreSQL
- DrawSQL
👤 Choice Osobor
- GitHub: @techEmprez
- Twitter: @techEmprez
- LinkedIn: Choice Osobor
👤 Mahmoud Rizk
- GitHub: @Elerqsousy
- LinkedIn: Mahmoud (Riz) El Erqsousy
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.
- Create a table named vets with the following columns: id: integer (set it as autoincremented PRIMARY KEY) name: string age: integer date_of_graduation: date
- Inserted data for vets
- Inserted data for visits
- Inserted data for specialization
- Write queries to answer the following: Who was the last animal seen by William Tatcher? How many different animals did Stephanie Mendez see? List all vets and their specialties, including vets with no specialties. List all animals that visited Stephanie Mendez between April 1st and August 30th, 2020. What animal has the most visits to vets? Who was Maisy Smith's first visit? Details for most recent visit: animal information, vet information, and date of visit. How many visits were with a vet that did not specialize in that animal's species? What specialty should Maisy Smith consider getting? Look for the species she gets the most.