📗 Table of Contents

• 📗 Table of Contents
• 📖 [Vet Clinic Database]
  • 🛠 Built With
    • Tech Stack
    • Key Features
  • 💻 Getting Started
    • Prerequisites
    • Setup
    • Usage
  • 👥 Authors
  • 🔭 Future Features
  • 🤝 Contributing
  • ⭐️ Show your support
  • 🙏 Acknowledgments
  • ❓ FAQ
  • 📝 License

📖 [Vet Clinic Database]

Clinic Database is a relational database to get a database diagram, interpret it, and implement the SQL needed to build that database

🛠 Built With

Tech Stack

Database

• PostgreSQL

Key Features

• Database named vet-clinic
• Table named animal
• Run relevant queries to fetch data from the database

(back to top)

💻 Getting Started

This repository includes file with plain SQL that can be used to recreate a database:

• Use schema.sql to create all tables.

Important note: this file might include queries that make changes in the database (e.g., remove records). Use them responsibly!

Prerequisites

• Postgresql@16:

To install run:

On Linux:

 sudo apt-get install postgresql postgresql-contrib libpq-dev

On Windows

Go to postgres website and download the installer and follow the installation process

Setup

Clone this repository to your desired folder:

  git clone git@github.com/yusufyusie/vdatabase-diagram
  cd database-diagram

Usage

To run the project, start the Postgresql server first, connect with vet_clininc database and execute the following commands on terminal:

  $ brew services restart postgresql@14
  $ psql postgres

  postgres=# CREATE DATABASE clinic;
  CREATE DATABASE

  postgres=# \c clinic;
  CREATE DATABASE

Exit sql by running

postgres=# \q

Reconnect with database by

$ psql clinic

=======

postgres=# \q

Reconnect with database by

$ psql clinic

(back to top)

👥 Authors

👤 Yesuf Fenta

• GitHub: @yusufyusie
• Twitter: @yusufyusiee
• LinkedIn: yusufyusie

(back to top)

🔭 Future Features

• Add Column To Table
• Create Bridge Table
• Add Join queries
• Add multiple tables

(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 please don't forget to give me a star

(back to top)

🙏 Acknowledgments

I would like to thank microverse for providing me with the template for this project

(back to top)

❓ FAQ

• [Why I use this repository app?]

  • [To create the database for vet_clinic]

(back to top)

📝 License

This project is MIT licensed.

(back to top)

(back to top)