Vet Clinic

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.

Getting Started

Requirements

• PostgreSQL server installed and running
• psql installed

Clone this repository

$ git clone git@github.com:Sahar-AbdelSamad/vet-clinic.git
$ cd vet-clinic

1. Connect to your PostgreSQL server with psql

psql

2. Create the database vet_clinic

CREATE DATABASE vet_clinic;

3. Connect to your database vet_clinic

\c vet_clinic

4. Use schema.sql to create all tables
5. Use data.sql to populate tables with sample data
6. 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!

Authors

👤 Sahar Abdel Samad

• GitHub: @sahar-abdelsamad
• Twitter: @abdelsamadsahar
• LinkedIn: abdel-samad-sahar

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page.

Show your support

Give a ⭐️ if you like this project!