Medical Database Design

Running a medical business is tough. I operate a small business with my Uncle focusing on first aid resupply. Some things I would have liked to keep track of include customers, inventory, and orders. It's not enought to stay organized; I've also got to be responsive.

My solution? A SQL Database!

SQL databases make my job much smoother by keeping all business information together in a relational stucture. For example, I built a database using MySQL and Oracle's visualization tool, MySQL Workbench, 

You can find on my repository the tables that store mock data such as customer details, product stock levels, order histories, and shipment status. Many medical businesses contract their IT out to a SaaS product or MSp. By making my own database with a front-end for staff, I am let make it possible for entry level employees to learn how to enter orders or update inventory without knowing technical SQL commands.

It's amazing what you can do with technology.