📗 Table of Contents

• 📗 Table of Contents
• 📖 Vet Clinic Database
  • 🛠 Built With
    • Tech Stack
    • Key Features
  • 💻 Getting Started
    • Prerequisites
    • Setup
    • Connect to your PostgreSQL server with psql
    • Create the database
    • Connect to the database
  • 👥 Authors
  • 🤝 Contributing
  • ⭐️ Show your support
  • 🙏 Acknowledgments
  • 📝 License

📖 Vet Clinic Database

Vet Clinic Database is a Relational database to create the data structure for a vet clinic

🛠 Built With

Tech Stack

Database

• PostgreSQL

Key Features

• CREATE DATABASE vet_clinic
• CREATE ANIMALS TABLE
• QUERY AND UPDATE ANIMALS TABLE
• QUERY MULTIPLE TABLES
• ADD JOIN TABLE FOR VISITS
• DATABASE PERFORMENCE AUDIT
• ASS DATABASE SCHEMA DIAGRAM

(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

Setup

Clone this repository to your desired folder:

Example commands: git clone https://github.com/AlexisJW/vet-clinic-database.git cd vet-clinic-database

Connect to your PostgreSQL server with psql

  psql

Create the database

  CREATE DATABASE vet_clinic;

Connect to the database

  \c vet_clinic

• Use schema.sql to create all tables.
• Use data.sql to populate tables with sample data.
• Check queries.sql

(back to top)

👥 Authors

👤 Didier Peran Ganthier

• GitHub: @AlexisJW
• LinkedIn: Jean Walner Alexis

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

(back to top)

🙏 Acknowledgments

• N/A

(back to top)

📝 License

This project is MIT licensed.

(back to top)