📗 Table of Contents

• 📖 About the Project
  • 🛠 Built With
    • Tech Stack
    • Key Features
• 💻 Getting Started
  • Prerequisites
  • Setup
  • Create database
• 👥 Author
• 🤝 Contributing
• ⭐️ Show your support
• 🙏 Acknowledgements
• ❓ FAQ
• 📝 License

📖 Vet Clinic Database

A relational database has been used to create the data structure for a vet clinic. The database is complete with data about:

• animals
• animals' owners
• clinic employees
• visits

Tech Stack

Database

• PostgreSQL

Key Features

• [GitFlow]
• [Relational Database]

(back to top)

💻 Getting Started

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

Prerequisites

In order to run this project you need:

• PostgreSQL server installed and running
• psql installed

Install

• Install the relational database PostgreSQL.
• After installing PostgreSQL read the Getting started chapter from PostgreSQL's manual to understand the basics and how to check if it's working.

Setup

Clone this repository to your desired folder.

1. Connect to your PostgreSQL server with psql

> psql
postgres=#

2. Create the database vet_clinic

postgres=# CREATE DATABASE vet_clinic;
CREATE DATABASE

3. Connect to your database vet_clinic. Inside your current session do:

postgres=# \c vet_clinic
You are now connected to database "vet_clinic" as user "postgres".
vet_clinic=#

That's it! Congratulations, you have created your database and connected to it. Next, we will add a table.

• 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

👤 Ashmal Zahra

• GitHub: @ashmalzahra
• Twitter: @AshmalZahraa
• LinkedIn: ashmal-zahra

(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

• curriculum-databases-projects-template from Microverse

📝 License

This project is MIT licensed.

(back to top)