Robert BellAnthony Helms
Amanda HollingsworthSeth JohnsonTiffany Pike
Andrew Withem
Agenda
• Entity Relationship Diagrams• Logical Database Design• Use Cases• Data Flow Diagrams
Entity Relationship Diagram
Logical Database Design
Employee ManagementStimulus/Response Sequences
Stimulus: Employee arrives at work or is leaving workResponse: Employee clocks in or clocks out
Stimulus: Employee pay period endsResponse: Payroll is calculated and employee receives compensation
Stimulus: Prospective employee applies or current employee breaks policiesResponse: Applicant is considered for employment or employee is terminated
Functional RequirementsREQ-1: Record and store employee hours workedREQ-2: Calculate total pay per employee per pay periodREQ-3: Send check to employees bank accountREQ-4: Enter new employee information into databaseREQ-5: Label employee as terminated and delete after given period of timeREQ-6: Send quarterly reports and deposits to IRS
Client ManagementStimulus/Response Sequences
Stimulus: Prospective client applies for membershipResponse: New client is entered into system
Stimulus: Prospective client becomes a new clientResponse: Membership ID card is made and issued Stimulus: Client arrives at front desk with ID cardResponse: Card is validated and entry is granted Stimulus: Client membership is found invalidResponse: Client pays fee and status is renewed Stimulus: Client membership is ending soonResponse: Notification is sent to client regarding membership renewal Stimulus: Client membership card is swipedResponse: Time of entry is logged and stored
Stimulus: Time of entry for client is compiledResponse: Promotions or offers are sent to client
Functional RequirementsREQ-1: Store and update client informationREQ-2: Read membership card and relate it to client informationREQ-3: Create a working and reliable identification cardREQ-4: Notify clients when changes to their membership will occurREQ-5: Send out special offers and promotions to clientsREQ-6: Log and store client check-in times
Online Community for ClientsStimulus/Response Sequences
Stimulus: Client wants to join online communityResponse: Client registers on the web page and gains access
Stimulus: Client desires to access forum by logging inResponse: Client is granted access to all features of the forum
Stimulus: Client wishes to communicate through forum postsResponse: Clients comments or thoughts are displayed on webpage
Functional Requirements
REQ-1: Store and update client informationREQ-2: Grant access to registered clients onlyREQ-3: Allow interaction among members REQ-4: Grant access to affiliated trainers and nutritionistsREQ-5: Be user friendly and allow easy navigationREQ-6: Allow clients and trainers/nutritionists to submit posts
Context Diagram
Level 0
Level 1- Forum
Level 1 – Manage Payroll
Level 1 – Manage Membership
Level 2 – Manage Membership
Level 3 – Manage Membership
Level 4 – Manage Membership
Summary
• Entity Relationship Diagrams• Logical Database Design• Use Cases• Data Flow Diagrams