Fast Food Ordering System is an assignment project which I'm currently working on for learning per purposes.
This is a desktop application which developed using Java and Swing for the GUI. Speciality is this system has advanced user interface and user expirience. As well as advanced data validations.
I designed this system for two types of users (Manager and Cashier). Both have different permisions within the system. At the login page the system recognize the user whether a Manager or a Cashier. Only the Managers can register new users. Both users can take orders.
Used MySQL to create the database and normalized as much as possible. There are 10 tables. They are,
- login (user_id (PK), username, password, type, status) //type means manager or cashier, status means active or not
- user (user_id (FK), name, gender, dob (date of birth), phone, email, address)
- customer (customer_id (PK), name, phone, email)
- order (order_id (PK), date, total, recived, balance, user_id (FK), customer_id (FK))
- meal (meal_id (PK), name, unit_price) // Casual meals
- drink (drink_id (PK), name, unit_price) // drinks
- dessert (desser_id (PK), name, unit_price) // desserts
- order_has_meal (order_id (FK), meal_id (FK), qty)
- order_has_drink (order_id (FK), drink_id (FK), qty)
- order_has_dessert (order_id (FK), dessert_id (FK), qty)