Vet Clinic Database

📗 Table of Contents

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

📖 [your_project_name]

[Vet_Clinic_Database] is a project that was created with a view to enter and manage some data pertaining to a veterinary clinic. The data is about some animals and the data managed includes their clinic ID's, names, date of birth, escape attempts, neutered status and weight in kilograms. The database was created in PostgreSQL and it can be queried to get the needed information.

🛠 Built With

Tech Stack

Database

• PostgreSQL

(back to top)

Key Features

• [animals_table]

(back to top)

💻 Getting Started

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

• Install PostgreSQL to your machine using this link and configure it.
• Create a database with the name vet_clinic. Tutorial on the link.
• Go into the special Postgres terminal for the created database:

  psql vet_clinic

• In the postgres terminal, copy and paste the code from the schema.sql file to create the table.
• copy and paste the code in the data.sql to insert the data of the dogs.
• Now you can query the data using the commands on the queries

Prerequisites

In order to run this project you need:

Install Postgres as shared in getting started.

Setup

Clone this repository to your desired folder:

Command:

  mkdir my-folder
  cd my-folder
  git clone https://github.com/microvese-projects/vet-clinic.git

Install

No installations required for this.

Usage

To run the project, execute the following command: Go into the special Postgres terminal for the created database:

psql vet_clinic

Run tests

Tests are performed by running the queries to verify the data is fed into the DataBASE correctly.

Deployment

The project is not deployed.

(back to top)

👥 Authors

👤 Author1

• GitHub: @bennyjoez
• Twitter: @bennyjoezz
• LinkedIn: Bennyjoez

(back to top)

🔭 Future Features

• [Clinic_Personnel_Table]

(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, you can easily show your appreciation by giving it a star on github

(back to top)

🙏 Acknowledgments

I would like to thank Microverse for the material provided to be able to learn and create this project.

(back to top)

❓ FAQ

• Can I get a local copy of this project?

  • To get a local copy of this project scroll up to the getting started section to create a local copy.

• What is the experience is required to install PostgreSQL?

  • Anyone with any level of experience can install and create a database using PostgreSQL.

(back to top)

📝 License

This project is MIT licensed.

(back to top)