Question: 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

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 Using Java and the jdbc API , create a startup frame that will be used navigate the application. The frame should have 3 buttons. 1.3 The first button will open aa frame that can be used to add, update and delete Gyjm Members. 1.4 The second button will open a frame that will be used to collect the payments made by students. 1.5 The third button will display a frame that calculates the current age and the balances, and displays a summary report in a table, as follows for an example: Order # ID # Name Surname DOB Age Amount Amount Balance Due Paid 1 X X X 06/06/1997 20 R1000 R1000 RO 2 X X X 01/02/1990 27 R1500 R800 R700 3 X X X 20/10/1997 19 R2000 1500 R500
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
