Vet Clinic Postgresql

📗 Table of Contents

• 📖 About the Project
  • 🛠 Built With
    • Tech Stack
    • Key Features
  • 🚀 Database Diagram
• 💻 Getting Started
  • Setup
  • Prerequisites
  • Install
  • Usage
  • Deployment
• 👥 Authors
• 🔭 Future Features
• 🤝 Contributing
• ⭐️ Show your support
• 🙏 Acknowledgements
• ❓ FAQ
• 📝 License

📖 Vet Clinic Postgresql

A veterinary clinic database is a relational database designed to manage and store information related to the operation of a veterinary clinic. User can use the project query to create, read, update and delete specific data fromm the database using sql terminal, enabling efficient management and analysis of clinic data.

Entity Relational Diagram

🛠 Built With

Tech Stack

Client

• SQL

Server

• Local port server

Database

• PostgresQL

Key Features

• The user can create, inset and query the database table using this project.
• Efficient Data Management

(back to top)

🚀 Live Demo

Not available

(back to top)

💻 Getting Started

Prerequisites

In order to run this project you need:

• Installed Git.
• Installed PostgreSQL
• Create a local directory that you want to clone the repository.
• Open the command prompt in the created directory.
• On the terminal run this command git clone https://github.com/Eric2umeh/vet_clinic_postgresql.git

Setup

Clone this repository to your desired folder:

git clone https://github.com/Eric2umeh/vet_clinic_postgresql.git

cd vet_clinic_postgresql

Usage

• Create a new database then open a sql editor or sql ternimal then your can use below SQL language to read and update your database with multiple tables.
• 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)

👥 Author

👤 Eric Umeohabike:

• GitHub: @Eric2umeh
• Twitter: @King_Eric_
• LinkedIn: @Eric Umeohabike

🔭 Future Features

• Add more query to manage the database.
• Integrate back-end.

(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 liked this project, give it a ⭐️.

(back to top)

🙏 Acknowledgments

I would like to thank Postgresql & Microverse team for this journey.

(back to top)

📝 License

This project is MIT licensed.

(back to top)