Process Memo

Process Memo

This memo is intended to explain several attributes used in the DFD describing the Personal Trainer Membership data system.

The primary attributes of the processes for the DFD are as follows:

Membership_ID – this attribute is the primary key for the objects being identified by the membership DBMS. This is also created whenever a membership is created.

Cust_lname / Cust_fname – the names of the customer for the membership

Membership_tier – this identifies a member’s payment tier and determines whether the process creates additional fees for the member.

Payment_stat – Identifies whether the member has paid or is in deficit. If in deficit, the DBMS will prompt the employee to remind the member that their payment is late and request payment.

Street_address / City / State / Zip – these attributes form the member’s address so that invoices and receipts may be forwarded there

Email – this identifies the member’s email address for promotional and billing purposes

Entity Memo

The following memo describes several attributes for the Bumblebee Financial DB entity

Transaction_id – attribute which functions as the index and primary key of the database

Client_name – the name of the client

Accounts_Recievable – financial factor describing outstanding payments from members and other clients

Accounts_Payable – outstanding expenses to be paid

Notes – optional attribute describing transaction (HVAC, roof repair, vending machine maintenance)

Income – the amount of revenue received before expenses

Pre_tax_revenue – post expense earnings before taxes

Tax_rate – variable representing the current tax rate, applied to Pre_tax_revenue

Post_tax_revenue – the actual earnings