📗 Table of Contents

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

📖 Vet Clinic Database

1. Vet Clinic Database is a relational database to store animals' information, insert data and query data for processing.

2. In this project, records will be updated and deleted. Aggregate functions and GROUP BY will be used to answer analytical questions.

3. In this project new tables and a foreign key columns will be added to the existing animals table to model one-to-many relationships. Afterward, JOIN will be used to query the data.

4. In this project, many-to-many relationships will be added and more complex queries to be used to answer questions will be written.

5. In this project we(Lucas and Kevin) will have a chance to optimize some slow queries in our database.

6. In this project we(Lucas and Kevin) will use your existing project and create a database schema diagram for it.

7. In this project we(Lucas and Kevin) will get a database diagram, interpret it, and implement the SQL needed to build that database.

🛠 Built With

Tech Stack

Key Features

• Database named vet-clinic
• Table named animal
• Update animal table
• Aggregate animal table
• Query multiple tables
• Many-to-Many relationships
• database performance audit
• database schema diagram
• database based on schema diagram

💻 Getting Started

To get a local copy up and running, follow these steps.

Prerequisites

In order to run this project you need postgres:

On Linux:

 sudo apt-get install postgresql postgresql-contrib libpq-dev

On Windows

Go to postgres website and download the installer and follow the installation process

Setup

Clone this repository to your desired folder:

  git clone [email protected]/Lucash20022/Vet-clinic
  cd vet-clinic

👥 Authors

👤 Lucas Erkana

• GitHub: @Lucash2022
• Twitter: @Lucas_David_22
• LinkedIn: Lucas Erkana

👤 Kevin Okoth

• GitHub: @Kevin-Mena
• Twitter: @Fmenawende
• LinkedIn: Kevin Okoth

🔭 Future Features

• ** Increase functionality **

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page.

⭐️ Show your support

If you like this project please don't forget to give me a star

🙏 Acknowledgments

I would like to thank microverse for providing me the template for this project

I would also like to thank my coding partner Kevin Okoth for helping me with the little things.

📝 License

This project is MIT licensed.