Vet-clinic database

In this app, we used the relational database to create the data structure for a vet clinic. We created a complete database with the data of animals, animals' owners, clinic employees, and visits. We applied the database performance to optimize some slow queries in the vet-clinic database.

Diagram

Built with

• SQL
• Postgresql

Get Started

This repository includes files with plain SQL that can be used to recreate a database:

  git clone <URL> in your terminal

• Use schema.sql to create all tables.
• Use data.sql to populate tables with sample data.
• Check queries.sql to list of queries

Author

👤 Yannick-Noel AKA

• Location: Côte d'Ivoire
• GitHub: @codecaiine
• Twitter: @yannicknaka
• LinkedIn: LinkedIn

👤 Olipliche Mavoungou Paka

• GitHub: OLIPLICHE
• LinkedIn: olipliche
• Twitter: @olipliche1

🤝 Contributing

Contributions, issues, and feature requests are welcome! Feel free to check the issues page.

Show your support

Give a ⭐️ if you like this project!

Acknowledgments

• Thanks to Microverse
• Yannick AKA
• Olipiche M. Paka