🏷️ Vet Clinic

This is the first project of the fourth module in the Microverse program.
Check the below contents for further details about this project.

📗 Contents

• Description
• Instructions
• Authors
• Future
• Contributions
• Support
• Acknowledgements
• License

📖 Description

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!

📌 Tech Stack:

• Database built with PostgreSQL
• Queries uses SQL

📌 Key Features:

• Table for animals information which include (name / birth date / escape attempts / weight / neutering)
• Each animal is linked with the owners & species tables through foreign keys (owner_id / species_id)
• Table for animal owners information which include (name / age)
• Table for animal species information which include (name)
• Table for vets information which include (name / age / graduation)
• Table for specializations information which is linked with the vets & species tables through foreign keys (vet_id / species_id)
• Table for visits information which include (date)
• Each visit is linked with the vets & species tables through foreign keys (animal_id / vet_id)

back to top

🛠️ Instructions

You can easily download or fork this repository and work on it immadiately!

📌 Prerequisites:

• PostgreSQL or any other SQL database

📌 Installation:

• Create a new database called vet_clinic
• Run queries in schema.sql for creating all tables
• Use data.sql to populate tables with sample data

📌 Development:

• Check queries.sql for examples of queries that can be run on a newly created database

back to top

👥 Authors

📌 Mahammad:

• GitHub
• Twitter
• LinkedIn

📌 Carlos:

• GitHub

📌 Austin:

• GitHub

back to top

🔭 Future

Some additional features I may implement in the project:

• Using Binary data types in tables
• Implement stored procedures like SQL Trigger

back to top

🤝🏻 Contributions

Wish to contribute to this project?
Contributions, issues, and feature requests are more than welcome!
Feel free to check the issues page too.

back to top

⭐️ Support

Like this project? Show your support by starring!

back to top

🙏🏻 Acknowledgements

I thank everyone at Microverse for guiding me through this project.

back to top

📝 License

This project is MIT licensed.

back to top