( Mind & Body & Spirit)

1. Ultimate Fitness Center (Mind & Body & Spirit) SeemaTomar Chris Robson Suma Surpur

2. Table of contents • Business Requirements • Context Diagram • Level 0 DFD • Level 1 DFD

3. Business Requirements • To establish a computerized system that will replace our current system • To keep records of all business data • Allow new user to register, create their profile and buy membership online. • Allow customers to renew /upgrade their membership. • Allow customers to edit their information. • Allow customers to schedule for classes.

4. Business Requirements • Allow customers to request and view yoga class videos online. • There should be a centralize database and should be accessed from any computer via internet • Personal trainers should be able to see their schedule • Report should be generated to track sales and improve efficiency

5. Context Diagram(UPDATED)

6. Level 0 DFD • External Entities • Customer • Employee • Processes • Employee processing • Personal Trainer processing • Customer processing • Billing • Class schedule processing • Video processing • Feedback processing • Generate Report processing

7. Level 0 DFD • Data Store • D1 Employee data • D2 Trainer data • D3 Membership data • D4 Customer data • D6 Classes data • D9 Feedback data • D10 Billing data

8. Level 0 DFD

9. Level 0 DFD

10. Level 1DFD for process 3(Customer processing) • External Entities • Customer • Processes • Register processing • Log In processing • Edit Information • Upgrade or Renew Membership • Data Store • D3 Membership data • D4 Customer data • D10 Billing data

11. Level 1 DFD

12. Level 1DFD for process 4(Billing) • External Entities • Customer • Processes • Select Billing • Cash Processing • Credit or Debit processing • Data Store • D10 Billing data

13. Level 1 DFD(UPDATED)

14. Level 1DFD for process 8(Generate report processing) • External Entities • Employee • Processes • Select report • Billing report processing • Feedback report processing • Customer report processing • Data Store • D10 Billing data • D4 Customer data • D9 Feedback data

15. Level 1 DFD

16. SYSTEM COMPONENTS Processes 1.0 Employee Processing 2.0 Personal Trainer Processing 3.0 Customer Processing External Entity External Entity 4.0 Billing 5.0 Class Schedule Processing 6.0 Video Processing EMPLOYEE CUSTOMER 7.0 Feedback Processing 8.0 Report Processing D1 Employee Data D2 Trainer Data D3 Membership Data Database D9 Feedback Data D4 Customer Data D6 Classes Data D5 Billing Data

17. STRUCTURE CHART

18. Logical Design- ER Diagram

19. PHYSICAL DESIGN • Membership_Type (Membership_type_code, Membership_type_description, Annual_subscription, Half-yearly_subscription, Quaterly_subscription, Monthly_subscription) • Customer (Customer_id, First_name, Last_name, Email, Home_Phone, Mobile_Phone, Address, City, State, Zip) • Membership_Account ( Membership_id, Customer_id, Membership_type_code, Cust_username, Cust_password, First_joined_date, Status, Renewal_date) • Employee ( Emp_id, Emp_username, Emp_password, First_name, Last_name, Job_title, Email, Home_Phone, Mobile_Phone, Address, City, State, Zip) • Billing(Bill_id, Membership_id, Total_charges, Balance, Bill_due_date, Payment_mode) • Classes (Class_id, Emp_id, Class_room, Class_day, Class_time) • Member_Classes(Membership_id, Class_id) • Feedback (Feedback_id, Customer_id, Feedback_description) • Personal_trainer_sessions (Session_id, Membership_id, Emp_id, Session_day, Session_time)

20. LOGIN PAGE

21. CUSTOMER REGISTRATION PAGE