View the step-by-step solution to:


You are required to build a Gym Management System for XYZ Gym. The system will be used to manage the

details of Gym Members, their payments as well as display a summary report in a table. 

Using MySQL, design a 2 table database. The data types of columns should be set properly


1.1 tblMembers

The tblMembers will be used to store the details of the Gym Members

MemberID, Name, Surname, DateOfBirth, ID,Contact, DateJoined

MemberType (Annual: R200/year, Monthly: R50/month)



1.2 The tblPayments table will be used to keep track of payments made by Members.

PaymentID, Date, Amount. The tblPayments should be related to tblMembers accordingly.

Top Answer

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question