/vet-clinic

Primary LanguagePLpgSQLMIT LicenseMIT

curriculum-databases-projects-template

This template should be used for database related projects at Microverse. Generate your own repository, update this README and edit all files content while working on projects. You should not be adding any new files unless asked otherwise.

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

📖 [Vet Clinic]

[Vet Clinic] use a relational database to create the data structure for a vet clinic. It started with one table complete with data about:

  • animals
  • animals' owners
  • clinic employees
  • visits

Apart from building data structure, it have SQL queries to answer specific questions about date.

🛠 Built With

Tech Stack

Client
Server
Database

Key Features

  • [The schema.sql contain the query to create the vet_clinic database and the animal table]
  • [The data.sql contain the queries to insert the data]
  • [The queries.sql contains some query examples, transactions and specific queries to answer some questions]

(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 to install the following:

  • PostgreSQL: you can download it from here.
  • Code editor
  • Git: to clone the repo you need to have Git in your machine, here you can see the installation process.

Setup

Clone this repository to your desired folder:

  cd my-folder
  git clone https://github.com/Zven94/vet_clinic

Install

This project don't need any speciall installation

Usage

To run the project, you need to create a new data base and access to it with the following commands in your command line:

  psql
  CREATE DATABASE vet_clinic
  \c vet_clinic

Copy and paste the queries from schema.sql and after the data.sql in that order.

Run tests

To see the whole information in the table run the following command and also copy and pase each query on the queries.sql file to see the differents outpouts:

  SELECT * from animals;

Deployment

This project can't be deployed for any who aren't the owner.

(back to top)

👥 Authors

👤 Nico

👤 Alex

👤 Andy

(back to top)

🔭 Future Features

  • Create animals' owners, clinic employees and visits tables
  • [Query multiple tables]
  • [Add join table for visits]
  • Database performance audit
  • Add database schema diagram

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

(back to top)

🙏 Acknowledgments

I would like to thank...

(back to top)

❓ FAQ

  • [Question_1]

    • [Answer_1]

  • [Question_2]

    • [Answer_2]

(back to top)

📝 License

This project is MIT licensed.

NOTE: we recommend using the MIT license - you can set it up quickly by using templates available on GitHub. You can also use any other license if you wish.

(back to top)