ridwanullahi-code / vet_clinic_database

The Veterinary PostgreSQL Database Management System is a system designed to manage the data and records of a veterinary clinic. The system is designed to store and manage data related to animals, their owners, appointments, treatments, and medical histories

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

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

📖 Veterinary PostgreSQL Database

The Veterinary PostgreSQL Database Management System is a system designed to manage the data and records of a veterinary clinic. The system is designed to store and manage data related to animals, their owners, appointments, treatments, and medical histories.

🛠 Built With

Tech Stack

Database

• Postgresql

Key Features

Features:

• Animal Records: A database of animal records that stores information such as the animal's name, breed, age, gender, and owner information.
• Owner Records: A database of owner records that stores information such as the owner's name, address, phone number, and email address.
• Appointment Scheduling: A calendar that allows clinic staff to schedule appointments for animals and track upcoming appointments.
• Treatment and Medical History Records: A database of treatment and medical history records that stores information such as the treatment type, date, and cost.

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

• Basic Knowledge of DBMS (Database Management System)
• Basic Knowledge of Relational Database
• Basic Knowledge of SQL Command
• Basic Knowledge of Postgresql Command

Setup

Clone this repository to your desired folder:

  git clone https://github.com/Ridwanullahi-code/vet_clinic_database.git

or

  git clone [email protected]:Ridwanullahi-code/vet_clinic_database.git

Install

Install Relational Database Called Postgresql

• Postgresql Installation on Window
• Postgresql Installation on MacOS
• Postgresql Installation on Linux

(back to top)

👥 Authors

👤 Ajayi Ridwan

• GitHub: @Ridwanullahi-code
• Twitter: @Ridwanullahi22
• LinkedIn: LinkedIn

👤 Iptisam Mukadam

• GitHub: @iptisam

• Twitter: @twitter

• LinkedIn: @linkedin

(back to top)

🔭 Future Features

(back to top)

• Create examination, surgery, diagnosis tables
• Add more records to the tables
• Add some constraints to tables

(back to top)

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page

(back to top)

⭐️ Show your support

Give a ⭐️ if you like this project!

(back to top)

🙏 Acknowledgments

• Thanks Microverse for the material you have provided during database creation.

(back to top)

📝 License

This project is MIT licensed.

(back to top)