Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Fighter_University_Membership PowerPoint Presentation
Download Presentation
Fighter_University_Membership

Fighter_University_Membership

97 Views Download Presentation
Download Presentation

Fighter_University_Membership

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Fighter_University_Membership Membership_Type Member_Fighter Member_Coach/Trainer Member_Fan Member_Promotor Member_Gym

  2. Membership Type Member_Fighter Martial Art Muay Thai MMA Boxing Kickboxing All other Arts Wrestling BJJ

  3. Martial Art Style Muay Thai Wins DQ No_Contest Losses Draws

  4. Martial Art Style Boxing Wins DQ No_Contest Losses Draws

  5. Martial Art Style Kickboxing Wins DQ No_Contest Losses Draws

  6. Martial Art Style Wrestling

  7. Martial Art Style BJJ

  8. Membership Type • Member_Fan • style_follow • Fighter_follow • Gym_follow • Promotion_follow

  9. Membership Type Member_Coach/Trainer -

  10. Membership Type • Member_Gym • -Fighters • -Martial_Art_Style • Coaches/Trainers • Country • Province/State • Mailing_Address • Postal_Code/Zip_Code

  11. Membership Type • Member_Promoter • -Name_of_Promotion • Country • Province/State • Mailing_Address • Postal_Code/Zip_Code

  12. Membership Type Member_Commission_Member

  13. Tables and Fields • Fighter_University_Membership • Membership_Num** • Name_Last • Name_First • Handle • Membership_Type • Date_Enrolled • Email • Country • Province/State • Mailing_Address • - Postal_Code/Zip_Code ** Primary Key

  14. Tables and Fields • Fighter_University_Membership • membership_num** • Member_Fighter • Member_Fan • Member_Promoter • Member_Coach_Trainer • Member_Gym_Club • Member_Commision_Member ** Primary Key

  15. Tables and Fields • Member_Fighter • Membership_Num** • Martial_Art_Style (Links to Martial_Arts table) • Gym • Trainer(s)_Coaches • Height • Weight • Reach ** Primary Key

  16. Tables and Fields • Martial_Art_Style • membership_num** • Muay_Thai • Boxing • Kickboxing • Wrestling • BJJ • Other_Styles ** Primary Key

  17. Tables and Fields • Muay_Thai • membership_num** • Wins • Losses • Draws • DQ • No_Contest ** Primary Key

  18. Tables and Fields • Kickboxing • membership_num** • Wins • Losses • Draws • DQ • No_Contest ** Primary Key

  19. Tables and Fields • Boxing • membership_num** • Wins • Losses • Draws • DQ • No_Contest ** Primary Key

  20. Tables and Fields • BJJ • membership_num** • Wins • Losses • Draws • DQ • No_Contest ** Primary Key

  21. Tables and Fields • Wrestling • membership_num** • Wins • Losses • Draws • DQ • No_Contest ** Primary Key