Caren-Koroeny/vet--Clinic

The project was to create a relational database for a veterinary clinic to manage animal data. A table was designed to store animal information, data was added, and SQL queries were used to extract information from the table. The aim was to improve the clinic's ability to organize and access animal data.

vet--Clinic

📗 Table of Contents

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

📖 vet clinic

vet clinic is a relational database designed to manage and store information related to the operation of a veterinary clinic. User can use the project query to create, read, update and delete specific data from the database.

Database Schema Diagram

🛠 Built With

Tech Stack

Client

• SQL

Database

• PostgreSQL

Key Features

• create animals table
• Add records to animal table
• query animal table
• aggregate operations
• use of transactions

(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:

1. git use the following link to setup git if you dont have it already installed on your computer

(install git)

2. PostgreSQL use the following link to setup PostgreSQL if you dont have it already installed on your computer

(install PostgreSQL)

Setup

Clone this repository to your desired folder:

  cd my-folder
  git clone git@github.com:Caren-Koroeny/vet--Clinic.git

Usage

This repository includes files with plain SQL that can be used to run the project.

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

(back to top)

👥 Authors

👤 CarenSiya

• GitHub: @carensiya
• Twitter: @carensiya
• LinkedIn: @carensiya

(back to top)

🔭 Future Features

• Add more advanced queries
• Add database performance audit

(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, please don't forget to follow me and give it a star.

(back to top)

🙏 Acknowledgments

I would like to acknowledge and thank Microverse for providing the template for this repository.

(back to top)

📝 License

This project is MIT licensed.

(back to top)