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

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 # 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
Jun 15, 2021
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here