- 📖 About the Project
- 💻 Getting Started
- 👥 Authors
- 🤝 Contributing
- ⭐️ Show your support
- 🙏 Acknowledgements
- ❓ FAQ
- 📝 License
An database project on PostgreSQL.
[Vet Clinic] A database project that involves using PostgreSQL. In this project, I used a relational database to create the data structure for a vet clinic
- PostgreSQL
- Github
- SQL
- GitFlow
Database
Server
- A localhost server created using PSQL
### Key Features <a name="key-features">
- An Animal table containing the following columns: Id, Name, Date of birth, Escape attempts, Neutered, Weight
<p align="right">(<a href="#readme-top">back to top)
This repository includes files with plain SQL that can be used to recreate the VET CLINIC 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!
In order to run this project you need:
- PostgreSQL installed
- A GitHub Account
- VS Code
- Open PSQL
- create a new database using CREATE DATABASE Vet Clinic
- connect to database using the command \c Vet Clinic
Mention all of the collaborators of this project.
👤 Stanley Nnamani AKA StarMindz
- GitHub: @Starmindz
- LinkedIn: Stanley Nnamani
Contributions, issues, and feature requests are welcome!
Feel free to check the issues page.
If you like this project, please give it a star and also follow me on GitHub for future projects
- Thumb ups to all the Naija Afrobeat Musicians whose beautiful music made building this project more fun
This project is MIT licensed.
NOTE: we recommend using the MIT license - you can set it up quickly by using templates available on GitHub. You can also use any other license if you wish.