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
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.