Nelitaa/Vet-clinic-database

In this project, I use a relational database to create the initial data structure for a vet clinic. I have created a table to store animals' information, insert some data into it, and query it.

📗 Table of Contents

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

📖 Vet clinic database

Vet clinic database is a database project, I use a relational database to create the data structure for a vet clinic. I have created a complete database with data about animals, animals' owners, clinic employees, and visits.

Apart from building data structure, I required SQL queries to answer specific questions.

🛠 Built With

Tech Stack

Database

• PostgreSQL

Key Features

• [data_structure]
• [postgresql]
• [queries]

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

 PostgreSQL server
 psql

Setup

Clone this repository to your desired folder:

  cd my-folder
  git@github.com:Nelitaa/Vet-clinic-database.git

Usage

To run the project, execute the following command:

  psql
  CREATE DATABASE vet_clinic
  psql vet_clinic

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

(back to top)

👥 Authors

👤 Marianela Muñoz Gutierrez

• GitHub: @Nelitaa
• Twitter: @MarianelaMunoz_
• LinkedIn: LinkedIn

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

(back to top)

🙏 Acknowledgments

I want to thank Microverse.

(back to top)

📝 License

This project is MIT licensed.

(back to top)