/vet_clinic

This repository demonstrated the use of PostgreSQL SQL commands for tasks such as creating a database and table, inserting data into the table, and executing various queries with different parameters.

MIT LicenseMIT

vet_clinic

A relational database used to create the initial data structure for a vet clinic. I created a table to store animals' information, insert some data into it, and query it.

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.

📗 Table of Contents

📖 [Vet Clinic]

Describe your project in 1 or 2 sentences.

[Vet Clinic] is a relational database used to create the initial data structure for a vet clinic. I created a table to store animals' information, insert some data into it, and query it

🛠 Built With

Tech Stack

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

Database

Key Features

Describe between 1-3 key features of the application.

  • Create animal table
  • STore data into table
  • Query data

(back to top)

🚀 Live Demo

Add a link to your deployed project.

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

 gem install rails

Setup

Clone this repository to your desired folder:

  cd my-folder
  git clone git@github.com:Rachelwebdev/vet_clinic.git

Install

Install this project with:

  cd vet_clinic
  gem install

Usage

To run the project, execute the following command:

  rails server

Run tests

To run tests, run the following command:

  bin/rails test test/models/article_test.rb

Deployment

You can deploy this project using:



(back to top)


👥 Authors 


👤 Rachel Isaac



(back to top)


🔭 Future Features 




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




    

  •  Query and Update animals table
    • 

  •  Query multiple tables
    • 

  •  Add "join table" for visits
    • 

  •  Database performance audit
    • 

  •  Add 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 




Write a message to encourage readers to support your project




If you like this project...


(back to top)


🙏 Acknowledgments 


I would like to thank Microverse for the learning materials and technical support provided to work on this project


(back to top)


📝 License 


This project is MIT licensed.


(back to top)