/Vet_clinic_db

Primary LanguagePLpgSQLMIT LicenseMIT

logo

README

📗 Table of Contents

📖 Vet Clinic

Vet Clinic is a project where I put in practice the use of PGSQL, by generating an animals database.

[Vet Clinic] is a first project usign PGSQL to practice creating Tables, making queries for individual and multiple tables, and to generate a performance audit.

🛠 Built With

Tech Stack

Database

Key Features

  • [Use Gitflow]
  • [Create a Relational dataBase using PostgreSQL]
  • [Create a Table and insert data]
  • [Make different SQL queries]
  • [Use Transaction to ensure safe inserts, updates & deletions]
  • [Use Agregation for SQL queries]
  • [Make queries for multiple tables]
  • [Add Join table for visits]
  • [Add many to many relationships]
  • [Use nested queries]
  • [Performance Audite]

(back to top)

💻 Getting Started

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

Prerequisites

In order to run this project you need to have PostgreSQL installed:

Linux: sudo apt-get install postgresql

Windows: https://www.postgresql.org/download/windows/

Setup

Clone this repository to your desired folder:

cd my-folder git clone https://github.com/HFG43/Vet_clinic_db

Usage

To run the project, execute the following command:

  CREATE DATABASE vet_clinic;

After creating the DataBase use schema.sql to create animals table.

CREATE TABLE table_name(
   column1 datatype,
   columnN datatype
);

Use data.sql to populate tables with sample data.

INSERT INTO animals VALUES (column1, ...columnN);

Check queries.sql for examples of queries that can be run on a newly created database.

SELECT [define column(n) or use * to select all] FROM animals WHERE [CONDITION];

To run tests, run the following command:

No tests available yet.

Deployment

No Deployment available

(back to top)

👥 Authors

👤 Hernán Güemes

👤 Andrea Manuel

(back to top)

🔭 Future Features

  • [Generate a performance audit]

(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 you could clone the repo and work with it or do the changes in a new branch. Also you could let a message with your thoughts.

(back to top)

🙏 Acknowledgments

I would like to thank Microverse for providing the necessary resources for this project.

(back to top)

📝 License

This project is MIT licensed.

(back to top)