📗 Table of Contents

• 📗 Table of Contents
• 📖 Vet Clinic Database
  • 🛠 Built With
    • Tech Stack
    • Key Features
  • 🚀 Schema Diagram
  • 💻 Getting Started
    • Prerequisites
    • Setup
    • Creating a database
  • 👥 Authors
  • 🔭 Future Features
  • 🤝 Contributing
  • ⭐️ Show your support
  • 📝 License

📖 Vet Clinic Database

Vet Clinic Database is a relational database, based on a real-life example, to create the data structure for a vet clinic. The database consist of data about

• Animals
• Animals's owners
• Clinic employees
• Visits

🛠 Built With

Tech Stack

Client

• PostgreSQL

Key Features

• Create Database animals table to store animals' information
• Insert data to the table and perform query to it
• Update animals table by altering the rows and create more tables.
• Primary key & foreign key mechanism for joining tables to model one-to-many relationships.
• Join tables to model many-to-many relationships.
• Database performance audit.

(back to top)

🚀 Schema Diagram

(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 git@github.com:KanzaTahreem/Vet-Clinic-Database.git
  cd Vet-Clinic-Database

Creating a 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_clininc
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. Learn more at PostgreSQL: Create 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.

(back to top)

👥 Authors

👤 Author 1

• GitHub: @KanzaTahreem
• Twitter: @kanza_tahreem
• LinkedIn: Kanza Tahreem

👤 Author 2

• GitHub: @camilovelag
• Twitter: @camilovelag
• LinkedIn: camilovelag

(back to top)

🔭 Future Features

• Add more data to the tables
• Perform multiple queries

(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 and want to support me make cooler projects Give this project a Star.

(back to top)

📝 License

This project is MIT licensed.

(back to top)