Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Programming questions