Vet Clinic Database

This is a project to practice SQL queries. It is a database for a vet clinic.

The database contains the following tables: animals with the following columns:

id: integer

name: string

date_of_birth: date

escape_attempts: integer

neutered: boolean

weight_kg: decimal

Getting Started

This repository includes files with plain SQL that can be used to recreate a database:

• Used schema.sql to create all tables.
• Used data.sql to populate tables with sample data.
• queries.sql contains 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
  • Setup
  • Prerequisites
  • Install
  • Usage
  • Run tests
  • Deployment
• 👥 Authors
• 🔭 Future Features
• 🤝 Contributing
• ⭐️ Show your support
• 🙏 Acknowledgements
• ❓ FAQ
• 📝 License

📖 Vet Clinic Database

This is a relational database to create the data structure for a vet clinic.

Vet Clinic will have the following tables:

• animals
• animals owners
• clinic employees
• visits

🛠 Built With

Tech Stack

Database

• PostgreSQL

Key Features

• Create tables
• Populate data to the tables
• Make queries to the tables

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

 postgress sql installed in your computer

Setup

Clone this repository to your desired folder:

commands:

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

Usage

To run the project:

  run the queries.sql file in your postgress sql

(back to top)

👥 Author

• GitHub: @Ochiengsteven
• Twitter: @Ochiengsteven
• LinkedIn: Ochieng Steven

(back to top)

🔭 Future Features

• Add animals' owners table
• Add clinic employees table
• Add visits table

(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 give me a ⭐️!

🙏 Acknowledgments

I would like to thank microverse for giving me this opportunity to learn and build this project.

📝 License

This project is MIT licensed.

(back to top)