1 / 16

Robert Bell Anthony Helms Amanda Hollingsworth Seth Johnson Tiffany Pike Andrew Withem

Robert Bell Anthony Helms Amanda Hollingsworth Seth Johnson Tiffany Pike Andrew Withem. Agenda. Entity Relationship Diagrams Logical Database Design Use Cases Data Flow Diagrams. Entity Relationship Diagram. Logical Database Design. Employee Management. Stimulus/Response Sequences

tucker
Download Presentation

Robert Bell Anthony Helms Amanda Hollingsworth Seth Johnson Tiffany Pike Andrew Withem

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Robert Bell Anthony Helms Amanda Hollingsworth Seth Johnson Tiffany Pike Andrew Withem

  2. Agenda • Entity Relationship Diagrams • Logical Database Design • Use Cases • Data Flow Diagrams

  3. Entity Relationship Diagram

  4. Logical Database Design

  5. Employee Management Stimulus/Response Sequences Stimulus: Employee arrives at work or is leaving work Response: Employee clocks in or clocks out Stimulus: Employee pay period ends Response: Payroll is calculated and employee receives compensation Stimulus: Prospective employee applies or current employee breaks policies Response: Applicant is considered for employment or employee is terminated Functional Requirements REQ-1: Record and store employee hours worked REQ-2: Calculate total pay per employee per pay period REQ-3: Send check to employees bank account REQ-4: Enter new employee information into database REQ-5: Label employee as terminated and delete after given period of time REQ-6: Send quarterly reports and deposits to IRS

  6. Client Management Stimulus/Response Sequences Stimulus: Prospective client applies for membership Response: New client is entered into system Stimulus: Prospective client becomes a new client Response: Membership ID card is made and issued Stimulus: Client arrives at front desk with ID card Response: Card is validated and entry is granted Stimulus: Client membership is found invalid Response: Client pays fee and status is renewed Stimulus: Client membership is ending soon Response: Notification is sent to client regarding membership renewal Stimulus: Client membership card is swiped Response: Time of entry is logged and stored Stimulus: Time of entry for client is compiled Response: Promotions or offers are sent to client Functional Requirements REQ-1: Store and update client information REQ-2: Read membership card and relate it to client information REQ-3: Create a working and reliable identification card REQ-4: Notify clients when changes to their membership will occur REQ-5: Send out special offers and promotions to clients REQ-6: Log and store client check-in times

  7. Online Community for Clients Stimulus/Response Sequences Stimulus: Client wants to join online community Response: Client registers on the web page and gains access Stimulus: Client desires to access forum by logging in Response: Client is granted access to all features of the forum Stimulus: Client wishes to communicate through forum posts Response: Clients comments or thoughts are displayed on webpage Functional Requirements REQ-1: Store and update client information REQ-2: Grant access to registered clients only REQ-3: Allow interaction among members REQ-4: Grant access to affiliated trainers and nutritionists REQ-5: Be user friendly and allow easy navigation REQ-6: Allow clients and trainers/nutritionists to submit posts

  8. Context Diagram

  9. Level 0

  10. Level 1- Forum

  11. Level 1 – Manage Payroll

  12. Level 1 – Manage Membership

  13. Level 2 – Manage Membership

  14. Level 3 – Manage Membership

  15. Level 4 – Manage Membership

  16. Summary • Entity Relationship Diagrams • Logical Database Design • Use Cases • Data Flow Diagrams

More Related