๐ Table of Contents
- ๐ About the Project
- ๐ป Getting Started
- ๐ฅ Authors
- ๐ญ Future Features
- ๐ค Contributing
- โญ๏ธ Show your support
- ๐ Acknowledgements
- ๐ License
๐ Vet Clinic Database
-
Vet Clinic Database is a relational database to store animals' information, insert data and query data for processing.
-
In this project, records will be updated and deleted. Aggregate functions and GROUP BY will be used to answer analytical questions.
-
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.
-
In this project, many-to-many relationships will be added and more complex queries to be used to answer questions will be written.
-
In this project we(Lucas and Kevin) will have a chance to optimize some slow queries in our database.
-
In this project we(Lucas and Kevin) will use your existing project and create a database schema diagram for it.
-
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
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.