README.md

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 git@github.com: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)