📗 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 for a vet clinic with details about animals, animal's owners, clinic employees and visits

🛠 Built With

Tech Stack

Database

• PostgreSQL

Key Features

• [Create database]

• [Create table]

• [Insert into database]

• [Query database]

• [Update and delete from database]

• [SQl transactions]

• [SQl Aggregates]

• [Alter table attributes and constraints]

• [SQL JOIN]

• Add "join table" for visits

(back to top)

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

• To install Postgresql

Setup

Clone this repository to your desired folder:

Example commands:

git clone https://github.com/FrankMugagga/vet-clinic-database.git cd vet-clinic-database

Install

Install this project with:

Example command:

cd vet-clinic-database

Usage

To run the project, execute the following command: From the command line run;

• sudo -i -u postgres
• psql
• \c database name

Run tests

To run tests, run the following command:

Deployment

You can deploy this project using: -->

(back to top)

👥 Authors

👤 Frank Mugagga

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

👤 Mursedul Islam Sumon

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

(back to top)

🔭 Future Features

• Using a schema
• Add "join table" for visits

(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 please leave a star, share or contact me for a chat

(back to top)

🙏 Acknowledgments

I would like to thank Microverse and my coding partners for the support and code reviewer for guidance

(back to top)

📝 License

This project is MIT licensed.

(back to top)