katarighe/vet-clinic-database

This is a project about creating the data structure for a veterinary clinic using a relational database. The database contains tables for animals, animal owners, clinic employees, and visits. It is built with PostgreSQL.

📗 Table of Contents

• 📖 About the Project
  • 🛠 Built With
    • Tech Stack
    • Key Features
• 💻 Getting Started
• 👥 Authors
• 🔭 Future Features
• 🤝 Contributing
• ⭐️ Show your support
• 🙏 Acknowledgements
• 📝 License

📖 Vet Clinic Database

The Vet Clinic Database is a simple database that stores information about the animals in the vet.

🛠 Built With

Client

• React.js

Server

• Express.js

Database

• PostgreSQL

Key Features

The three key features of this project include the following.

• *Query and update the animals table.
• Query multiple tables.
• Add "join table" for vists.

(back to top)

💻 Getting Started

Get ready to explore Vet Clinic Database with these steps:

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!

Schema Diagram

👥 Authors

👤 Mohamed Aden Ighe

• GitHub: @katarighe
• Twitter: @katarighe
• LinkedIn: @mighe

(back to top)

🔭 Future Features

Here are some future features that could be added to the Vet Clinic Database in the future.

• User authentication and authorization: This would allow users to create accounts, sign in and out, and have their own personal items.

These are just a few ideas for future features that could be added to the Vet Clinic Database. The specific features that are added will depend on the needs and wants of the users.

(back to top)

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page.

(back to top)

⭐️ Show your support

Give a star⭐️ or a thumbs up 👍 if you like this project! You can visit my GitHub profile for more of my projects.

(back to top)

🙏 Acknowledgments

• Project supervised by Microverse
• Creative Commons 4.0 License

(back to top)

📝 License

This project is MIT licensed.

(back to top)