Read the scenario below and answer the questions that follow: The South African Government is busy preparing for the independence celebrations to be held at the FNB Stadium in Nasrec, Johannesburg. They would like South Africans who are willing to come for the event to register attendance before they come. They have approached you as a Java Developer to help them develop an application that they can use

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
icon
Related questions
Question

Read the scenario below and answer the questions that follow:


The South African Government is busy preparing for the independence celebrations to be held at the FNB Stadium in Nasrec, Johannesburg. They would like South Africans who are willing to come for the event to register attendance before they come. They have approached you as a Java Developer to help them develop an application that they can use to enable South Africans to register for the independence event. Use this information to answer the questions that follow.
Create a Java Application using NetBeans called EventRegister. The Java application could either have a JavaFX or Java Swing GUI. The application should allow users to register for the independence celebrations by entering a unique number, their name, and their email address then clicking a “Register” button. The unique number must be in the format of three upper case letters followed by three numbers. Ensure that all fields are filled in, and that the unique number and email address are in the correct format. Use this unique number to check if the number already exists in the database. If it does, inform the user of this, otherwise insert the unique number, name, and email address into the database and inform the user that he/she has been registered. The database is called register, and the table called person, with unique_number, name, and email fields.
The EventRegister application requires a File menu with an Exit menu item that exits the application. You can make use of any relational database management system you are comfortable with i.e., Oracle Database, XAMPP, MySQL, Microsoft SQL Server or Microsoft Access.
The EventRegister application should look as follows:

ITJVA3-B12 - Assignment-2 B2 2022 (V1.0) (1).pdf - Adobe Acrobat Reader DC (64-bit)
File Edit View Sign Window Help
Home Tools
ITJVA3-B12 - Assign... x
ITSCA3-B22 Project...
9 / 15
File
File
Independence Day Registration
Number:
Name:
Email:
O
Number:
Name:
Please enter your details
Email:
Message
H
UNI002
Figure 3- Application view when running
When the register button is clicked, the following should be displayed
Independence Day Registration
Sheunesu Makura
sheunesu@pihe.ac.za
Register
57.6%
ITJVA3-B12 - Assignment 2- Block 2 2022 | V1.0
Please enter your details
UNI002
Sheunesu Makura
0
sheunesu@pihe.ac.za
OK
0
Congratulations. You have successfully registered
Figure 4- After successful registration
X
↓
Ensure that the TextFields are cleared soon after registration is successful.
When the unique number already exists in the database, the following should be displayed:
Page 9 of 15
+
AS
C
Search 'OCR'
I
Export PDF
Adobe Export PDF
Convert PDF Files to Word
or Excel Online
Convert to
Select PDF File
ITJVA3-B12...1.0) (1).pdf X
ID
Microsoft Word (*.docx)
Document Language:
English (U.S.) Change
5 4
Convert
Edit PDF
Sign In
Create PDF
Comment
Combine Files
X
Organize Pages ✔
Transcribed Image Text:ITJVA3-B12 - Assignment-2 B2 2022 (V1.0) (1).pdf - Adobe Acrobat Reader DC (64-bit) File Edit View Sign Window Help Home Tools ITJVA3-B12 - Assign... x ITSCA3-B22 Project... 9 / 15 File File Independence Day Registration Number: Name: Email: O Number: Name: Please enter your details Email: Message H UNI002 Figure 3- Application view when running When the register button is clicked, the following should be displayed Independence Day Registration Sheunesu Makura sheunesu@pihe.ac.za Register 57.6% ITJVA3-B12 - Assignment 2- Block 2 2022 | V1.0 Please enter your details UNI002 Sheunesu Makura 0 sheunesu@pihe.ac.za OK 0 Congratulations. You have successfully registered Figure 4- After successful registration X ↓ Ensure that the TextFields are cleared soon after registration is successful. When the unique number already exists in the database, the following should be displayed: Page 9 of 15 + AS C Search 'OCR' I Export PDF Adobe Export PDF Convert PDF Files to Word or Excel Online Convert to Select PDF File ITJVA3-B12...1.0) (1).pdf X ID Microsoft Word (*.docx) Document Language: English (U.S.) Change 5 4 Convert Edit PDF Sign In Create PDF Comment Combine Files X Organize Pages ✔
ITJVA3-B12 - Assignment-2 B2 2022 (V1.0) (1).pdf - Adobe Acrobat Reader DC (64-bit)
File Edit View Sign Window Help
Home Tools
ITJVA3-B12 - Assign... x
ITSCA3-B22 Project...
11 / 15
File
When some fields are left out the following should be displayed:
File
Independence Day Registration
Number:
Name:
Email:
Message
(i
O
Please ensure that all fields are filled in
Number:
Please enter your details
UNI002
Thando Mandela
Name:
Email:
Figure 7- When some fields are missing
When the email address is in the wrong format, the following should be displayed
Independence Day Registration
Message
ок
57.6%
Please enter your details
UNI002
Thando Mandela
thandogmail.com
ITJVA3-B12 - Assignment 2- Block 2 2022 | V1.0
Register
Please enter a valid email address.
ОК
x
0
Figure 8- When incorrect email address format is entered
↓
Page 11 of 15
+
AS
C
Search 'OCR'
I
Export PDF
Adobe Export PDF
Convert PDF Files to Word
or Excel Online
Convert to
Select PDF File
ITJVA3-B12...1.0) (1).pdf X
I D
Microsoft Word (*.docx)
Document Language:
English (U.S.) Change
5 4
Convert
Edit PDF
Sign In
Create PDF
Comment
Combine Files
X
Organize Pages ✔
Transcribed Image Text:ITJVA3-B12 - Assignment-2 B2 2022 (V1.0) (1).pdf - Adobe Acrobat Reader DC (64-bit) File Edit View Sign Window Help Home Tools ITJVA3-B12 - Assign... x ITSCA3-B22 Project... 11 / 15 File When some fields are left out the following should be displayed: File Independence Day Registration Number: Name: Email: Message (i O Please ensure that all fields are filled in Number: Please enter your details UNI002 Thando Mandela Name: Email: Figure 7- When some fields are missing When the email address is in the wrong format, the following should be displayed Independence Day Registration Message ок 57.6% Please enter your details UNI002 Thando Mandela thandogmail.com ITJVA3-B12 - Assignment 2- Block 2 2022 | V1.0 Register Please enter a valid email address. ОК x 0 Figure 8- When incorrect email address format is entered ↓ Page 11 of 15 + AS C Search 'OCR' I Export PDF Adobe Export PDF Convert PDF Files to Word or Excel Online Convert to Select PDF File ITJVA3-B12...1.0) (1).pdf X I D Microsoft Word (*.docx) Document Language: English (U.S.) Change 5 4 Convert Edit PDF Sign In Create PDF Comment Combine Files X Organize Pages ✔
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Managing System
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education