Jrmcuervo/vet-clinic-db

Animals Database

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!

Animals Database

📗 Table of Contents

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

📖 [Animals_Database]

[Animals Database] The aim of this project is to create a veterinary clinic's database system. The database consists of various tables that hold data regarding animals, their owners, clinic staff, and appointments. The objective is to develop a robust database structure that allows for effective management and organization of information associated with the clinic's activities and the well-being of its patients.

🛠 Built With

Tech Stack

• PostgreSQL

Database

• PostgreSQL

Key Features

• [Keep track of all the animals in the clinic]
• [Keep track of owner of each animal]
• [Request information from the database]

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

In order to run this project:

The user most install PostgreSQL

Setup

Clone this repository to your desired folder:

git clone https://github.com/Jrmcuervo/vet-clinic-db.git

Install

Install this project with:

On your preferred terminal open PostgreSQL CLI and copy paste the scripts in the following order:

• schema.sql
• data.sql

Usage

Once you have runned the scripts on schema.sql and data.sql you can run the scripts into queries.sql to see queries examples you could use

(back to top)

👥 Authors

👤 Ruben Cuervo

• GitHub: @Jrmcuervom
• Twitter: @Jrmcuervom
• LinkedIn: Jrmcuervom

(back to top)

🔭 Future Features

• [Increase the database]
• [Special cares of each pet]
• [Add new data for each pet]

(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 let me know, click on the star!

(back to top)

🙏 Acknowledgments

I would like to thank all my colleagues who are always willing to contribute!

(back to top)

📝 License

This project is MIT licensed.

(back to top)