/Vet-Clinic_Database

In the upcoming projects, you will use a relational database to create the data structure for a vet clinic. You will start with one table, and step by step, you will create a complete database with data about: animals ,animals' owners, clinic employees, visits.

Primary LanguagePLpgSQLMIT LicenseMIT

curriculum-databases-projects-template

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!

Vet Clinic DB

📗 Table of Contents

🚀 Vet Clinic Database

In this project've created my first database for a veterinary clinic using PosgreSQL. With streamlined data organization and seamless integration, this database enables efficient tracking of medical records, appointments, treatments, and client information.

Data Base Diagram

logo

🛠 Built With

  • PostgreSQL

Tech Stack

Server

Key Features

  • Robust data management
  • Reporting and analytics

👥 Authors

👤 Juan Diego Guerra (JD)

(back to top)

🔭 Future Features

  • Appointment scheduling
  • Comprehensive medical records

(back to top)

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page.

(back to top)

⭐️ Show your support

Thanks for checking out this project! Please feel free to reach out with any questions or feedback, as your input is greatly appreciated. And if you enjoyed the project don't forget to leave a star on the repo ⭐️.

(back to top)

🙏 Acknowledgments

I would like to thanks Microverse corporation for the database template.

(back to top)

📝 License

This project is MIT licensed.

(back to top)