PharmaSys

Enterprise Database Management

Goal

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 Project


Used Technologies

  • AWS Cloud
  • MySQL Workbench
  • Google Colab
  • LucidChart
  • Python: Pandas, PyMySQL, Datapane, Plotly, Numpy

Descripción de la imagen

Final Paper

The PDF is not available for this screen size