iteration 5 louisville business analysits · pdf file · 2016-03-16system email...

ITERATION5

LOUISVILLEBUSINESSANALYSITS

TABLEOFCONTENTS

BradleyErickson

DeshanGardner

ChrisJames

SpencerKerber

TABLEOFCONTENTS

Contents

ClassDiagram____________________________________________________________________________________________ 1

DataDictionary __________________________________________________________________________________________ 2

Student____________________________________________________________________________________________________ 3

Donor_____________________________________________________________________________________________________ 4

Volunteer_________________________________________________________________________________________________ 5

Teacher ___________________________________________________________________________________________________ 6

Administrator____________________________________________________________________________________________ 7

User_______________________________________________________________________________________________________ 8

Session____________________________________________________________________________________________________ 9

Course ___________________________________________________________________________________________________10

Event_____________________________________________________________________________________________________11

Donation_________________________________________________________________________________________________12

Photo_____________________________________________________________________________________________________13

GrantReport_____________________________________________________________________________________________14

Survey____________________________________________________________________________________________________15

StripePayment__________________________________________________________________________________________16

WindowsNavigationDiagrams________________________________________________________________________17

PhysicalArchitectureDesign___________________________________________________________________________18

DesignProceduresforSecurity________________________________________________________________________19

GanttChart______________________________________________________________________________________________20

Prototypes_______________________________________________________________________________________________21

MainPage________________________________________________________________________________________________22

ViewClasses/EventsPage______________________________________________________________________________23

ViewClass/Event _______________________________________________________________________________________24

RegisterforClass/Eventpage__________________________________________________________________________25

Donatepage_____________________________________________________________________________________________26

TABLEOFCONTENTS

DonationSuccessfulPage______________________________________________________________________________27

LOLALoversLandingPage_____________________________________________________________________________28

VolunteerLoginPage___________________________________________________________________________________29

VolunteerViewEventPage_____________________________________________________________________________30

VolunteerRegistrationPage____________________________________________________________________________31

ModifyVolunteerAccountPage________________________________________________________________________32

AdminLoginPage_______________________________________________________________________________________33

AdminDashboardPage_________________________________________________________________________________34

GrantReportPage_______________________________________________________________________________________35

CreateAdminAccountPage____________________________________________________________________________36

ViewAllAccountsPage_________________________________________________________________________________37

ViewAllClasses/Eventspage__________________________________________________________________________38

AddVolunteerPage_____________________________________________________________________________________39

AddTeacherpage_______________________________________________________________________________________40

ModifyAdminAccountPage___________________________________________________________________________41

CreateEventPage_______________________________________________________________________________________42

EditEventPage__________________________________________________________________________________________43

LoginTeacherPage_____________________________________________________________________________________44

TeacherLandingPage __________________________________________________________________________________45

ModifyTeacherPage____________________________________________________________________________________46

PurchaseEventTicketPage____________________________________________________________________________47

LOUISVILLEBUSINESSANALYSTS

Page1

ClassDiagram

HOWTOREADTHEUSECLASSDIAGRAMTheclassdiagramdisplayshoweachuserandactioninteractswitheachotheronalargescale.

LOUISVILLEBUSINESSANALYSTS

Page2

DataDictionary

HOWTOREADTHEUSEDATADICTIONARYThedatadictionarydisplaysallthedifferentformsofdatathatthewebsitewillgenerateandusedtofunction.Eachdataentryhasadescription.Eachentryalsoholdssubentriescontainingdetailsaboutitselfandthesizeandtypeofdatathateachsubentryis.

USERAllthedifferenttypesofusersofthewebsite,includingstudents,donors,volunteers,teachers,andadministratorswillallbegeneratedfromanabstractuserclasswhichhasbasicattributesthataresharedamongallthedifferentuserclasses.

SESSIONThetwodifferenttypesofsessions,coursesandevents,willbegeneratedfromanabstractsessionclass.Thissessionclasshasthecommonattributesthatthecourseandeventclassesshare.

LOUISVILLEBUSINESSANALYSTS

Page3

Student

EntityName

EntityDescription ColumnName

ColumnDescription DataType

Length

Student Auserwhoisenrollingincourses

studentID Uniqueidentificationnumber integer 10

firstName Firstnameofstudent string 25

lastName Lastnameofstudent string 25

email Emailaddressofstudent(alsoservesaslogin)

string 25

password Passwordforaccountlogin string 15

address Addressofstudent string 25

city Cityofstudent string 25

state Stateofstudent string 2

zip Zipcodeofstudent integer 5

phone Phonenumberofstudent string 12

LOUISVILLEBUSINESSANALYSTS

Page4

Donor

EntityName

EntityDescription ColumnName

ColumnDescription DataType

Length

Donor AuserisdonatingtoLOLA

donorID Uniqueidentificationnumber integer 10

firstName Firstnameofdonor string 25

lastName Lastnameofdonor string 25

email Emailaddressofdonor(alsoservesaslogin)

string 25

password Passwordforaccountlogin string 15

address Addressofdonor string 25

city Cityofdonor string 25

state Stateofdonor string 2

zip Zipcodeofdonor integer 5

phone Phonenumberofdonor string 12

LOUISVILLEBUSINESSANALYSTS

Page5

Volunteer

EntityName

EntityDescription

ColumnName

ColumnDescription DataType

Length

Volunteer AuserisvolunteeringforLOLA

volunteerID Uniqueidentificationnumber

integer 10

firstName Firstnameofvolunteer string 25

lastName Lastnameofvolunteer string 25

email Emailaddressofvolunteer(alsoservesaslogin)

string 25

password Passwordforaccountlogin

string 15

address Addressofvolunteer string 25

city Cityofvolunteer string 25

state Stateofvolunteer string 2

zip Zipcodeofvolunteer integer 5

phone Phonenumberofvolunteer

string 12

LOUISVILLEBUSINESSANALYSTS

Page6

Teacher

EntityName

EntityDescription ColumnName

ColumnDescription DataType

Length

Teacher AuserwhoisteachingcoursesatLOLA

teacherID Uniqueidentificationnumber

integer 10

firstName Firstnameofteacher string 25

lastName Lastnameofteacher string 25

email Emailaddressofteacher(alsoservesaslogin)

string 25

password Passwordforaccountlogin string 15

address Addressofteacher string 25

city Cityofteacher string 25

state Stateofteacher string 2

zip Zipcodeofteacher integer 5

phone Phonenumberofteacher string 12

LOUISVILLEBUSINESSANALYSTS

Page7

Administrator

EntityName

EntityDescription ColumnName ColumnDescription DataType

Length

Admin Personwithadministratoraccountandprivileges

adminID Uniqueidentificationnumber

integer 10

firstName Firstnameofadministrator

string 15

lastName Lastnameofadministrator

string 20

email Email/usernameofadministrator

string 25

password Passwordforadministratoraccount

string 15

LOUISVILLEBUSINESSANALYSTS

Page8

User

EntityName

EntityDescription

ColumnName ColumnDescription

DataType Length

User Abstractclasscontainingalluserclasses

userID Uniqueidentificationnumber

integer 10

firstName Firstnameofuser string 20

lastName Lastnameofuser string 20

email Emailaddress/usernameofuser

string 25

password Passwordrelatedtouseraccount

string 10

userType Typeofuseraccount(admin,student,teacher,donor,volunteer)

string 20

LOUISVILLEBUSINESSANALYSTS

Page9

Session

EntityName

EntityDescription ColumnName ColumnDescription

DataType

Length

Session AbstractclassforaneventorcourseLOLAishosting

sessionID Uniqueidentificationnumber

integer 10

sessionName Nameoftheevent string 25

sessionDescription Descriptionoftheevent

string 500

sessionSDate Dateoftheevent string 25

sessionEDate Enddateofsession string 25

sessionSTime Starttimeofsession

string 10

sessionETime Endtimeofsession string 10

sessionPrice Priceofsession Decimal 4

sessionSeats Seatsavailableforsession

Int 3

LOUISVILLEBUSINESSANALYSTS

Page10

Course

EntityName

EntityDescription ColumnName ColumnDescription DataType

Length

Course AcourseofferedtostudentsatLOLA

courseID Uniqueidentificationnumber

integer 10

courseName Nameofthecourse string 25

courseDescription Descriptionofthecourse string 500

courseSDate Startdateofthecourse string 10

courseEDate Enddateofthecourse string 10

courseSTime Starttimeofthecourse string 10

courseETime Endtimeofthecourse string 10

coursePrice Priceofenrollmentofcourse

integer 3

courseSeats Numberofseatsavailableincourse

Integer 2

teacherID TeacherIDofrelatedteacher

Integer 10

LOUISVILLEBUSINESSANALYSTS

Page11

Event

EntityName

EntityDescription ColumnName ColumnDescription DataType

Length

Event AneventwhichLOLAhostsandsellsticketsfor

eventID Uniqueidentificationnumber

integer 10

eventName Nameoftheevent string 25

eventDescription Descriptionoftheevent

string 500

eventDate Dateoftheevent string 25

eventSTime Starttimeoftheevent string 10

eventETime Endtimeoftheevent string 10

eventPrice Priceofticketsfortheevent

string 10

eventSeats Numberofseatsavailableforevent

integer 3

LOUISVILLEBUSINESSANALYSTS

Page12

Donation

EntityName

EntityDescription

ColumnName ColumnDescription

DataType

Length

Donation Amonetarydonationmadebyadonorwithaccount

donationID Uniqueidentificationnumber

integer 10

donationAmount Amountofdonation

Decimal 7

donationStatus Statusofdonation(eitherone-timeorrecurring)

int 1

donationSDate Startdateofrecurringdonation

string 10

Duration Durationofrecurringdonation

Int 3

donationRecursion Numberoftimesthedonationwillreoccurindesiredperiod

Int 2

donationRecursionType Periodofdonationrecursion(monthly,quarterly,semi-annually,annually)

String 20

donorID DonorIDofrelateddonor

Int 10

LOUISVILLEBUSINESSANALYSTS

Page13

Photo

EntityName

EntityDescription

ColumnName ColumnDescription

DataType

Length

Photo AphotouploadedtoLOLA'swebsite

photoID Uniqueidentificationnumber

integer 10

photoName Nameofthephoto string 25

photoDescription Descriptionofthephoto

string 500

sessionID SessionIDofrelatedcourseorevent

Int 10

addedBy Nameofadminwhouploadedphoto

string 20

dateAdded Datewhenphotowasuploaded

string 10

LOUISVILLEBUSINESSANALYSTS

Page14

GrantReport

EntityName

EntityDescription

ColumnName ColumnDescription

DataType Length

GrantReport

AgrantreportgeneratedbyLOLAadmin

donorData Donortablecontainingdatarelatedtodonorsanddonations

.xml

studentData Stdenttablecontainingdatarelatedtostudentsandclasses

.xml

eventData Eventtablecontainingdatarelatedtoeventsandticketsales

.xml

LOUISVILLEBUSINESSANALYSTS

Page15

Survey

EntityName

EntityDescription ColumnName

ColumnDescription DataType

Length

Survey AsurveycompletedbyLOLAuser

surveyID Uniqueidentificationnumber

integer 10

userID IDofusercompletingsuvey

Int 10

survey Surveycreatedbyuser string 1000

sessionID IDofsessionsurveyed Int 10

date Dateofsurvey string 15

LOUISVILLEBUSINESSANALYSTS

Page16

StripePayment

EntityName

EntityDescription

ColumnName ColumnDescription

DataType

Length

StripePayment

PaymentmadetoLOLAusingStripePaymentSystem

Email Emailaddressofusermakingpayment

String 20

cardNumber Cardnumberofcardmakingpayment

Int 20

expDate Expirationdateofrelatedcard

Int 4

cvc CVCcodeofrelatedcard

Int 5

paymentType Typeofpayment(donation,tuition,ticketpurchase)

string 20

LOUISVILLEBUSINESSANALYSTS

Page17

WindowsNavigationDiagrams

AWindowsNavigationDiagramshowshowthesystemislaidoutstartingwiththelandingpage,whichinthiscasewouldbethehomepageofthesite.Itdisplaysthebuttonsorlinksthatareneededtobeclickedtonavigatetothenextscreen.Thelinesshowhowonescreenareconnectedtoanother.ThemainlinksfromthehomepageareClasses/Eventslandingpage,DonationLandingPage,andtheLOLALoversLandingpage.TheLOLALoversLandingpageiswhereteachers,volunteersandAdminswillgotogotologintogettomorefunctionality.

LOUISVILLEBUSINESSANALYSTS

Page18

PhysicalArchitectureDesign

LOUISVILLEBUSINESSANALYSTS

Page19

DesignProceduresforSecurity

OURSECURITYAsmentionedinthenonfunctionalrequirements,thestaffwillhaveaccestothesystemthroughanywebbrowser.Theuserwillhavetoauthenticateanemployeeusernameandpasswordeverytimetheylogintothesystemregardlessofbrowser.

Students

Studentswillneedtoprovidebothusernameandpasswordforverificationwhenloggingintotheiraccount.

Donors

Donorswillneedtoprovidebothusernameandpasswordforverificationwhenloggingintotheiraccount.

Teachers

Teacherswillneedtoprovidebothusernameandpasswordforverificationwhenloggingintotheiraccount.

Volunteers

Volunteerswillneedtoprovidebothusernameandpasswordforverificationwhenloggingintotheiraccount.

Administrators

Administratorswillneedtoprovidebothusernameandpasswordforverificationwhenloggingintotheiraccount.

ASMALLORANGESECURITYTheonlinedatabaseandbackupsoftwareweplantoincorporateproves24/7/365monitoringandprovidesalertsforanynetworkupdatethatcouldaffectyourservice

LOUISVILLEBUSINESSANALYSTS

Page20

11-Feb 23-Feb 7-Mar 19-Mar 31-Mar 12-Apr 24-Apr 6-May

0-UseCaseDescription-SeshanGardner

1-UseCaseDiagram-BradleyErickson

2-UseCaseHTMLPrototype- SpencerKerber

3-ClassDiagram-SpencerKerber

4-DatabaseDesign-DeshanGardner

5-DataDefinitions- SpencerKerber

6-UIandwindowsnavigationdiagram-ChristopherJames

7-Prototypes-ChristopherJames

8-PhysicalArchitectureDesign- SpencerKerber

9- DesignProceduresforsecurityconcernsandnon-functionalrequirements- DeshanGardner

10- ElaborationPahseprototype-ChristopherJames

11- GnattChart- BradleyErickson

GanttChart

LOUISVILLEBUSINESSANALYSTS

Page21

Prototypes

LOUISVILLEBUSINESSANALYSTS

Page22

MainPage

LOUISVILLEBUSINESSANALYSTS

Page23

ViewClasses/EventsPage

LOUISVILLEBUSINESSANALYSTS

Page24

ViewClass/Event

LOUISVILLEBUSINESSANALYSTS

Page25

RegisterforClass/Eventpage

LOUISVILLEBUSINESSANALYSTS

Page26

Donatepage

LOUISVILLEBUSINESSANALYSTS

Page27

DonationSuccessfulPage

LOUISVILLEBUSINESSANALYSTS

Page28

LOLALoversLandingPage

LOUISVILLEBUSINESSANALYSTS

Page29

VolunteerLoginPage

LOUISVILLEBUSINESSANALYSTS

Page30

VolunteerViewEventPage

LOUISVILLEBUSINESSANALYSTS

Page31

VolunteerRegistrationPage

LOUISVILLEBUSINESSANALYSTS

Page32

ModifyVolunteerAccountPage

LOUISVILLEBUSINESSANALYSTS

Page33

AdminLoginPage

LOUISVILLEBUSINESSANALYSTS

Page34

AdminDashboardPage

LOUISVILLEBUSINESSANALYSTS

Page35

GrantReportPage

LOUISVILLEBUSINESSANALYSTS

Page36

CreateAdminAccountPage

LOUISVILLEBUSINESSANALYSTS

Page37

ViewAllAccountsPage

LOUISVILLEBUSINESSANALYSTS

Page38

ViewAllClasses/Eventspage

LOUISVILLEBUSINESSANALYSTS

Page39

AddVolunteerPage

LOUISVILLEBUSINESSANALYSTS

Page40

AddTeacherpage

LOUISVILLEBUSINESSANALYSTS

Page41

ModifyAdminAccountPage

LOUISVILLEBUSINESSANALYSTS

Page42

CreateEventPage

LOUISVILLEBUSINESSANALYSTS

Page43

EditEventPage

LOUISVILLEBUSINESSANALYSTS

Page44

LoginTeacherPage

LOUISVILLEBUSINESSANALYSTS

Page45

TeacherLandingPage

LOUISVILLEBUSINESSANALYSTS

Page46

ModifyTeacherPage

LOUISVILLEBUSINESSANALYSTS

Page47

PurchaseEventTicketPage