Answer number 2 and use Java language Laboratory Exercise:1. Create a database of salesman:a. Table Description:o Salesman Number – Integer – Primary Key – Not Nullo Salesman Name – VarCharo Quarterly Sales – Real (Float)Note: input of sales per quarter (1st, 2nd, 3rd, 4th)Total Sales - DoubleCommission – Real (Float)b. Compute the Total Salesc. Compute the Commission based on the following:Total SalesCommission10% of Total Sales<= 5000<= 10000<= 1500015% of Total Sales20% of Total Sales<= 20000> 20000d. Search a salesman (input must be Salesman Number), determine if the salesman isexisting in the database, otherwise update the record by inputting new values ofQuarterly Sales.e. Search a salesman (input must be Salesman Number), determine if the salesman isexisting in the database, otherwise delete the record.f. Display all the record of database.25% of Total Sales35% of Total Sales or 15000 whichever is higher2. Modify #1, input Salesman Number:2.1.Search if the record is existing or not;If exist, ask if you are going to update or delete the record:2.2.1. If update, change the values of Salesman Name and Quarterly Sales2.2.2. If delete, remove the record from the table;2.3.2.2.If not, display "Record not exists!" and input another ID number repeat 2.1 to 2.3;2.4.Display the new contents of table.

Here is a java code for creating a record and editing it as i used student as a reference, you can…

2. Modify #1, input Salesman Number: 2.1. 2.2. Search if the record is existing or not; If exist, ask if you are going to update or delete the record: 2.2.1. If update, change the values of Salesman Name and Quarterly Sales 2.2.2. If delete, remove the record from the table; 2.3. If not, display "Record not exists!" and input another ID number repeat 2.1 to 2.3; 2.4. Display the new contents of table.

2. Modify #1, input Salesman Number: 2.1. 2.2. Search if the record is existing or not; If exist, ask if you are going to update or delete the record: 2.2.1. If update, change the values of Salesman Name and Quarterly Sales 2.2.2. If delete, remove the record from the table; 2.3. If not, display "Record not exists!" and input another ID number repeat 2.1 to 2.3; 2.4. Display the new contents of table.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

Explain the basic arithmetic operators in programming and provide examples of their usage.
Define string concatenation
How to code for user input in Java programming language?
Differentiate between and .
Explain the importance and operation of a translator in programming Language
Briefly explain calling convention
Differentiate between and .