Newtayo/Vet-clinic

VET-CLINIC

Getting Started

This repository is contains SQL Commands used in the creation of Vet-clinic database as well as all the tables inside the database.

• All codes used in the creation of the database as well as the tables are stored at schema.sql file.
• All data and the commands used to populat data.sql file.
• The vet_clinic database can be queried for various information. Sample codes on how to query the various tables in the database are located in the queries.sql file.

📗 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
• 📝 License

📖 VET-CLINIC

VET-CLINIC is a relational database built using POSTGRES, to store information about animals. Information can be queried from the database using SQL Commands

🛠 Built With PostgreSQL

Tech Stack

This project does not have a client or server part. It only has a database

Database

• PostgreSQL

Key Features

• Insert to the database
• query data from the database
• Modify information in the database

(back to top)

🚀 Live Demo

Link to deployed project.

• Live Demo Link Not Available

(back to top)

💻 Getting Started

Describe how a new developer could make use of your project.

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

Prerequisites

In order to run this project you need:

• Ensure you have a github account and you are signed in.

• Ensure you have PostgreSQL installed on your machine.

Setup

Clone this repository to your desired folder:

• On git bash Run git clone https://github.com/Newtayo/Vet-clinic.git

• Cd to the folder you cloned the repository to.

Install

No installation is required

Usage

To run the project, execute the following command in the schema.sql, data.sql and query.sql files

Run tests

Test is not available at this moment

Deployment

No deployment is available yet

(back to top)

👥 Authors

👤 Author1

• GitHub: @Newtayo
• Twitter: @Omortayoh
• LinkedIn: Akande Abdulwasiu

(back to top)

🔭 Future Features

• Perform normalization on the database
• Create the database schema diagram

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

(back to top)

🙏 Acknowledgments

Give credit to everyone who inspired your codebase.

I would like to thank microverse for providing this wonderful platform for learning

(back to top)

❓ FAQ

Add at least 2 questions new developers would ask when they decide to use your project.

• [Question_1] How can I view this database

  • [Answer_1] You need to Install Postgress on your computer

• **[Question_2]**Where can I download postgress software

  • [Answer_2] Head to https://www.postgresql.org official website and follow the prompt to get the appropriate version for your machine

(back to top)

📝 License

This project is MIT licensed.

(back to top)