Skip to content

Vet-Clinic is a database designed to store information about animals, including their names, birthdates, weights, neutering status, and number of escape attempts, as well as their owners and visits to the clinic, with features such as filtering by weight range and name search.

License

Notifications You must be signed in to change notification settings

codewanderlust/vet-clinic-db

Repository files navigation

📗 Table of Contents

vet-clinic

Vet-Clinic is a database designed to store information about animals, including their names, birthdates, weights, neutering status, and number of escape attempts, as well as their owners and visits to the clinic, with features such as filtering by weight range and name search.

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!

🛠 Built With

Tech Stack

Client
Server
Database

Key Features

  • A database that allows for querying and filtering based on it's features.

(back to top)

🚀 Live Demo (NOT AVAILABLE)

(back to top)

💻 Getting Started

Describe how a new developer could make use of your project.

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

Prerequisites

In order to run this project you need to have

  • Basic knowledge of SQL
  • Access to a PostgreSQL database
  • Knowledge of Git and GitHub
  • Have PostgreSQL client

Setup

Clone this repository to your desired folder:

  cd my-folder
  git clone https://github.com/RoyJumah/vet-clinic.git

(back to top)

👥 Authors

👤 Roy Jumah

(back to top)

🔭 Future Features

  • Add animal's owner table
  • Add clinic employees table
  • Add visits table

(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 you can give it a star

(back to top)

🙏 Acknowledgments

I would like to thank Microverse for providing me the resources that enabled me to finish this exercise

(back to top)

📝 License

This project is MIT licensed.

(back to top)

About

Vet-Clinic is a database designed to store information about animals, including their names, birthdates, weights, neutering status, and number of escape attempts, as well as their owners and visits to the clinic, with features such as filtering by weight range and name search.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 3

  •  
  •  
  •