Transcript Status Report - GEOCITIES.ws

Brand New Windows Database
Project Status Report
Matthew Williams
Nicholas Good
November 7, 2006
Review




Thomas Potoski, General Contractor
Brand New Windows
Greater Wilkes-Barre / Scranton Area
Windows Sector
Review Continued


We want to create a paperless
environment for our client
Capabilities:




Customer Demographics
Managing inventory (Pricing, Color, Styles)
Order Creation
Reports
Changes Since Proposal

Patio Doors


French / Atrium
Special Shaped
Windows




Picture Windows
Cathedral
Octagon
Trapezoid
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
Client Meeting Results




Sample order form
obtained
Wants to include
patio doors
Size Limitation (UI)
Styles, Model
Numbers, Colors
Client Meeting Results




Window Projection
Measurements
Window Screens
Grid Styles & Colors
Window and Labor
Pricing
Requirements Engineering and
Design Activities

User Interface Prototype





Reports
Add a Customer
Add a New Item
Edit/Delete Existing Item Info
Create Order Form


Exact replica of original order form
Dropdown menus


Ease of use
Semantic Integrity
Implementation Strategies



Microsoft Access
VBA
SQL as the query language
On Schedule?

Done:




Received User Specification
Received Sample Order Form
Received Item Requirements
Next Up:


Create Tables (ERD Diagrams)
Create User Interface
Questions

Any questions?