DNA Athletics

1. DNA Athletics Marc Butler Brian Howard

2. Company Information DNA Athletics 779 Normandy Suite 130A Houston, TX 77015 281-300-7222 David Pullen, Partner/Director of Fitness Warren Randle, Partner/Director of Fitness www.dnaathletics.org

3. Services Provided • Personal Training with Certified Personal Trainers • Boot Camps • Nutritional Guidance • Supplement Guidance

4. Plans • Plan A- Monday, Wednesday, Friday- $60.00/week • Plan B- Tuesday and Thursday- $45.00/week • Plan C- One day of your choice - $25.00/week

5. IT Needs • DNA Athletics needs a way to organize: • Client information • Trainer information • Appointments • Billing & Payment information • Services provided to clients

6. Entities • Customer • Trainer • Plans • Services • Appointments • Invoice • Payment

7. Entities & Attributes • Customer - (Customer ID, First Name, Last Name, Home Phone, Cell Phone, Email, Plan ID) • Trainer - (Trainer ID, First Name, Last Name, Home Phone, Cell Phone, Email) • Plans - (Plan ID, Plan Type, Plan Cost) • Services – (Service ID, Service Type, Service Cost) • Appointments - (Date, Time) • Invoice - (Invoice ID, Amount Billed, Date Billed) • Payment - (Payment ID, Amount Paid, Net Balance)

8. Logical Design Customer 1 M Services Invoice M Payments 1 Purchases Generates 1 Makes 1 1 Plan Requires 1 M Trainer Appointments Requires Makes M

9. Physical Design • Customer (Customer ID, First Name, Last Name, Home Phone, Cell Phone, Email, Plan ID) • Trainer (Trainer ID, First Name, Last Name, Home Phone, Cell Phone, Email) • Plans (Plan ID, Plan Type, Plan Cost) • Appointments (Service ID, Customer ID, Trainer ID, Date, Time) • Services (Service ID, Service Type, Service Cost) • Invoice (Invoice ID, AppointmentID, CustomerID, Amount Billed, Date Billed) • Payment (Payment ID, Invoice ID, Amount Paid, Net Balance)