Clinic-database

📗 Table of Contents

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

📖 Clinic-database

The Clinic-database is the relational database for the clinic, which has patients, treatments, medical_histories, invoices, invocie_items, and medical_history_treatment tables. The relationship between the related tables is created using foreign key constraints.

🛠 Built With

• PostgreSQL

Tech Stack

Database

• PostgreSQL

Key Features

• CREATE-DATABSE
• CREATE-TABLE
• FK Indexes

(back to top)

Getting Started

Prerequisites

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

• Use schema_based_on_diagram to create database and all tables.

(back to top)

Setup

Clone this repository to your desired folder:

• git clone https://github.com/MozamelJawad/clinic_db.git

• cd clinic_db

👥 Authors

👤 Mozamel Jawad

• GitHub: @githubhandle
• Twitter: @twitterhandle
• LinkedIn: LinkedIn

👤 Mershark Takyi

• GitHub: @githubhandle
• LinkedIn: Profile link

👤 Young Gaius

• Github: Young-Gaius
• Linkedin: Young-gaius
• Twitter: Young Gaius

(back to top)

🔭Features

• Additional Queries
• Additional Tables

(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 it a star!

(back to top)

🙏 Acknowledgments

• Thanks to the Microverse team for the great curriculum.
• Thanks to the Code Reviewer(s) for the insightful feedback.
• Thanks to our coding partners, the morning session team, and the standup team for their cooperation.

(back to top)

📝 License

This project is MIT licensed.

(back to top)