- π About the Project
- π» Getting Started
- Setup
- Prerequisites
- Usage
- π₯ Authors
- π Future Features
- π€ Contributing
- βοΈ Show your support
- π Acknowledgements
- π License
Clinic Data Base is a project where we put in practice the use of PGSQL, by generating an clinic database based on a given Diagram.
[Clinic Data Base] we put into practice PGSQL by creating tables considering the different types of relations, and create join tables needed to generate the many-to-many relation.
Database
- [Use Gitflow]
- [Create a Relational dataBase using PostgreSQL]
- [Create a Table upon given Diagram]
- [Add Join table for treament history]
- [Add many to many relationships]
This repository includes files with plain SQL that can be used to recreate a database.
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/
Clone this repository to your desired folder:
cd my-folder git clone https://github.com/HFG43/clinic_db
To run the project, execute the commands detailed inside:
schema_based_on_diagram.sql to create clinics Data Base & and its tables.
π€ HernΓ‘n GΓΌemes
- GitHub: @githubhandle
- Twitter: @twitterhandle
- LinkedIn: LinkedIn
π€ Andrea Manuel
- GitHub: @AndreaM2429
- Twitter: @AndreaManuelOr1
- LinkedIn: Andrea Manuel
- [Insert data & queries]
Contributions, issues, and feature requests are welcome!
Feel free to check the issues page.
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.
I would like to thank Microverse for providing the necessary resources for this project.
This project is MIT licensed.