Skip to content

This is a relational database to create the data structure for a vet clinic. It consists of four main tables, namely: animals table, species table, owners table, and vets table. It also consists of two join tables called specialization and visits table. This repository consists of the schema, data, and queries for different questions.

Notifications You must be signed in to change notification settings

Ney2/Vet-Clinic

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

31 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Vet-Clinic

This is a simple relational database that holds data about animals. It consists of three tables:- animals table, species table, and owners_table.

Getting Started

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!

Entity Relationship Diagram

WhatsApp Image 2022-09-27 at 4 42 41 PM

👤 Kidist Guta

👤 Aquinas Moriasi

🤝 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!

Acknowledgments

  • Hat tip to Microverse

📝 License

This project is MIT licensed.

About

This is a relational database to create the data structure for a vet clinic. It consists of four main tables, namely: animals table, species table, owners table, and vets table. It also consists of two join tables called specialization and visits table. This repository consists of the schema, data, and queries for different questions.

Topics

Resources

Stars

Watchers

Forks

Packages

No packages published