Create another application/class named EmployeeDatabase that allows you to store an array that acts as a database of any number of Employee objects up to 25. While the user decides to continue, offer three options: to add a record to the database, to delete a record from the database, or to change a record in the database. Then proceed as follows: If the user selects the add option, issue an error message if the database is full. Otherwise, prompt the user for an Id. If the Id already exists in the database, issue an error message. Otherwise, prompt the user for rest of the inputs and add the new record to the database. If the user selects the delete option, issue an error message if the database is empty. Otherwise, prompt the user for an Id. If the Id does not exist, issue an error message. Otherwise, delete the record. If the user selects the change option, issue an error message if the database is empty. Otherwise, prompt the user for an Id. If the requested record does not exist, issue an error message. Otherwise, prompt the user for a new salary value and change the salary value for the record. After each option executes, display the updated database in ascending order by Employee Id and prompt the user to select the next action. Part e should be done using an array but not ArrayList. Sample output for Part e Do you want to (A)dd, (D)elete, or (C)hange a record or (Q)uit >> A Enter Employee ID >> 500 Get user input here……………………………… Current database: ID 500 SSN: 999-23-1234 first name: Mehwish last name: B. address: Burnaby dept: HR annual salary: 89000.0 Do you want to (A)dd, (D)elete, or (C)hange a record or (Q)uit >> A Enter Employee ID >> 600 Get user input here……………………………… 3 Current database: ID 500 SSN: 999-23-1234 first name: Mehwish last name: B. address: Burnaby dept: HR annual salary: 89000.0 ID 600 SSN: 123-12-1234 first name: Sarah last name: T address: Vancouver dept: MARKTING annual salary: 45678.0 Do you want to (A)dd, (D)elete, or (C)hange a record or (Q)uit >> D Enter ID to delete >> 500 Current database: ID 600 SSN: 123-12-1234 first name: Sarah last name: T address: Vancouver dept: MARKTING annual salary: 45678.0 Do you want to (A)dd, (D)elete, or (C)hange a record or (Q)uit >> C Enter ID to change >> 34 Sorry - ID number #34 does not exist in the database Current database: ID 600 SSN: 123-12-1234 first name: Sarah last name: T address: Vancouver dept: MARKTING annual salary: 45678.0 4 Do you want to (A)dd, (D)elete, or (C)hange a record or (Q)uit >> C Enter ID to change >> 600 Enter salary >> 56000 Current database: ID 600 SSN: 123-12-1234 first name: Sarah last name: T address: Vancouver dept: MARKTING annual salary: 56000.0 Do you want to (A)dd, (D)elete, or (C)hange a record or (Q)uit >> Q Good bye!!

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

Create another application/class named EmployeeDatabase that allows you to store an
array that acts as a database of any number of Employee objects up to 25. While the user
decides to continue, offer three options: to add a record to the database, to delete a record
from the database, or to change a record in the database. Then proceed as follows:
If the user selects the add option, issue an error message if the database is full.
Otherwise, prompt the user for an Id. If the Id already exists in the database, issue
an error message. Otherwise, prompt the user for rest of the inputs and add the new
record to the database.
If the user selects the delete option, issue an error message if the database is empty.
Otherwise, prompt the user for an Id. If the Id does not exist, issue an error message.
Otherwise, delete the record.
If the user selects the change option, issue an error message if the database is empty.
Otherwise, prompt the user for an Id. If the requested record does not exist, issue
an error message. Otherwise, prompt the user for a new salary value and change the
salary value for the record.
After each option executes, display the updated database in ascending order by
Employee Id and prompt the user to select the next action.
Part e should be done using an array but not ArrayList.
Sample output for Part e
Do you want to (A)dd, (D)elete, or (C)hange a record or (Q)uit >> A
Enter Employee ID >> 500
Get user input here………………………………
Current database:
ID 500
SSN: 999-23-1234
first name: Mehwish
last name: B.
address: Burnaby
dept: HR
annual salary: 89000.0
Do you want to (A)dd, (D)elete, or (C)hange a record or (Q)uit >> A
Enter Employee ID >> 600
Get user input here………………………………
3
Current database:
ID 500
SSN: 999-23-1234
first name: Mehwish
last name: B.
address: Burnaby
dept: HR
annual salary: 89000.0
ID 600
SSN: 123-12-1234
first name: Sarah
last name: T
address: Vancouver
dept: MARKTING
annual salary: 45678.0
Do you want to (A)dd, (D)elete, or (C)hange a record or (Q)uit >> D
Enter ID to delete >> 500
Current database:
ID 600
SSN: 123-12-1234
first name: Sarah
last name: T
address: Vancouver
dept: MARKTING
annual salary: 45678.0
Do you want to (A)dd, (D)elete, or (C)hange a record or (Q)uit >> C
Enter ID to change >> 34
Sorry - ID number #34 does not exist in the database
Current database:
ID 600
SSN: 123-12-1234
first name: Sarah
last name: T
address: Vancouver
dept: MARKTING
annual salary: 45678.0
4
Do you want to (A)dd, (D)elete, or (C)hange a record or (Q)uit >> C
Enter ID to change >> 600
Enter salary >> 56000
Current database:
ID 600
SSN: 123-12-1234
first name: Sarah
last name: T
address: Vancouver
dept: MARKTING
annual salary: 56000.0
Do you want to (A)dd, (D)elete, or (C)hange a record or (Q)uit >> Q
Good bye!!

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Windows
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
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