"Vet Clinic Database" is a powerful, modern database project for a vetinary data management for animals, owners, clinic employees and visits; and applicable to any data management need. It uses Postgresql, a relational database management system, allowing the recording of data on animals; storing, updating and querying the system to acquire specific information for decision-making. It demonstrates the power of the Structured Query Language, DMS (Database Management Systems) and RDMS (Relational Database Management Systems). Enjoy it!
A Demo Video: Introduction to this Project --coming soon
The project includes designs for two different screen sizes.
- Accessible on any screen.
- Better view on Ipads and Desktop systems
Project Brief :
- It is built on a real-life data structure by Microverse.
- It is a Relational Database system
- It uses Postgresql.
- It is ACID ( Atomicity, Consitency, Isolation, Durablity) compliant.
Client
- Pure SQL
- Postgresql
- Database Management Server funtionalities
- Real-life structure
Server
- PostgreSql Server
- Github Servers
- PostgreSql Database
- Conversion of a real structure using Pure SQL*
- Employs Tables and Joining of Tables
- Creating, querying, updating and auditing tables
- Schema development
To get a local copy up and running, follow these steps.
In order to run this project you need:
- Git (for running git related commands only)
- An IDE (e.g. VS Code) - For viewing and accessing the files only
- A system with a good OS like Mac Os, Linux or Windows etc
- PostgreSql (https://www.postgresql.org/download/)
- Depending on your OS, download and install PostgreSql:
- You may watch this video (https://www.youtube.com/watch?v=KuQUNHCeKCk)
- Open your code editor (e.g. VS Code).
- At the terminal, clone this repository to your desired directory.
- Make sure the PostgreSql server is running
- You may refer to https://www.postgresql.org/docs/current/tutorial-start.html
To run the project locally, execute the following command:
- Open the SQL shell by running: psql
- Then, press enter untill you are asked for password
- Enter the password you used during installation
- At the server prompt, connect to the vet_clinic database
- postgres=# \c vet_clinic
- You should see the following message:
- You are now connected to database "vet_clinic" as user "postgres".
- vet_clinic=#
- Voila! Now, run the following:
- For Table creation, copy and run the queries in the schema.sql file
- For Data insertion and updates, copy and run the queries in the data.sql
- Queries, copy and run the queries in the query.sql file
- Make sure your results match the information in the added query images
You can deploy this project using:
- GitHub Pages from a specific branch (e.g. main).
- You may read: https://github.com/topics/database-deployment
- You can also used any cloud service like gcloud or Azure.
- A deployed version can be found here: [https://... (Coming Soon)
👤 Omet Omeni (Ometman)
- GitHub: @ometman
- Twitter: @twitterhandle
- LinkedIn: LinkedIn
👤 Filbert Kimasa
- GitHub: @githubhandle
- Twitter: @twitterhandle
- LinkedIn: LinkedIn
👤 Noel Bryant
- GitHub: @githubhandle
- Twitter: @twitterhandle
- LinkedIn: LinkedIn
- Additional and Advance queries
- Full web view and accessiblity
- Adding a help information
Contributions, issues, and feature requests are welcome!
Feel free to check the issues page.
As a tech enthusiast, your support is always appreciated. If you like this project please do let us know with your support in any way you see fit.
I would like to thank especially Microverse for inspiring this project & project guidelines.
-
Can I fork this project?
- Yes, feel free to fork and knock yourself out :) .
-
Can I share this project with others?
- Yes, you can share this project for any educational purposes.
This project is MIT licensed.