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 # is the sequence number of the member in tblMembers table. Should a member be deleted the system should adjust the sequence as well. - Age is the current age (integer) number calaculated from the DateOfBirth of the member. - Balance is the difference between the Amount due and the Amount paid by the Member Note: Use graphics to create your application
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 # is the sequence number of the member in tblMembers table. Should a member be deleted the system should adjust the sequence as well.
- Age is the current age (integer) number calaculated from the DateOfBirth of the member.
- Balance is the difference between the Amount due and the Amount paid by the Member
Note: Use graphics to create your application
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
