/Vet-Clinic-DB

Modeling Database for a Vet Clinic. Built with Postgresql

Primary LanguagePLpgSQL

Vet-Clinic-Database

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!

📗 Table of Contents

📖 [Vet Clinic Database]

This is a database for a vet clinic. It contains tables for animals, owners, vets, and visits. It also contains a join table for visits and vets.

[Vet Clinic Database] is a Postgresql project to model data for a vet clinic

🛠 Built With

Tech Stack

Database

Key Features

  • Create tables for database
  • Populate tables with sample data
  • Run relevant queries to fetch data from database

💻 Getting Started

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

Setup

Clone this repository to your desired folder:

Example commands:

  cd my-folder
  git clone git@github.com:MosDevx/Vet-Clinic-DB.git

Install

Install this project with:

Example command:

  cd my-project
  psql -d vetclinic
  vetclinic=# \i '\path\to\folder\schema.sql';
  vetclinic=# \i '\path\to\folder\data.sql';

(back to top)

👥 Authors

👤 Moses Wamae

(back to top)

🤝 Future Features

  • Add Join queries
  • Add multiple tables

🤝 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 leave a star!

(back to top)

🙏 Acknowledgments

I would like to thank... God.Always!!

(back to top)

📝 License

This project is MIT license

(back to top)