Vet Clinic Database

Getting Started

📗 Table of Contents

• 📖 About the Project
  • 🛠 Built With
    • Tech Stack
    • Key Features
  • 🚀 Live Demo
• 💻 Getting Started
  • Setup
  • Prerequisites
  • Usage
• 👥 Authors
• 🔭 Future Features
• 🤝 Contributing
• ⭐️ Show your support
• 🙏 Acknowledgements
• 📝 License

📖 [vet_clinic]

[vet_clinic] is a project that contains SQL files that can be used to create a database for a veterinary clinic.

🛠 Built With

Tech Stack

Database

• PostgreSQL

Key Features

• [Create a database]
• [Create tables]
• [Add sample data]
• [Query and update the animals table]
• [Query multiple tables]
• [Add 'join table' for visites]

(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:

• Install postgresql
• PostgreSQL

Setup

Clone this repository to your desired folder:

  git clone https://github.com/Gh-Reza/vet-clinic-database.git

Usage

To run the project, follow these steps:

• Open psql in your terminal
• Create a database using the following command:

  CREATE DATABASE vet_clinic;

• Connect to the database using the following command:

  \c vet_clinic

• For creating table, copy and paste the queries from schema.sql file.
• For adding sample data, copy and paste the queries from data.sql file.

👥 Authors

👤 Reza

• GitHub: @Gh-Reza
• LinkedIn: LinkedIn

(back to top)

🔭 Future Features

Describe 1 - 3 features you will add to the project.

• [Database performance audit]
• [Add database schema diagram]

(back to top)

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page.

(back to top)

⭐️ Show your support

Write a message to encourage readers to support your project

If you like this project, please give it a ⭐️!

(back to top)

🙏 Acknowledgments

I would like to thank Microverse for the opportunity to work on this project.

(back to top)

📝 License

This project is MIT licensed.

(back to top)