1 / 8

CAEN Customer Service Request (CSR) Database

CAEN Customer Service Request (CSR) Database. Final Project Report SI654: Database Application Design April 2004 Dino Anastasia, Marla Gómez. Presentation Overview. CAEN Service Center Database Design Demo/Walk-through Future of the Database Summary. CAEN Service Center (CSC).

santos
Download Presentation

CAEN Customer Service Request (CSR) Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CAEN Customer Service Request (CSR) Database Final Project Report SI654: Database Application Design April 2004 Dino Anastasia, Marla Gómez

  2. Presentation Overview • CAEN Service Center • Database Design • Demo/Walk-through • Future of the Database • Summary April 2004

  3. CAEN Service Center (CSC) • On-campus computer repair facility • Convenient computer and laser printer repair for University departments, students, and employees • Fully authorized warranty repair facility for Macintosh, Dell, and Gateway • Also perform non-warranty repairs for the these brands and other brands • Located in 1404 Media Union April 2004

  4. Database & Application Design • 12 tables • All connect to the repair or repair_activity table • Web application code uses PHP, mySQL, and HTML April 2004

  5. April 2004

  6. Demo/Walk-through • Welcome & Login • Customer Receipt • Repair Log • Repair Activity Reports • Go to DEMO April 2004

  7. Future • The Ideal: wrap the database into CoE/CAEN’s existing Oracle structure • DFE this summer: develop the database using JSP, Oracle and Zope content management system. Tasks: - gather feedback for functionality from staff - develop an information architecture for the web application - create the database tables in Oracle - code web pages using JSP - conduct usability testing of the completed pages - incorporate user feedback and results from usability tests April 2004

  8. Summary • The CAEN CSC has a functional, database-driven web application for tracking repairs. • Learned how to correctly design a database for efficiency and flexibility. • Starting a project from scratch is much easier than changing an existing database and application! April 2004

More Related