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

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

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

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

📌 Mahammad:

• GitHub
• Twitter
• LinkedIn

📌 Carlos:

• GitHub

📌 Austin:

• GitHub

back to top

Some additional features I may implement in the project:

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

back to top

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

Like this project? Show your support by starring!

back to top

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

back to top

This project is MIT licensed.

back to top