The initial data structure for a vet clinic uses a PostgreSQL relational database. Create a table to store animals' information, some data inserted into it, and queries performed. Update and delete records using transactions and GROUP BY to answer analytical questions. Use primary & foreign keys mechanisms for joining tables. Query multiple tables. Add many to many relationships. Solve some performance issue.
- PostgreSQL
This repository includes files with plain SQL that can be used to recreate a database:
- Use schema.sql to create database and table.
- 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.
👤 Elson Otake
- GitHub: elsonotake
- Twitter: @elsonotake
- LinkedIn: elsonotake
👤 Achike Chuma Edward
- GitHub: @chumaachike
- Twitter: @AchikeChuma
- LinkedIn: Edward Achike
Contributions, issues, and feature requests are welcome!
Feel free to check the issues page.
Give a ⭐️ if you like this project!
- Microverse
- W3Schools
- Stack Overflow
This project is MIT licensed.