Vet Animals Database

This project used the relational database to create the data structure for a vet clinic. Apart from the building data structure, here will be challenged with tasks that require SQL queries to answer specific questions.

Tasks todo:

• Create animals table.
• Query and update animals table.
• Query multiple tables.
• Add "join table" for visits.
• Database performance audit.
• Add database schema diagram.

Built using:

• SQL
• SQL Shell (psql)

Getting Started

Setup

• git clone https://github.com/elmar8287/vet_clinic.git
• cd ./vet_clinic

This repository includes SQL files for creation of a database:

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

Author

👤 Elmar Abdulkarimov

• GitHub: Elmar Abdulkarimov

🤝 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

• Hat tip to anyone whose code was used
• Inspiration
• etc

📝 License

This project is MIT licensed.