A Vet Clinic Database built using PostgreSQL is a comprehensive system that stores and manages essential information related to veterinary clinics. It includes features such as patient records, medical histories, appointments, treatments, and billing information, facilitating efficient management of veterinary services. With the power of PostgreSQL, the database provides a reliable and scalable solution for organizing and retrieving critical data in a veterinary clinic setting.
. PostgreSQL
Server
Database
- Create tables in SQL
- Insert and query data in SQL.
- Reduce query time execution.
- Used Explain analyze command.
- Create a database based on a diagram.
To get a local copy up and running, follow these steps.
In order to run this project you need:
- Web browser
- Code editor
- Good internet connection
Clone this repository to your desired folder:
cd my-folder
git clone git@github.com:Shaheryar0054/Database-based-diagram.gitInstall this project with:
cd vet_clinic Database-based-diagram
npm installTo run the project, execute the following command:
npm startTo run tests, run the following command:
npm test
Press a to run all testYou can deploy this project using:
👤 Tamoor Saeed
- GitHub: @githubhandle
- Twitter: @twitterhandle
- LinkedIn: LinkedIn
👤 Shaheryar Abid
- GitHub: @githubhandle
- Twitter: @twitterhandle
- LinkedIn: LinkedIn
- query multiple tables
- add "join table" for visits.
- database performance audit.
- add database schema diagram.
Contributions, issues, and feature requests are welcome!
Feel free to check the issues page.
If you like this project so please don't forget to give it a star.
Original Design Idea by: Amanda Yang I would like to thank Microverse for accelerating my growth
-
Can i run it on my local machine or do i need to host it on the internet?
- [Yes you can run it on your local machine. Just make sure that you install the required dependecies as stated in the installation part above]
This project is MIT licensed.