/vet_clinic_database

This repository demonstrated the use of PostgreSQL SQL commands for tasks such as creating a database and table, inserting data into the table, and executing various queries with different parameters.

Primary LanguagePLpgSQLMIT LicenseMIT

📗 Table of Contents

📖 Vet Clinic Database

demonstrated the use of PostgreSQL commands for tasks such as creating a database and table, inserting data into the table, and executing various queries with different parameters.

Project Screenshots

screen shot

🛠 Built With

  • Sql shell (psql) and pgAdmin

Tech Stack

PostgreSQL

Database

Key Features

  • Vet clinic database
  • animals table
  • animals data
  • Querying data
  • aggregate functions
  • owners table
  • species table
  • relations between tables with foreign keys
  • join queries
  • visits, specializations, and vets tables
  • many-to-many relationships

(back to top)

💻 Getting Started

Prerequisites

In order to run this project you need installed postgresql and pgAdmin.

Setup

Clone this repository to your local machine and run sql commands in the terminal or pgAdmin.

  git clone https://github.com/zewdu444/vet_clinic_database.git
  cd vet_clinic_database

Usage

To run the project, execute the following command:

  1 create vet_clinic database
  2 Run  schema.sql
  3 to insert data into the table run data.sql
  4 execute queries

👥 Authors

👤 zewdu erkyhun

(back to top)

🔭 Future Features

Performance will be checked for the queries and the database will be optimized.

(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 ⭐️ if you like this project!

(back to top)

🙏 Acknowledgments

I would like to thank microverse community for the support and guidance.

(back to top)

📝 License

This project is MIT licensed.

(back to top)