Vet Clinic

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
  • 🛠 Built With
    • Tech Stack
    • Key Features
  • 🚀 Live Demo
• 💻 Getting Started
  • Prerequisites
    • Setup
  • Usage
  • 👥 Authors
• 🔭 Future Features
• 🤝 Contributing
• ⭐️ Show your support
• 🙏 Acknowledgements
• 📝 License

📖 Vet Clinic

is a database that shows a series of actions and different types of actions that you can perform on a database to obtain different results and different queries to the database.

🛠 Built With

Tech Stack

Database

• PostgreSQL

🛠 Schema Diagram

Schema Diagram

Key Features

• Creating new tables examples
• Adding data examples
• Users can also search by specific information and all the data is going to be displayed according with the request

(back to top)

🚀 Live Demo

• Link comming soon

(back to top)

💻 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! To get a local copy up and running, follow these steps.

Prerequisites

You’ll need to have PostgreSQL on your machine.

Setup

• To clone this repository to your desired folder:

You can download the Zip file from the GitHub repository, or clone the repository with:

• git clone https://github.com/PierreBarba/vet-clinic-pokemonDigimon.git

Access the cloned directory with: cd Vet-clinic-database Open it with your favorite code editor or with the live server Install To recreate the database use the following comand:

• psql -U username -f schema.sql
• psql -U username -f data.sql
• psql -U username -f queries.sql

Usage

To run the project:

• Run the queries in schema.sql to build your databse.
• Run the queries in data.sql to fill your database with data.
• Run your queries.(queries.sql contains some examples)

👥 Authors

👤 Pierre Barba

• LinkedIn: Pierre Barba

(back to top)

🔭 Future Features

• Performance Audit
• Ruby integration

(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 feel free to fork it and give it a star.

(back to top)

🙏 Acknowledgments

I would like to thank Microverse for seting me up on this project.

(back to top)

📝 License

This project is MIT licensed.

(back to top)