Course : ISYS6169 – Database Systems

Lecturer : Nunung Nurul Qomariyah

Team Members :
– Alifio Rasendriya Rasyid | 2201798295
– Nicholas Michael Halim | 2201798761
– Muchsin Hisyam | 2201797430
– Ricky Anderson |2201796636

Description :

Introduction

We are going to make a database program for a bakery owner. We wanted to create this program with the goal of helping this bakery owner in keeping track of their company’s revenue, based on what they sell and the history of what they’re selling.  They can just write them down but it just takes too much time and effort, so why don’t we just help them making this database program to keep them track on their bakery.

Background
Bakery owners usually just sell their items, they don’t know how much they sell that day, this will make them unaware of whether they will be gaining profit or loss. They don’t know how much they sell and what revenue they get.

Solution
We are going to make a database program to help the bakery owner to keep track of their bakery selling revenue. Based on their input which will affect the database searching for the price that has been inputted and adding it into their revenue data while adding that item to the history.

Program Design
The project itself we are using MySQL for the database and for the interface we are using JavaFX. The database are using this ER Diagram as shown below.