/Vet-Clinic-Database

Primary LanguagePLpgSQLMIT LicenseMIT

Vet Clinic Database

In the project I have used a relational database to create the initial data structure for a vet clinic. I have created a table to store animals' information, insert some data into it, and query it.

In this project, I have used a relational database to create the data structure for a vet clinic. I have started with one table, and step by step, I have created a complete database with data about:

  • animals
  • animals' owners
  • clinic employees
  • visits

📗 Table of Contents

📖 About the Project

Create animals table.

In the project I have used a relational database to create the initial data structure for a vet clinic. I have created a table to store animals' information, insert some data into it, and query it.

Query and update animals table.

In this section of project, I have used transactions to update and delete records. I have also used my knowledge of aggregate functions and GROUP BY to answer analytical questions.

Query multiple tables.

In this section of project, I have added some new tables and add foreign key columns to your existing animals table to model one-to-many relationships. Afterward, I have used JOIN to query the data.

Add "join table" for visits.

In this section of project, I have added some many-to-many relationships and write more complex queries to use them to answer questions.

Create a database based on a diagram.

In this section of project, I have created a database clinic with help of diagram, interpret it, and implement the SQL needed to build that database.

🛠 Built With

Tech Stack

Database

Key Features

  • Create animals table.
  • Query and update animals table.
  • Query multiple tables.
  • Add "join table" for visits.
  • Database performance audit.

(back to top)

🔭 Future Features

  • Working with Transactions

(back to top)

💻 Getting Started

To get a local copy up and running, follow these steps.

Setup

Clone this repository to your desired folder:

  git clone https://github.com/MudasirSherwani/Vet-Clinic-Database.git
  cd Vet-Clinic-Database

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.

(back to top)

👥 Authors

👤 Mudasir Sherwani

👤 Chimezie Asouzu

(back to top)

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page.

(back to top)

⭐️ Show your support

If you like this project give me a star.

(back to top)

🙏 Acknowledgments

I would like to thanks Microverse to guide me to complete this project.

(back to top)

📝 License

This project is MIT licensed.

(back to top)