This repository includes files with plain SQL that can be used to recreate a database:
- Use schema.sql to create all tables.
- Use data.sql to populate tables with sample data.
- Check queries.sql for examples of queries that can be run on a newly created database. Important note: this file might include queries that make changes in the database (e.g., remove records). Use them responsibly!
VET_CLINIC is a database for keeping records of pets in a vertinary.
To be updated ...
Client
Server
Database
- Users can create database table using this project
- User can insert and update database table column
- User can get specific data with different sql query
To get a local copy up and running, follow these steps.
In order to run this project you need:
Example command:
Download and install PostgreSQL database.
Either psql cli or pgAdmin4 GUI to interact with the database.
Clone this repository to your desired folder:
Example commands:
cd my-folder
git clone git@github.com:tobuya/Vet_Clinic.git
Install this project with:
Example command:
- Download and install postgress database to run this project.
To run the project, execute the following command:
- Use schema.sql to create all tables.
- Use data.sql to populate tables with sample data.
- Check queries.sql for examples of queries that can be
- run on a newly created database.
👤 Thomas Obuya
- GitHub: @githubhandle
- Twitter: @twitterhandle
- LinkedIn: LinkedIn
- More queries and schema
Contributions, issues, and feature requests are welcome!
Feel free to check the issues page.
If you like this project give it a star ⭐️.
I would like to thank Microverse.
This project is MIT licensed.