📗 Table of Contents

• 📖 About the Project
  • 🛠 Built With
    • Tech Stack
    • Key Features
• 💻 Getting Started
  • Prerequisites
  • Setup
  • Create database
• [Database Schema Diagram] (#Database-Schema-Diagram)
• 👥 Author
• 🔭 Future Features
• 🤝 Contributing
• ⭐️ Show your support
• 🙏 Acknowledgements
• ❓ FAQ
• 📝 License

📖 Vet Clinic Database

Vet Clinic Database is a project to create the initial data structure for a veterinary clinic using a relational database. It implements PostgreSQL and contains all the data about animals.

🛠 Built With

Tech Stack

Client

• PostgreSQL

Key Features

• Create a database to store animals' information
• Insert some data into table, and query it

(back to top)

💻 Getting Started

Prerequisites

In order to run this project you need:

• PostgreSQL server installed and running
• psql installed

Setup

Clone this repository to your desired folder:

git clone https://github.com/vvoo21/Vet-Clinic-Database.git
cd Vet-Clinic-Database

Create database

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=#

That's it! Congratulations, you have created your database and connected to it. Next, we will 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)

Database Schema Diagram

(back to top)

👥 Author

👤 Vanessa Oliveros Padron

• GitHub: @vvoo21
• Twitter: @vaneoliverosp
• LinkedIn: vaneoliverosp

👤 Timothy Njoroge

• GitHub: @simplegoose
• LinkedIn: Timothy Njoroge

(back to top)

🔭 Future Features

• Insert new data
• Update existence data
• Delete existence data

(back to top)

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page.

(back to top)

⭐️ Show your support

Give a start if you like this project!

(back to top)

🙏 Acknowledgments

• I would like to thank the Microverse program!
• I would like to thank anyone whose code was used!

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