📗 Table of Contents

• 📗 Table of Contents
• 📖 [vet_clinic]
  • 🛠 Built With
    • Tech Stack
    • Key Features
  • 💻 Getting Started
    • Prerequisites
    • Setup
  • 👥 Authors
  • 🔭 Future Features
  • 🤝 Contributing
  • ⭐️ Show your support
  • 🙏 Acknowledgments
  • 📝 License

📖 [vet_clinic]

[vet_clinic] database is built in PostgresQL using SQL, a special language for managing data. It's a relational database that contains all the information needed to create the data structure for a web application specifically designed for a veterinary clinic.

🛠 Built With

Tech Stack

Database

• PostgreSQL

Key Features

• Animals table for tracking data
• Audit for database performance optimization.
• Visual schema for database structure.

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

To get a local copy up and running, follow these steps.

Prerequisites

In order to run this project you need:

• PostgresQL

Setup

Clone this repository to your desired folder:

  cd your-folder
  git clone https://github.com/Leeoasis/vet-clinic-database.git

(back to top)

👥 Authors

👤 Leslie Gudo

• GitHub: @githubhandle
• Twitter: @twitterhandle
• LinkedIn: LinkedIn

(back to top)

🔭 Future Features

• Search and update animals table
• Retrieve data from multiple tables
• Add "join table" for visits

(back to top)

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to check the [issues page][(https://github.com/Leeoasis/vet-clinic-database/issues)].

(back to top)

⭐️ Show your support

If you like this project give me a ⭐️!

(back to top)

🙏 Acknowledgments

I would like to thank Microverse for this experience

(back to top)

📝 License

This project is MIT licensed.