Lucas-Erkana/Vet-clinic

In this project, you I will use a relational database to create the initial data structure for a vet clinic. I will create a table to store animals' information, insert some data into it, and query it.

📗 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

Database

• PostgreSQL

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

(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 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 git@github.com/Lucash20022/Vet-clinic
  cd vet-clinic

(back to top)

👥 Authors

👤 Lucas Erkana

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

👤 Kevin Okoth

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

(back to top)

🔭 Future Features

• ** Increase functionality **

(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 don't forget to give me a star

(back to top)

🙏 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.

(back to top)

📝 License

This project is MIT licensed.

(back to top)