Transcript final presentation powerpoint

INTERSTATE
Window & Door
Brand New Windows Database
Matthew Williams
Nicholas Good
May 9, 2007
Project Overview






Introduction
Approach
Related Work
Demonstration
Future Work
Conclusion / Questions
General Area




Thomas Potoski, General Contractor
Brand New Windows
Greater Wilkes-Barre / Scranton Area
Windows Sector
Problems




Highly Congested Construction
Environment Needs to be Near
Paperless
Portability
Inventory Management
Order and Customer Searches
Window Attributes





Series
Style
United Inches (UI)
Exterior Color
Interior Color
More Window Attributes




Grid Pattern
Grid Type
Glass
Screen
Goals & Objectives



Create Close to Paperless Environment
Portability
Capabilities:




Managing Inventory (Prices, Color, Styles)
Customer Demographics
Order Creation
Reports
Client Contributions






Only 4200 & 6300 Series
Grid Pattern / Type
Glass Options
Interior & Exterior Color
Special Shaped Windows Excluded
Zip Code Report
Client Contributions Continued

Order Form



Customer Info Popup
U.I. Column
Price
Approach





Microsoft Access Database
Visual Basic Enhancements
Tables
Reports
Mimic Order Form Paper Version
Related Work
Literature Review





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
1st, 2nd, 3rd Normal Form
Overview of System Design
(ERD)
Demonstration
INTERSTATE
Window & Door
Future Work




Market Software to Other Interstate
Windows Contractors
Create Training / Reference Booklet
Improvements
Feature More Database Queries
Conclusion




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




Client-Developer Communication
Adherence to Requirements Document
Staying Within Your Capabilities
Development Process
Questions

Any questions?
INTERSTATE
Window & Door