jugosack/med-clinic

From a database diagram, interpret it, and implement the SQL needed to build that database using pair programming

MEDICAL CLINIC DATABASE

📗 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

📖 Medical Clinic Database

In this project, we used a database diagram for a clinic in order to create relational database for a medical clinic. The database has a 6 tables that stores data. Data can be inserted into the table, and the table can be queried as well.

🛠 Built With

Tech Stack

Database

• PostgreSQL

Key Features

• Create a file named schema_based_on_diagram.sql where you implement the database from the diagram.
• Join tables from many-to-many relationships might not appear in the diagram, but you still need them.
• Add the FK indexes.

(back to top)

💻 Getting Started

• Use schema_based_on_diagram.sql to create all tables and indexes on foreign key.

To get a local copy up and running, follow these steps.

Prerequisites

In order to run this project you need:

• To install PostgreSQL

Setup

Clone this repository to your desired folder:

  cd my-folder
  git clone https://github.com/jugosack/med-clinic 

(back to top)

👥 Authors

👤 Jugoslav Achkoski

• GitHub: @github
• LinkedIn: LinkedIn
• Twitter: twitter
• Facebook: facebook

👤 Joshua Lyngdoh

• GitHub: @githubhandle
• Twitter: @twitterhandle
• 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 take the time to give a star, follow us and a feedback, we will appreciate it.

(back to top)

🙏 Acknowledgments

I would like to thank microverse for the great resources shared.

(back to top)

📝 License

This project is MIT licensed.

(back to top)