/vetclinic-db

sample database for an animal clinic

Primary LanguagePLpgSQLMIT LicenseMIT

📗 Table of Contents

📖 vet clinic db

vet clinic db is a repository showing steps on how to create an animal clinic and query data from the database

🛠 Built With

Tech Stack

Database

Key Features

In this repository you can query:

  • How many animals there are.
  • How many animals have never tried to escape.
  • The average weight of animals.
  • Find Who escapes the most, neutered or not neutered animals
  • The minimum and maximum weight of each type of animal.
  • The average number of escape attempts per animal type of those born between 1990 and 2000.

(back to top)

💻 Getting Started

This project was written on windows platform and used PostgreSQL version 16.

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

Prerequisites

In order to run this project you need:

  • Postgresql installed and configured properly. Guide

  • Basic understanding of structured query language(SQL)

Setup

Clone this repository to your desired folder:

Example commands:

  cd my-folder
  git clone https://github.com/NoelLincoln/vetclinic-db.git

Usage

Using SQL shell(psql) or pgAdmin 4:

  • Create the database and animals table using the commands from schema.sql
  • Insert sample data from data.sql
  • Query inserted data using sample queries in 'queries.sql'

👥 Authors

👤 Noel Bryant

(back to top)

🔭 Future Features

  • Query percentage of animals under 10kg
  • Query average weight for animals under 4 years

(back to top)

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page.

(back to top)

⭐️ Show your support

If you like this project feel free to Buy Me A Coffee

(back to top)

🙏 Acknowledgments

I would like to thank the entire Microverse Community

(back to top)

📝 License

This project is MIT licensed.

(back to top)