📗 Table of Contents

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

📖 Vet Clinic Database

In this project, I used a relational database to create the initial data structure for a vet clinic. I created a table to store animals' information, inserted some data into it, and queried it.

🛠 Built With

Tech Stack

SQL - Structured Query Language

• React.js

Key Features

• a table named animals with the following columns:
• id: integer
• name: string
• date_of_birth: date
• escape_attempts: integer
• neutered: boolean
• weight_kg: decimal

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

• To download and install PostgreSQL
• Go through documentation

Setup

Clone this repository to your desired folder:

  cd my-project
  git clone https://github.com/geekelo/vet_clinic_database.git

Install

Install this project with:

  cd vet_clinic_database
  code .

Usage

To run the project, execute the following command:

• Launch Terminal
• Connect to database

  \c vet_clinic database

Run tests

To run tests, run the following command:

• Run commands to create and query database

Deployment

At the moment this project is not deployed

(back to top)

👥 Authors

👤 Eloghene Otiede

• GitHub: @githubhandle
• Twitter: @twitterhandle
• LinkedIn: LinkedIn

👤 Mahdi Noori

• GitHub: @Mahdi Noori
• LinkedIn: @Mahdi Noori

(back to top)

🔭 Future Features

• Add SQL Commands for updating database

(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 kindly give it a star. Thanks in advance.

(back to top)

🙏 Acknowledgments

I would like to thank Microverse for inspiring this project.

(back to top)

❓ FAQ

• Can I use a GUI when working with Postgresql?

  • Yes you can. Postgresql comes with GUI and CLI interfaces

• Do I have to use constraints when creating my table?

  • It is necessary to do soo in other to avoid errors with data

(back to top)

📝 License

This project is MIT licensed.

(back to top)