Paws and Claws Clinic

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

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.

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

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

In order to run this project you need:

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

Clone this repository to your desired folder:

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

Navigate into your project directory and set up your database:

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

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

Connect to database

  psql -U postgres -d vet_clinic

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)

👤 Julio Quezada

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

(back to top)

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

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page.

(back to top)

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

(back to top)

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

(back to top)

• Did you create this project from scratch?

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

(back to top)

This project is MIT licensed.

(back to top)