This is a data structure for a vet clinic, created using a relational database. It is a complete database with data about: animals, animals' owners, clinic employees, and visits.
- PostgreSQL server installed and running
- psql installed
$ git clone [email protected]:Sahar-AbdelSamad/vet-clinic.git
$ cd vet-clinic
- Connect to your PostgreSQL server with
psql
psql
- Create the database
vet_clinic
CREATE DATABASE vet_clinic;
- Connect to your database
vet_clinic
\c vet_clinic
- 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!
๐ค Sahar Abdel Samad
- GitHub: @sahar-abdelsamad
- Twitter: @abdelsamadsahar
- LinkedIn: abdel-samad-sahar
Contributions, issues, and feature requests are welcome!
Feel free to check the issues page.
Give a โญ๏ธ if you like this project!