admirerbrown/vetClinic-sql

VET_CLINIC

VET_CLINIC is a relational database created for the data structure of a vet clinic. it a complete database with data about:

• animals
• animals' owners
• clinic employees
• visits

Getting Started

This repository includes files with plain SQL that can be used to recreate 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. Important note: this file might include queries that make changes in the database (e.g., remove records). Use them responsibly!

📗 Table of Contents

• VET_CLINIC
  • Getting Started
• 📗 Table of Contents
• 📖 [vet_clinic]
  • 🛠 Built With
    • Tech Stack
    • Key Features
  • 🚀 Live Demo
  • 💻 Getting Started
    • Prerequisites
    • Setup
    • Install
    • Usage
    • Run tests
    • Deployment
  • 👥 Author
  • 🔭 Future Features
  • 🤝 Contributing
  • ⭐️ Show your support
  • 🙏 Acknowledgments
  • 📝 License

📖 [vet_clinic]

VET_CLINIC is a relational database created for the data structure of a vet clinic. it a complete database.

[vet_Clinic] is a SQL Project

Schema Diagram

🛠 Built With

Tech Stack

SQL POSTGRES

Key Features

Describe between 1-3 key features of the application.

• [well structured database for an easy data storage]
• [enables users to perform all SQL operations ]
• [lays foundation for building complex clinic databases]

(back to top)

🚀 Live Demo

COMING SOON.

• Live Demo Link

(back to top)

💻 Getting Started

Open GitHub URL of repositry. Download Code repo in zip. Extract and open repo folder into visual studio code or any other Text Editor Software. GitHub Repositry URL: https://github.com/admirerbrown/vetClinic-sql.git

git clone https://github.com/admirerbrown/vetClinic-sql.git

To get a local copy up and running, follow these steps.

Prerequisites

In order to run this project you need:

• Visual Studio Code
• Knowldege About SQL & POSTGRES
• know of how to setup a sql in the terminal
• Git
• Github

Setup

Clone this repository to your desired folder:

Example commands:

  cd my-folder
  git clone https://github.com/admirerbrown/vetClinic-sql.git

Install

• sudo su -l postgres
• psgl

Usage

To run the project, execute the following command:

• \c vet_clinic in terminal to connect to database
• \d animals

Run tests

Deployment

(back to top)

👥 Author

• GitHub: @githubhandle
• Twitter: @twitterhandle
• LinkedIn: LinkedIn

(back to top)

🔭 Future Features

• Include other entities in the database
• build the whole backend for the project
• connect it to a frontend application

(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 please follow me on github and give stars to my repo..

(back to top)

🙏 Acknowledgments

I would like to thanks Microverse for guiding me to complete this project.

(back to top)

📝 License

This project is MIT licensed.

(back to top)