muneeb3123/vet-clinic

Under construction! In this project, I will use a relational database to create the initial data structure for a vet clinic. I will create a table to store animals' information, insert some data into it, and query it.

Paws and Claws Clinic

📗 Table of Contents

• 📗 Table of Contents
• 📖 Paws and Claws Clinic
  • 🛠 Built With
    • Tech Stack
    • Key Features
  • 💻 Getting Started
    • Prerequisites
    • Setup
    • Install
    • Usage
    • Run tests
  • 👥 Authors
  • 🔭 Future Features
  • 🤝 Contributing
  • ⭐️ Show your support
  • 🙏 Acknowledgments
  • ❓ FAQ
  • 📝 License

📖 Paws and Claws Clinic

The Paws and Claws Vet Clinic Database is a PostgreSQL system designed for managing essential information about pet patients in a veterinary clinic. The database stores and organizes data such as pet names, birth dates, weight, neutering status, and escape attempts, providing the clinic staff with a convenient way to track and access this crucial information. It also offers querying capabilities, which help in analysis, reporting, and decision-making, as a result enhancing the efficiency of the clinic's operations and the quality of care provided to the pets.

🛠 Built With

Tech Stack

Database

• PostgreSQL

Query Language

• SQL

Key Features

• Robust Data Management: The database offers a systematic way to manage information about the clinic's animal patients, making data retrieval and tracking more efficient.
• Comprehensive Querying Capabilities: SQL is used to interact with the database, providing powerful querying options for extracting and manipulating data according to various needs.
• Scalability: PostgreSQL, as an open-source relational database, offers high scalability, making the database capable of handling an increasing amount of data as the clinic grows.
• Data Integrity: PostgreSQL provides strong data consistency and supports ACID (Atomicity, Consistency, Isolation, Durability) properties, ensuring the reliability and integrity of data.
• Flexibility: The database schema can be easily adjusted to accommodate changing requirements, demonstrating the system's adaptability.

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

• PostgreSQL installed on your machine. You can download it from the official website.

Setup

Clone this repository to your desired folder:

  cd your-folder
  git clone https://github.com/Alejandroq12/vet-clinic.git

Install

Navigate into your project directory and set up your database:

  cd your-project
  psql -U postgres -f schema.sql

Usage

To interact with the database, open PostgreSQL and connect to the database:

Connect to database

  psql -U postgres -d vet_clinic

Run tests

To run tests, run the following command (functionality will be added in the future):

  // command to run tests will be available in the future.

(back to top)

👥 Authors

👤 Julio Quezada

• GitHub: Alejandroq12
• Twitter: @JulioAle54
• LinkedIn: Julio Quezada

(back to top)

🔭 Future Features

• Project 1: create animals table.
• [] Project 2: query and update animals table.
• [] Project 3: query multiple tables.
• [] Project 4: add "join table" for visits.
• [] Project 5: database performance audit.
• [] Exercise: 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

If you like this project please give a star. Thanks in advance.

(back to top)

🙏 Acknowledgments

I would like to thank all of my colleagues who inspire to do my best everyday.

(back to top)

❓ FAQ

• Did you create this project from scratch?

  • Yes, and for that reason I learned a lot.

(back to top)

📝 License

This project is MIT licensed.

(back to top)