The task is to write a web based form to input restaurant menu data into a mySQL database for restaurant menus. The user should be able to enter menus, and modify existing entries.
The database already exists, so all that is required is to write the data entry forms.
This is not to be client facing, so look and feel is not particularly important. Usability and low cost are key. To enable the freedom to get the job done quickly they can design the interface, but I can also provide a design or guidelines if that is preferred.
The database is a mySQL database, using the InnoDB engine.
It should work with the latest Chrome and Firefox browsers.
An entity relationship diagram is attached as a png image, and the following description refers to that.
A vendor has many menu groups. A menu group has many menu items. A menu item has up to three cost options.
A vendor has many delivery suburbs, but it's unlikely there will be more than 12 delivery suburbs, so such a limit would be acceptable if necessary.
The following tables will be prepopulated, and the form will use the existing data from those tables:
There will be a reasonably small number of genres, so when selecting the genre (lhdm_vendor.style) to attach to the vendor table it could be selected using a select box.
There will be over 15000 suburbs, so the selection for the location suburb (lhdm_vendor.suburb) and delivery suburbs (lhdm_vendor_delivery_suburb) to associate with the vendor entry should be using auto-complete fields.
The following can be provided to aid in development:
- The create SQL for the database
- example data
- population scripts for the suburb and genre tables
- A partially functioning mockup of what is required