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

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 Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Engineering
Computer Science

Data Structures

Databases

Related Computer Science Q&A

Find answers to questions asked by students like you.

Q: Including the initial parent process, how many processes are created bythe program shown below? #inc...

A: If P(n) is the number of processes created by a n-fork program, then we have that  P(n) = 2 * P(n-1)...

Q: Which Python module and method are used to create a multiple regression model for a given data set? ...

A: Explanation: In Python, the statsmodel module is used to create a multiple regression model for the...

Q: Write a boundary-fill procedure to fill an (i) 4 connected region (ii) 8 connected region

A: Boundary Fill Algorithm:   Boundary fill procedure is basically a procedure where the pixel inside a...

Q: Write a java language program using Multiple if statement that will produce selection for the rate...

A: java language program using Multiple if statement that will produce selection for the rate and outpu...

Q: Write a program that prompts the user to enter five test scores and then prints the average test Sco...

A: Note: Below is the required program in C++. Programming Approach: Defining the required header file...

Q: Write a c++ program to compare following strings with each other and display which string is smaller...

A: As per the guidelines of Bartleby: “Since you have asked multiple question, we will solve the first ...

Q: Find the result of this decimal arithmetic in 2’s complement representation (8-bits)and state if the...

A: Note: Since you have posted a question with multiple subparts, we will solve the first three subpart...

Q: C++ Programming Exercise: When you borrow money to buy a house, a car, or for some other purpose, yo...

A: PROGRAM: //Header file #include<iostream> #include<iomanip>   //Using namespace using na...

Q: 1. Assume an int is size 4 bytes on our system.  What is the size in bytes of the following array: i...

A: In the given array, we have 20 int elements and each int element takes 4 bytes. Hence, the size of a...

Q: The parameter(s) of a C++ function is/are contained by ..?     Square brackets [ ]     Curly...

A: If a function is named, you write the name of the function and add any appropriate function data in ...

Q: Sorry, using java:   3.8: Software SalesA software company sells a package that retails for $99. Qua...

A: Programming instructions: Include necessary header files. Create a class. In the main, create the r...

Q: Describe the technology equipment feild .and list possible jobs in this area

A: The technology equipment field includes distributer and manufacturer of computer system, mobile phon...

Q: determine if the statement is true or false If N represents the number of elements in the queue, the...

A: Here, the class ArrayBoundedQueue<T> is implementing the interface QueueInterface<T>. Th...

Q: In MS Windows, is it easier or more difficult to close a maximized window vs.regular window? And why...

A: Solution:  Fitts law determines the speed with which the user interacts  with the interface element...

Q: Derive the decision parameter p for the Bresenham’s circle drawing algorithm. Write steps of Bresenh...

A: A circle drawing algorithm that chooses the nearest pixel location to complete the arc is Bresenham'...

Q: write in c++  Write ONE program that contains the following (#includes are NOT necessary). [Hint: be...

A: 1. copies function : The function, copies that take two integer variables n and x as input arguments...

Q: Write a python program that ask the user to input two integers and then asks the user if they want t...

A: def add(x, y): # function to add number    return x+y def sub(x, y): # function to subtract    retur...

Q: Please attach implementation screenshot along with code in c++

A: #include<iostream> using namespace std;   class Product { ///Attribute defined to use inside C...

Q: 10. Consider the following entities: Job applicant b. Company c. Interview а. d. Job offer Design an...

A: The four entities and their attributes can be listed as follows: a. Job applicant: Name Phone numbe...

Q: C++ What does the following segment of code output to the screen (be precise)? int a = 3;   ...

A: int a = 3;     if (a % 2)                                // if(3%2)    -->if(1)   --> if(true)...

Q: Select two main differences between the higher-order functions map and filter: A) map returns a Bool...

A: Two main differences between the higher-order functions map and filter: 1) Filter returns a Boolean ...

Q: Which statements below are true for locals? (Select all which apply) A) A local can contain arbitrar...

A: There are following points to be clear about Locals : Locals are those values that are defined insi...

Q: No matching port Your uncle has given you a new monitor for your computer. When you attempt to conne...

A: TO CONNECT A MONITOR TO A COMPUTER - In order to use a desktop computer, users need to be careful. M...

Q: For each of the following equations, perform the following tasks: Decide if the equation is mathema...

A: After executing the commands in Octave online compiler, the following output is produced, Explanati...

Q: Give an example of a graph (with or without weights on the edges) where the betweenness and closenes...

A: Graph: Actually, graph is a pictorial representation or diagram that represents data or values...

Q: Question Write an Assembly code to implement the following flow-chart : Read Port D to R16 If R16<10...

A: .include "m16Adef.inc" .cseg ldi R16,0 out DDRD,R16 ldi R16, 0xff on DDRBO, R...

Q: (Java)   Create a class named Customer that will determine the monthly repayment amount due by acust...

A: Program description: The driver java program Customer_Finance prompts the user to enter the customer...

Q: How to answer the following questions screen shot show the text's arrayboundedqueue and the array un...

A: ANS: - Option(A) is correct. The element is held at index 0. EXPLANATION: - The ArrayBoundedQueue cl...

Q: Consider the following code snippet, and choose the best statement below: int cards[4]; for (int i =...

A: Click to see the answer

Q: 8. Suppose a parking spot in a college that students, Instructors and staffs can park their cars. De...

A: Step 1:- Note:-I am giving the solution of 8 problem. An ER diagram is a design or blueprint of a da...

Q: Which of the following is the signature for the higher-order function map  A) map: (Alpha -&gt; Beta...

A: Two questions are asked so only the first will be answered. Please upload another question again to ...

Q: how to answer the question A glass queue is like a queue but: A.  it uses priorities. B. it allow...

A: Glass queue A queue is a container that stores a set of objects which are accessed in a specific wa...

Q: What is the output of the following code segment?

A: Click to see the answer

Q: C++ The variable number6 is the same as the variable Number6?

A: The identifiers are the names given to variables or functions or classes.   The identifiers can cont...

Q: In order to practice multi-threading use C++ to create a quick sort algorithm using a standard seque...

A: #include &lt;stdio.h&gt; #include &lt;stdlib.h&gt; int partition(int * a, int p, int r) { int ...

Q: Draw a use case diagram and class diagram for Registration system in Sur university College, which S...

A: Use case diagram:

Q: In Java Add (10 + 5)Add (4+8)Add (7*2)Add (90 – 3)Print listPrint peekRemove an item from the listPr...

A: 1.1 PROGRAM:  //Header file import java.io.*; import java.util.*;   //Defining the main() class Mai...

Q: 4. Write and draw Algorithm and flowchart for find Maximum of Given 3 Number

A: Click to see the answer

Q: Find the repetend for 1/403 and explain how to use it to produce 30 fractions of the form n/403 that...

A: Actually, 30 fraction having exactly 30 digit repetends The answer has given below:

Q: write two different techniques to declare and initialize a variable with an example ?

A: Variables   In the programming language Variables are used to represent the data. A variable is used...

Q: The Durban July is an annual horse race that has been presented every year since 1897. Write a C/C++...

A: Create a structure of Horse with four fields struct Horse    {        //fields        char Name[20];...