Skip to content

Latest commit

 

History

History
63 lines (40 loc) · 1.67 KB

README.md

File metadata and controls

63 lines (40 loc) · 1.67 KB
Raw

Vet-clinic

In this project, I have used a relational database to create the data structure for a vet clinic. I added animals, animals' owners, clinic employees, and visits Tables.

Schema Diagram

image

schema diagram

Built With

  • SQL (PostgreSQLdoc)

Getting started

  1. Installing PostgreSQL
  2. Clone the project
  3. Change directory cd vet_clinic
  4. On the cmd run psql -U postgres to login to postgres.
  5. Run \c vet_clinic to create the database.
  6. Run \i schema.sql to create the Table schema.
  7. Run \i data.sql to enter the data.
  8. Run SELECT * FROM animals to view all data entries.
  9. Run your desired query from queries.sql

Prerequisites

Internet connection and basic computing skills. Load the page and enjoy!

Author

👤 Atsighi Bright

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page here 😏😏.

Show your support

Give a ⭐️ if you like this project!

Acknowledgments

All thank to God Almighty for life. To the:

  • entire microverse community
  • My conding partners,
  • Stand-up team, and
  • Morning team

Thanks for all contributions and reviews.

📝 License

This project is MIT licensed.