• 📗 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 is a relational database to store animals' information, insert data nd query data for processing

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

(back to top)

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!

• 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

Clone this repository to your desired folder:

  git clone [email protected]/yusufyusie/vet-clinic
  cd vet-clinic

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 vet_clininc;
  CREATE DATABASE

  postgres=# \c vet_clininc;
  CREATE DATABASE

Exit sql by running

postgres=# \q

Reconnect with database by

$ psql vet_clinic

=======

postgres=# \q

Reconnect with database by

$ psql vet_clinic

(back to top)

👤 Yesuf Fenta

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

(back to top)

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

(back to top)

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page.

(back to top)

If you like this project please don't forget to give me a star

(back to top)

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

(back to top)

• [Why I use this repository app?]

  • [To create the database for vet_clinic]

(back to top)

This project is MIT licensed.

(back to top)

(back to top)