/Vet-clinic-database

This project is about using a relational database to create the initial data structure for a vet clinic. There is a table to store animals information, insert some data into it, and query it.

Primary LanguagePLpgSQL

Vet Clinic database

This project uses a relational database to create the initial data structure for a vet clinic. This includes a table to store animals' information, insert some data into it, and query it.

Schema diagram

Built with

  • PostgreSQL
  • DrawSQL

Getting Started

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!

Author

👤 Favour Amarachi Ezeugwa

🤝 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!

Acknowledgments

  • Hat tip to Microverse
  • Inspiration

📝 License

This project is MIT licensed.