Vet Clinic Database is a relational database to store animals' information, insert data nd query data for processing
Database
- Database named vet-clinic
- Table named animal
- Run relevant queries to fetch data from the database
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!
- Postgresql@16:
To install run:
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
Clone this repository to your desired folder:
git clone [email protected]/yusufyusie/vet-clinic
cd vet-clinic
To run the project, start the Postgresql server first, connect with vet_clininc database and execute the following commands on terminal:
$ brew services restart postgresql@14
$ psql postgres
postgres=# CREATE DATABASE vet_clininc;
CREATE DATABASE
postgres=# \c vet_clininc;
CREATE DATABASE
Exit sql by running
postgres=# \q
Reconnect with database by
$ psql vet_clinic
=======
postgres=# \q
Reconnect with database by
$ psql vet_clinic
๐ค Yesuf Fenta
- GitHub: @yusufyusie
- Twitter: @yusufyusiee
- LinkedIn: yusufyusie
- Add Column To Table
- Create Bridge Table
- Add Join queries
- Add multiple tables
Contributions, issues, and feature requests are welcome!
Feel free to check the issues page.
If you like this project please don't forget to give me a star
I would like to thank microverse for providing me with the template for this project
-
[Why I use this repository app?]
- [To create the database for vet_clinic]
This project is MIT licensed.