1 / 0

Clear Lake Country Club Membership Database Data Flow Diagrams

Clear Lake Country Club Membership Database Data Flow Diagrams. Project Team: Trisha Drumm & Michael Phillips. Business Background. A private country club. 3 types of memberships: Golf, Tennis and Social.

gareth
Download Presentation

Clear Lake Country Club Membership Database Data Flow Diagrams

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. Clear Lake Country ClubMembership DatabaseData Flow Diagrams

    Project Team: Trisha Drumm & Michael Phillips
  2. Business Background A private country club. 3 types of memberships: Golf, Tennis and Social. The Golf membership entitles a person to use all aspects of the club which include the golf course, tennis courts, swimming pool, grille and participation in any club events. The Tennis membership includes all of the above except access to the golf course. The Social membership is one more step down so that it does not allow access to the tennis courts.
  3. Business Background (cont.) Every activity a member does is billed to their account and then invoiced once a month. No cash is exchanged at the time of sale. In addition to the basic membership, there are additional services a member can add as well as many clubs they can join.
  4. Business Requirements It will track whether each member is current or resigned in addition to what their activities were. The invoice will include monthly/annual dues as well as charges for any services used or activities participated in during the past month. It will allow for easy billing to each member on a monthly basis. Have monthly reports Past Due Members Total new and resigned memberships Number of members in each type of membership
  5. ContextDiagram External Entities Accounting Credit Card Processor Management Members Sales Staff
  6. ContextDiagram
  7. Level0DiagramData Processes Validate Login Maintain Member Info Process Fees Process Reports Process Activity DataStores Login Member_Tbl Payment Mem_Activity
  8. Level0Diagram
  9. Level 1 Diagram DataProcess Fees Processes 3.1 Generate Invoice 3.2 Process Payment 3.3 Generate Receipt 3.4 Process Past Due Data Stores Payment
  10. Level 1 DiagramProcess Fees
  11. Level 1 Diagram DataMaintain Member Information Processes 2.1 Process Member Information 2.2 Process Search Information Data Stores Member_Tbl
  12. Level 1 DiagramMaintain Member Information
  13. Level 2 DiagramProcess Member Information Processes 2.1.1 Input Member Information 2.1.2 View Member Information 2.1.3 Update Member Information Data Stores Member_Tbl
  14. Level 2 DiagramProcess Member Information
  15. Questions???
More Related