/vet-clinic-SQL

create a veterinary clinic database with PostgreSQL

Veterinary Clinic Database /SQL

I have created a relational database from a veterinary clinic. All the information was inserted into 'animals' table classified by:

  • id
  • name
  • date of birth
  • escape_attempts
  • neutered
  • weight_Kg

I have used PostgreSQL shell and pgAdmin4 to get a graphical view to sort and manage every data.

Tools

PostgreSQL & pgAdmin 4

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!

Authors

👤 ANDY MENUTTI

🤝 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.