/vet-clinic-database

Using PostgreSQL to build a relational database for a vet clinic

Primary LanguagePLpgSQL

Vet Clinic Database

This project contains the SQL commands used for building a relational database for a vet clinic scenario, as part of Microverse projects.

Things done so far:

  1. Set up initial data structure
  • Create database vet_clinic
  • Create table animals
  • Insert data into table
  • Query data
  1. Execute transactions and query data using aggregate functions
  • Use database transactions
  • Use aggregate functions for more complex queries
  1. Query multiple tables
  • Add foreign keys to model 1-many relationships
  • Query data using JOIN
  1. Add join tables
  • Add join tables to model many-many relationships
  • Query data from all tables

Technologies Used

PostgreSQL

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!

Authors

👤 Akasha Rojee

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