📗 Table of Contents

📖 About the Project
- 🛠 Built With
  - Tech Stack
  - Key Features
- 🚀 Live Demo
💻 Getting Started
- Setup
- Prerequisites
- Install
- Usage
- Run tests
- Deployment
👥 Authors
🔭 Future Features
🤝 Contributing
⭐️ Show your support
🙏 Acknowledgements
❓ FAQ (OPTIONAL)
📝 License

📖#Vet clinic database

Vet_clinic is a database project where in we create relations for animals using relational database postgreSQL for a vet clinic

🛠 Built With

Tech Stack

SQL
PostgreSQL Data base

Database

PostgreSQL

Key Features

-Create database and table for animals -Insert animals' data into the table -Make query for the animal table data

(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 database server installed

Setup

Clone this repository to your desired folder:

git clone https://github.com/codeWithHyder/vet-clinic-database

cd vet-clinic-database

Create database

-Connect to your PostgreSQL server with psql

psql postgres=# -Create the database vet_clinic postgres=# CREATE DATABASE vet_clinic; -CREATE DATABASE -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.