/vet_clinic

It's a project on relational database to create the initial data structure for a vet clinic, create a table to store animal's information, insert some data into it, and query it.

Primary LanguagePLpgSQL

Vet clinic database: query and update animals table

In this milestone of the project, i used transactions to update and delete records, aggregate functions and GROUP BY to answer analytical questions.

Built With

  • PLpgSQL

screenShot

screenshot

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

👤 Debas Gebreslasie

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

📝 License

This project is MIT licensed.