group project design specification (2ndpresentation) amir khan, dalia blanco, eiko takemoto march...

GROUP PROJECT

Design Specifi cation( 2 n d P R E S E N TAT I O N )

A M I R K H A N, D A L I A B L A N C O, E I K O TA K E M O T O

March 30 , 2010

Insta Wireless

Business Overview

Insta Wireless is a wireless retail store operator in League City, Texas. Insta Wireless provides wireless services including plans, phones and accessories.

Business Need

To upgrade the database systemTo evaluate the worthiness of the

customers by running their credit application.

Point-of-sale system for selling phones and service plans

System Hierarchy

Main Menu

Reports

Sales Reports

Phone ModelZip CodeDemographi

c

New Application

Phone & Service

Payment

Confirmation

Log In

Log In

Purpose: To collect username and password from a user to allow him/her to access to the program.

Main Menu

Purpose: To allow a user to navigate main menu options.

Customer Information Form

Purpose: To evaluate a customer’s credit status

Phone and Service Plan

Purpose: To allow a user to select a phone and a service plan.

Payment screen

Purpose: To allow a user to input payment information and to verify and accept a credit card

Payment screen

Purpose: To view and print the confirmation of payment

Reports

Purpose: To allow a user to select a type of the reports that he/she wish to view

Reports

Reports

Change Password

Purpose: To allow a user to change the password

Database - Business Model

CustomerCustomer ID [Primary]First NameLast NameCompany StreetCityStateZip CodePrimary contactDate of birthTotal monthly incomeTotal monthly debtPINOrder ID

OrderOrder IDDate of orderCustomer IDPhone model IDService plan IDText Plan IDData Plan IDPhone ModelsPhone model IDName of the modelName of the manufacturePrice of the modelPicture of the model

Service PlanService Plan IDService PlanService Plan PriceText Optional PlanText plan IDText planText Plan priceData Optional PlanData plan IDData planData plan priceEntity: PaymentOrder IDPayment typeAmount Paid

Database - Logical Design

Customer Make Order Payment

Service Plan

Phone Model

Database - Physical Design

Customer(CustID, CustFirstName, CustLastName, CustSSN, CustCompany, CustStreet, CustCity, CustState, CustZipCode, CustContact, CustDOB, CustIncome, CustDebt, CustPIN, OrderID)

Order(OrderID, DateOrdered, CustID, PhoneModelID, SvcPlanID, TextPlanID, DataPlanID)

Phone Model(ModelID, ModelName, ModelManufacture, ModelPrice, ModelPic)

Service Plan(SvcPlanID, SvcPlan, SvcPlanPrice)Text Optional Plan(TextPlanID, TextPlan, TextPrice)Data Optional Plan(DataPlanID, DataPlan, DataPlanPrice)Payment(OrderID, PaymentType, AmountPaid)

Database - Implementation

Question?