Skip to content

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.

License

Notifications You must be signed in to change notification settings

katarighe/vet-clinic-database

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

67 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

📗 Table of Contents

📖 Vet Clinic Database

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

🛠 Built With

Client
Server
Database

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 drawSQL-vet-clinic-export-2023-09-26

👥 Authors

👤 Mohamed Aden Ighe

(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

(back to top)

📝 License

This project is MIT licensed.

(back to top)

About

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.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published