Aniaml Clinic

Milestone 1:

In this Milestone, I created a new data base with a single animal table, added values and created some queries.

Milestone 2:

✅ Added a new column to animals table called species 🧬
✅ Inserted new animals into the database. 🦁 🐢 🌱
✅ Added transactions 💸 🪙
✅ Wrote new queries to answer the questions ❓

Milestone 3:

✅ Refactored animals table
✅ Created two new tables
✅ Inserted values to those new tables
✅ Filled FK at animals table
✅ Wrote queries

Milestone 4:

✅ Created vets table 👨‍⚕️ 👩‍⚕️
✅ Created a relationships many to many through specializations and visits tables 🤲
✅ Inserted data to the new tables 📄
✅ Wrote queries to answer questions ⌨️ ❓

Getting Started

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

👤 Alejandro Ramos

• GitHub: @AlexRS90
• Twitter: @AlejandroRBenji
• LinkedIn: @AlexRS90

🤝 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

• MIT License