Database

Our group first designed and draw the Enhanced Entity Relationship Diagram (EERD) based on the given scenario description about the restaurant supply exress drone delivery.

Then, we do the relational schema translation and build the physical satabase schema with initial data set in MySQL.

After that, we implemented procedures, supporting views, and, related structures.

Finally, we developed a website application for restaurant owners to manage inventory, orders, and deliveries using Java and React. I mostly contributed to the backend by designing and implementing the MyBatis, POJO, and RESTful API components of the application.