In this assignment, you will be working with the FFK system for staff use that you will be developing. The system requires work in numerous areas, including interaction with the database. Your main task in this assignment is to handle requests for reads and writes to the database using your user interface $($UI$).$ We first describe the main features that the FFK system should include from a UI perspective, and then discuss where the majority of your database code needs to be implemented.

Logging In

The first form a user is presented with, when starting the FFK system is the Login, as shown in Figure $1.$ This feature requires that a staff enters their username and password to be validated prior to being successfully logged in to the system. Security features such as password encryption$/$hashing is out of scope for this assignment. Once logged in$,$ the user is taken to the menu items list page to view their associated menu items.

Viewing Menu Items List

Once a user is logged in$,$ they are shown a list of all their associated menu items, as shown below in Figure $2.$ This list must be ordered such that the most recently reviewed menu items appear at the bottom. The list is also sorted by description in ascending order, and price in descending order. Each menu item has a name, description, category, coffee option $($coffee type, milk kind$),$ price, review date, and reviewer. A menu item is associated with a staff if the staff is assigned as the person in charge of reviewing the menu item.

Finding Menu Items

A user can search through all menu items by entering a word or phrase $($a $$keyword$)$ in the field next to the Find button, as shown in Figure $3,$ and then clicking on Find. When such a keyword is specified, then the retrieved menu items and shown on the list are those that include this word or phrase in the name, description, category, coffee option $($coffee type or milk kind$),$ or reviewer$$s full name. The search is case insensitive. For example, given the search keyword $$fee$,$ Find will return all menu items that include the keyword $$fee$$ in the name, description, category, coffee option $($coffee type or milk kind$),$ or reviewer$$s full name. Searching with a blank$/$empty keyword field will show all of the logged in user$$s associated menu items. Any search results returned must be ordered such that menu items without a reviewer would appear at the top, and then by review date in descending order. The search results must exclude those menu items whose review dates are older than $10$ years $($from today$$s date$).$