Team 8 Capstone Project: Online Musical Instrument Store Andrew Szewczyk Gabriel Chaney

Agenda • 1 st 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.