The site is fully functional but it’s due for a visual refresh. The core of the assignment is Design changes—specifically Layout adjustments, a Color scheme update, and Typography changes—so that every page feels cleaner, more consistent, and on-brand across desktop and mobile. While redesigning, I’ve noticed a couple of lingering bugs in the User interface and the Database. If you can tidy those up in the same pass, that would keep the project streamlined and avoid a separate round of fixes later. Deliverables • Updated layouts rolled out to all existing templates • New colour palette and typography styles implemented in the CSS / theme files • UI glitches resolved and verified in the latest Chrome, Firefox, Edge, and Safari • Database errors (mainly stale queries and incorrect returns) corrected and tested against current data A brief hand-off document or screencast explaining where to tweak colours and fonts in future rounds will wrap things up nicely.