Vet Clinic

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!

Schema Diagram

📗 Table of Contents

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

📖 [Vet_clinic]

[Vet_clinic] :- is a relational database project to create the data structure for a vet clinic. I create a complete database with data about: animals, animals' owners, clinic employees and visits.

🛠 Built With

Tech Stack

Client

• none

Server

• none

Database

• PostgreSQL

Key Features

• [Display_List_of_animals]
• [Search_List_of_animals_by_properties]

(back to top)

🚀 Live Demo

[Live_Demo_Link] ----> (coming soon)

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

• A Computer (MAC or PC)
• Code editor (VSCode,Atom etc...)
• A browser (Chrome,Mozilla,Safari etc...)
• Version Control System (Git and Github)
• NodeJS (https://nodejs.org/en/)
• React {https://react.dev/}
• PostgreSQL {https://www.postgresql.org/}

Setup

Clone this repository to your desired folder:

  cd my-folder
  git clone git@github.com:Besufekad-HAZ/Vet_Clinic.git (SSH)

Install

Install this project with:

• Install PostgreSQL Win
• Install PostgreSQL macOS
• Install PostgreSQL Linux

Usage

To run a SQL file, execute the following command:

To use the \i command, you can type it followed by the path to the file containing the SQL commands you want to execute. For example:

\i /path/to/file.sql

This will execute the SQL commands in the specified file.

👥 Authors

👤 Besufekad Alemu

• GitHub: @Besufekad-HAZ
• Twitter: @BesufekadAlemu7
• LinkedIn: @besura

(back to top)

🔭 Future Features

• Medical records management
• Appointment scheduling

(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 rate it and give it a star...

(back to top)

🙏 Acknowledgments

I would like to thank the Microverse team for allowing us to work on this Vet Clinic Database project.

(back to top)

❓ FAQ

• Do i need PostgreSQL installed?

  • Yes...

• Do i need internet Access?

  • No, you don't the PostgreSQL database server can work offline. And If your server does not have internet access you can install PostgreSQL offline.

(back to top)

📝 License

This project is MIT licensed.

(back to top)