Database Systems Final Project Documentation

This post is my Database Systems Final Project Documentation.

Github Link: https://github.com/jasonchristopherchandra/DatabaseSystemsFinalProject/

Members:

  1. Jason Christopher Chandra  210175033
  2. Arkaan Nofarditya Ashadi   2101718425
  3. Farras Yamin                           2101704584

 

Project:

A simple database system for restaurants.

 

Background:

Restaurants. Most are great, but some have either bad food or bad service. We can’t solve the first problem but we can try to solve the second one.

 

Goal:

To create a database system for a restaurant that is so easy to use, it will increase customer service quality.

 

Program Details:

  1. Provide data in an easy to read way for both employees and managers
  2. Allows employees to add and customize orders, get the bill, and add or remove customers.
  3. Allows managers to see all orders, add or remove employees, check the ingredient stocks

 

 

Entity Relationship Diagram

1531114240030

 

Update:

  1. Added Names and Binusian IDs.
  2. Made the program slightly bigger.
  3. Moved button placements.

 

My Contribution:

My contribution to this project is inserting the data using MySQL and the updates using Visual Studio, Arkaan did most of the Visual Studio and Farras designed the ERD and provided over-all support.