Team 8 Capstone Project: Online Musical Instrument Store Andrew Szewczyk Gabriel Chaney Agenda • 1st Status Report – Gabe • Front-end design • Back-end design – Drew • Server Design • Issues With Server • Next Steps Front-End Design • Primary Page Template (HTML & CSS) – Layout – Ascetics • To-do – More cross-browser testing – Need to complete back-end first Back-End Design • Almost 50% complete – Database design implemented – Forms for `instrument` table • Viewing, adding, and deleting • It’s working! Back-End Design • To-do – Image manager for `instrument` table insertions & editing form – `Customer` table forms – Entity relationship forms – Security (employee log-in) – Speed optimizations Server Design • LAMP Progress – Apache working on LAN – Merging HTML design to server using FTP and SSH. – Using a sub domain from dyndns.com. (Free) Issues with Server • • • • Apache works on LAN and not WAN. Need to interface MYSQL with html. Time investment. Some web services violate ISP’s acceptable use policies. • Customer will likely not have the know how to maintain a LAMP system. Next Steps • Make final decision on LAMP. • Complete front and back-end design. • Complete MySQL database design.