/vet-clinic

curriculum-databases-projects-template

This template should be used for database related projects at Microverse. Generate your own repository, update this README and edit all files content while working on projects. You should not be adding any new files unless asked otherwise.

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]

[Vet Clinic ] is a project designed to contain the data of animals, their species and owners in a database.

🛠 Built With

  • sql

Tech Stack

Describe the tech stack and include only the relevant sections that apply to your project.

Client
Server
Database

Key Features

  • Vet clinic database
  • Animals table
  • Owners Table
  • Species Table

    • (back to top)

    🚀 Live Demo

    • [Live Demo Link] Will be displayed when available

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

    • Have a local version control like git install on your computer
    • Have an account and sign in on GitHub, as online/remote version control system
    • Have a pgAdmin and postgress app installed on your computer

    Setup

    Clone this repository to your desired folder:

    • copy this link.
    • get the directory that you want to clone the repository.
    • open the command prompt in this directory.
    • write git clone git@github.com:Donmark2k/vet-clinic.git
    • go to the repository folder in your command prompt cd vet-clinic

    Install

    Install this project with:

    • Clone the git repo using this command: https://github.com/Donmark2k/vet-clinic.git

    Usage

    To run the project, execute the following command:

    • 1 create vet_clinic database
    • 2 Run Queries.sql
    • 3 to insert data into the table run data.sql
    • 4 execute queries

    Run tests

    No test for this project

    Deployment

    No Deployment for this project

    (back to top)

    👥 Authors

    👤Chukwuemeka Ochuba

    👤 mrprotocoll

    (back to top)

    🔭 Future Features

    Describe 1 - 3 features you will add to the project.

    • [I will query the name in ascending order]
    • [I will add more animals to the table]

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

    • Give me a ⭐️

    (back to top)

    🙏 Acknowledgments

    I would like to appreciate Microverse for providing the resources and the platform for us to be a Professional full-stack developer.

    (back to top)

    ❓ FAQ

    • [If you are asked to perform similar query on a different database, Can you do it?]

      • [yes]

    • [Can you perform inner join]

      • [yes]

    (back to top)

    📝 License

    This project is MIT licensed.

    NOTE: we recommend using the MIT license - you can set it up quickly by using templates available on GitHub. You can also use any other license if you wish.

    (back to top)