📗 Table of Contents

• 📖 About the Project
  • 🛠 Built With
    • Tech Stack
    • Key Features
• 💻 Getting Started
  • Prerequisites
  • Setup
  • Usage
• 👥 Authors
• 🔭 Future Features
• 🤝 Contributing
• ⭐️ Show your support
• 🙏 Acknowledgements
• 📝 License

📖 Vet Clinic Database

Vet Clinic Database is a relational database that stores the data of a vet clinic. It includes data about:

• Animals
• Owners
• Species
• Vets
• Visits
• Specializations

Schema Diagram

🛠 Built With

Tech Stack

Database

• PostgreSQL

Key Features

• Create, populate and query from several PostgreSQL tables

(back to top)

💻 Getting Started

To get a local copy up and running, follow these steps.

Prerequisites

In order to run this project you need:

• Install PostgreSQL

Setup

Clone this repository to your desired folder:

  cd my-folder
  git clone git@github.com:dicodiaz/vet-clinic-database.git

Usage

To run the project, execute the following commands:

  createdb vet_clinic
  psql vet_clinic

After executing these, you should be ready to:

• 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!

(back to top)

👥 Authors

👤 Dico Diaz Dussan

• GitHub: @dicodiaz
• LinkedIn: Dico Diaz Dussan
• Portfolio: portfolio.dicodiaz.com.co

🔭 Future Features

• Update and query from animals table
• Query from multiple tables
• Add "join table" for visits
• Database performance audit
• Add database schema diagram

(back to top)

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page.

(back to top)

⭐️ Show your support

Give a ⭐️ if you like this project!

(back to top)

🙏 Acknowledgments

A huge thanks to Microverse for their constant support.

(back to top)

📝 License

This project is MIT licensed.

(back to top)