shasherazi/vet-clinic

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!

📗 Table of Contents

• 📖 About the Project
  • 🛠 Built With
    • Tech Stack
    • Key Features
• 💻 Getting Started
  • Setup
  • Prerequisites
  • Usage
  • Schema diagram
• 👥 Authors
• Future Features
• 🤝 Contributing
• ⭐️ Show your support
• 📝 License

📖 Vet Clinic Database

Vet clinic database is a database for a veterinary clinic. It stores information about animals that visit the clinic. It is a project for the Microverse curriculum.

🛠 Built With

Tech Stack

Database

• PostgreSQL

Key Features

• It stores the names of all animals that visit the clinic.
• It stores the date of birth of each animal.
• It stores the weight of each animal.

(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

Setup

Clone this repository to your desired folder:

  git clone git@github.com:shasherazi/vet-clinic.git
  cd vet-clinic

Usage

To run the project, execute the following command:

Example command:

  createdb vet_clinic

(back to top)

Schema Diagram

👥 Authors

👤 shasherazi

• GitHub: @shasherazi
• Twitter: @shasherazi
• LinkedIn: shasherazi

👤 Aubin Simpeze

• GitHub: @aubinleyoung
• Twitter: @aubin_simpeze
• LinkedIn: aubin-simpeze

(back to top)

Future Features

• Add more tables to store more information about animals and their owners.
• Add more queries to retrieve information from the database.
• Add more constraints to the database.

🤝 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 please give it a ⭐️!

(back to top)

📝 License

This project is MIT licensed.

(back to top)