Using MySQL, design a 2 table database. The data types of columns should be set properly 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) 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.4 The first button will open aa frame that can be used to add, update and delete Gyjm Members. 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

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Using MySQL, design a 2 table database. The data types of columns should be set properly

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)

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.4 The first button will open aa frame that can be used to add, update and delete Gyjm Members. 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

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions