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

• 📖 About the Project
  • 📷 project screenshot
  • 🛠 Built With
    • Tech Stack
    • Key Features
• 💻 Getting Started
  • Setup
  • Prerequisites
  • Install
  • Usage
  • Run tests
  • Deployment
• 👥 Authors
• 🔭 Future Features
• 🤝 Contributing
• ⭐️ Show your support
• 🙏 Acknowledgements
• 📝 License

📖 Vet Clinic

Vet Clinic is an web App to handle data for a small vet clinic using PostgrSQL relational database...

Project Screenshots

🛠 Built With

Tech Stack

Database

• PostgreSQL

Key Features

Describe between 1-3 key features of the application.

• Store pets basic info
• Store pets escape attempts
• Store pets neutered status

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

• A PostgreSQL instance runing in your PC.

Setup

Clone this repository to your desired folder:

  cd my-folder
  git clone git@github.com:anthonymr/vet-clinic.git

Install

Install this project with:

Run SQL commands in schema.sql and data.sql.

Usage

To run the project, execute the following command:

Run SQL commands in queries.sql to test your database.

Run tests

To run tests, run the following command:

Run SQL commands in queries.sql to test your database.

Deployment

You can deploy this project using:

Run SQL commands in schema.sql and data.sql.

(back to top)

👥 Author

👤 Anthony Martin

• GitHub: Anthony Martin
• LinkedIn: Anthony Martin
• Twitter: Anthony Martin

(back to top)

🔭 Future Features

• Query and update animals table
• Add "join table" for visits
• Database performance audit

(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, start it and share it with your friends.

(back to top)

🙏 Acknowledgments

I would like to thank to Microverse for provide the base idea for this project.

(back to top)

📝 License

This project is MIT licensed.

(back to top)