Vet-clinic

In this project, I have used a relational database to create the data structure for a vet clinic. I added animals, animals' owners, clinic employees, and visits Tables.

Schema Diagram

Built With

• SQL (PostgreSQLdoc)

Getting started

1. Installing PostgreSQL
2. Clone the project
3. Change directory cd vet_clinic
4. On the cmd run psql -U postgres to login to postgres.
5. Run \c vet_clinic to create the database.
6. Run \i schema.sql to create the Table schema.
7. Run \i data.sql to enter the data.
8. Run SELECT * FROM animals to view all data entries.
9. Run your desired query from queries.sql

Prerequisites

Internet connection and basic computing skills. Load the page and enjoy!

Author

👤 Atsighi Bright

• GitHub: @brytebee
• Twitter: @brytebee
• LinkedIn: brytebee

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page here 😏😏.

Show your support

Give a ⭐️ if you like this project!

Acknowledgments

All thank to God Almighty for life. To the:

• entire microverse community
• My conding partners,
• Stand-up team, and
• Morning team

Thanks for all contributions and reviews.

📝 License

This project is MIT licensed.