Vet clinic database: create animals table

In this project I use a relational database to create the initial data structure for a vet clinic. I create a table to store animals' information, insert some data into it, and query it.

Before

Screenshoot-Before Screenshoot-Before Screenshoot-Before

After

Screenshoot-After Screenshoot-After Screenshoot-After

Getting Started

This repository includes files with plain SQL that can be used to recreate a database:

Schema Diagram for vet clinic

vet-clinic-schema-diagram

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

Authors

👤 Roshan Bajgain

👤 Ola Ishola

🤝 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 anyone whose code was used
  • Inspiration
  • etc

📝 License

This project is MIT licensed.