/vet_clinic

A vet clinic database using psql.

Primary LanguagePLpgSQL

The Vet Clinic Database

This project is about a vet clinic relational database built using PostgreSQL. It is made up of a series of tables which include

  • Animals table
  • Animal's owners
  • Clinic employees
  • Visits

schema_diagram

Built With

  • Major languages: SQL and PostgreSQL
  • Technologies used: Git, Github and Gitflow

Getting Started

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!

Prerequisites

  • install PosgreSQL Database

Authors

👤 Yussuf O.B

👤 Mirwais Farahi

🤝 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 Microverse's code reviewers and to everyone who reviewed my project and made suggestions.

Acknowledgments

📝 License

This project is MIT licensed.