- 📗 Table of Contents
- 📖 VET CLINIC
- 🛠 Built With
- 🃏 Key Features
- 💻 Getting Started
- 👥 Authors
- 🔭 Future Features
- 🤝 Contributing
- ⭐️ Show your support
- 🙏 Acknowledgments
- 📝 License
In this project, we use a relational database to create the initial data structure for a vet clinic. We create a table to store animals' information, insert some data into it, and query it.
Database
- Create animals table
- Insert data inside animals table
- Write queries for the data inside animals table
- update animals table
- Use transaction
- Use aggregation
- Query multiple tables
- Add "join table" for visits
- Database performance audit
- Add database schema diagram
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.
To get a local copy up and running, follow these steps.
In order to run this project you need:
- To install PostgreSQL
Clone this repository to your desired folder:
cd my-folder
git clone https://github.com/rica213/vet_clinic.git
👤 Larissa Clarielle
- GitHub: @rica213
- Twitter: @alc3and
- LinkedIn: Larissa Clarielle
👤 Racheal Appiah-Kubi
- GitHub: @coderacheal
- Twitter: @racheal_kubi
- LinkedIn: Racheal Appiah-kubi
- Improve query performance
Contributions, issues, and feature requests are welcome!
Feel free to check the issues page.
If you like this project, please give it a star
I would like to thank:
- Microverse
- Reviewers
This project is MIT licensed.