upa customer and service tracking database application senior design iii – spring 2007 justin...
DESCRIPTION
UPA Technology Manufacture, Recertify, Repair and Sell High Tech Coating Thickness Measuring Equipment Manufacture, Recertify, Repair and Sell High Tech Coating Thickness Measuring Equipment – –Specialized field No Database is Designed for this Field’s Needs –ISO/IEC certified Requires Tracking of CalibrationsTRANSCRIPT
UPA Customer and UPA Customer and Service Tracking Service Tracking
Database ApplicationDatabase ApplicationSenior Design III – Spring Senior Design III – Spring
20072007Justin ShultzJustin Shultz
OverviewOverview UPA TechnologyUPA Technology Project Description and Intended UseProject Description and Intended Use Design ProtocolsDesign Protocols DeliverablesDeliverables DemonstrationDemonstration ConclusionConclusion
UPA TechnologyUPA Technology Manufacture, Recertify, Repair and Manufacture, Recertify, Repair and
Sell High Tech Coating Thickness Sell High Tech Coating Thickness Measuring EquipmentMeasuring Equipment– Specialized field
No Database is Designed for this Field’s Needs
– ISO/IEC 17025 certifiedISO/IEC 17025 certified Requires Tracking of Calibrations
Project Description and Project Description and Intended UseIntended Use
Customer and Service Tracking Database Application (CAST)– Store Customers’ Information, Contacts,
Equipment and Service Records– Track Calibration Cycles
Automatic Reminders– Centralized Database
Design ProtocolsDesign Protocols Visual Studio 2005Visual Studio 2005
– ADO .NETADO .NET– C# .NETC# .NET
SQL Server 2005SQL Server 2005
DeliverablesDeliverables Windows Application To Store Customer Windows Application To Store Customer
Information, Equipment and Services Information, Equipment and Services Advanced SearchAdvanced Search Automatic RemindersAutomatic Reminders Track Customer ServicesTrack Customer Services View Calibration & Repair HistoryView Calibration & Repair History Administrator OptionsAdministrator Options
– Add/Modify UsersAdd/Modify Users– Add/Modify EquipmentAdd/Modify Equipment
Look at the application…Look at the application…
ConclusionConclusion Meets All of UPA’s Database NeedsMeets All of UPA’s Database Needs
– Interface is Simple to Learn & UseInterface is Simple to Learn & Use– Centralized DatabaseCentralized Database– Track Equipment Calibration CyclesTrack Equipment Calibration Cycles– Track Equipment Service HistoriesTrack Equipment Service Histories
Questions?Questions?