PharmaSys
Enterprise Database Management
PharmaSys is a collaborative project aimed at developing a robust database management system (DBMS) tailored to the pharmacy field. Led by Miguel Bravo, Fernanda Carrillo, Manisha Radhakrishna and Likitha Bommasani, our goal is to streamline inventory management, financial tracking, customer service and workflow management. Through meticulous planning and execution, we have designed a system that ensures data integrity, accuracy and consistency. Leveraging AWS, our solution offers scalability and real-time reporting through an intuitive enterprise dashboard. PharmaSys represents our dedication to excellence, learning and innovation in database management, with tangible benefits for any company interested in these goals.
Link To Google Colab ProjectUsed Technologies
- AWS Cloud
- MySQL Workbench
- Google Colab
- LucidChart
- Python: Pandas, PyMySQL, Datapane, Plotly, Numpy