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!

📗 Table of Contents

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

📖 Vet clinic database

Vet clinic database is a relational database created to store records about animals, animals' owners, clinic employees and visits.

🛠 Built With

Tech Stack

The tech stack in this project includes.

Client

Server

Database

• PostgreSQL

Key Features

• DataBase for managing animal clinic
• Animal Table with sample records

(back to top)

🚀 Live Demo

• Not available

(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 or any other SQL database.

Setup

• Clone this repository to your desired folder.
• Alternatively, you can download the zip file of your project by clicking on the Code button on the right side of your project page and clicking on Download ZIP

Install

Install this project with: Install PostgreSQL

Usage

To run the project, execute the following command:

• Start Postgres server.
• Run psql.
• Create table.

Run tests

To run tests, run the following command: Not available.

Deployment

You can deploy this project using: Not available.

(back to top)

👥 Authors

👤 Chere Lemma

• GitHub: @githubhandle
• Twitter: @twitterhandle
• LinkedIn: LinkedIn

👤 Okpara Blessing Oluchi

• GitHub: @githubhandle
• Twitter: @twitterhandle
• LinkedIn: LinkedIn

(back to top)

🔭 Future Features

In the future work,

• Treatment Table
• Invoices Table

(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 give a ⭐️.

(back to top)

🙏 Acknowledgments

I would like to thank Microverseinc for the curriculum-template-databases

(back to top)

❓ FAQ

• For what purpose this project can be used

  • For educational purpose. Any one who want learn relational database.

• Can I use this project for my website?

  • Yes of course. It's MIT license, feel free to use as you want.

(back to top)

📝 License

This project is MIT licensed.

(back to top)