Skip to content

This project is aims to practice SQL queries using postgreSQL Database. I have used multiple complex query for insertion, update row, alter table schema and also different join statement types.

Notifications You must be signed in to change notification settings

bushmusi/clinic-db

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

29 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Veternay clinic Database Project

This is the database for the vet clinic app which is composed of relational SQL data. There are different tables containing various information for example the animals table contains information about the animals in the clinic

Diagram

ERD

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!

Authors

👤 Author1

👤 Jonathan Sivahera

👤 Samiullah Bahadur

🤝 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 anyone whose code was used
  • Inspiration
  • etc

📝 License

This project is MIT licensed.

About

This project is aims to practice SQL queries using postgreSQL Database. I have used multiple complex query for insertion, update row, alter table schema and also different join statement types.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published