📗 Table of Contents

• 📗 Table of Contents
• 📖 [vet-clinic-db]
  • Database diagrams
    • Schema
  • 🛠 Built With
    • Tech Stack
    • Key Features
  • 💻 Getting Started ]
    • Prerequisites
    • Setup
    • Usage
  • 👥 Authors
  • 🔭 Future Features
  • 🤝 Contributing
  • ⭐️ Show your support
  • 🙏 Acknowledgments
  • 📝 License

📖 [vet-clinic-db]

[vet-clinic-db] is a program that creates a data base for a vet clinic.

Database diagrams

Schema

🛠 Built With

• postgresql

Tech Stack

• PostgreSQL

Key Features

• [Creates animals table]
• [Populates the table with animals]
• [Make different queries]

(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

Setup

Clone this repository to your desired folder:

  cd my-folder
  git clone https://github.com/yuvenalmash/vet-clinic-db.git

Usage

1. Connect to your PostgreSQL server with psql

> psql
postgres=#

2. Create the database vet_clinic

postgres=# CREATE DATABASE vet_clinic;
CREATE DATABASE

3. Connect to your database vet_clinic. Inside your current session do:

postgres=# \c vet_clinic
You are now connected to database "vet_clinic" as user "postgres".
vet_clinic=#

You have created your database and connected to it. Next, add a table.

• 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.

(back to top)

👥 Authors

👤 Yuvenal Njoroge

• GitHub: @yuvenalmash
• Twitter: @Juvenal
• LinkedIn: Yuvenal Njoroge

(back to top)

🔭 Future Features

• [Increase functionality]

(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 give it a star.

(back to top)

🙏 Acknowledgments

I would like to thank microverse for the inspiration.

(back to top)

📝 License

This project is MIT licensed.

NOTE: we recommend using the MIT license - you can set it up quickly by using templates available on GitHub. You can also use any other license if you wish.

(back to top)