INTERSTATE Window Door Brand New Windows Database Matthew

INTERSTATE Window & Door Brand New Windows Database Matthew Williams Nicholas Good May 9, 2007

Project Overview n n n Introduction Approach Related Work Demonstration Future Work Conclusion / Questions

General Area n n Thomas Potoski, General Contractor Brand New Windows Greater Wilkes-Barre / Scranton Area Windows Sector

Problems n n Highly Congested Construction Environment Needs to be Near Paperless Portability Inventory Management Order and Customer Searches

Window Attributes n n n Series Style United Inches (UI) Exterior Color Interior Color

More Window Attributes n n Grid Pattern Grid Type Glass Screen

Goals & Objectives n n n Create Close to Paperless Environment Portability Capabilities: n n Managing Inventory (Prices, Color, Styles) Customer Demographics Order Creation Reports

Client Contributions n n n Only 4200 & 6300 Series Grid Pattern / Type Glass Options Interior & Exterior Color Special Shaped Windows Excluded Zip Code Report

Client Contributions Continued n Order Form n n n Customer Info Popup U. I. Column Price

Approach n n n Microsoft Access Database Visual Basic Enhancements Tables Reports Mimic Order Form Paper Version

Related Work Literature Review n n n Microsoft Access – most popular database used in small businesses VBA with SQL as the query language Don’t need to worry about concurrency Semantic Integrity 1 st, 2 nd, 3 rd Normal Form

Overview of System Design (ERD)

Demonstration INTERSTATE Window & Door

Future Work n n Market Software to Other Interstate Windows Contractors Create Training / Reference Booklet Improvements Feature More Database Queries

Conclusion n n Client Training Session Integrate Our Database System into Brand New Windows Business Reduce Amount of Paper in Environment Provide Ongoing Support

Things We’ve Learned n n Client-Developer Communication Adherence to Requirements Document Staying Within Your Capabilities Development Process

Questions n Any questions? INTERSTATE Window & Door