Status Report - GEOCITIES.ws
Download
Report
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?