Skip to content

This is the first project in the fourth module of the Microverse program. It is a database for a vet clinic using PostgreSQL.

License

Notifications You must be signed in to change notification settings

mahammad-mostafa/vet-clinic

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

28 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

🏷️ 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

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:

📌 Carlos:

📌 Austin:

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