Please due in C. Thank you A sample run is as follows : ---=== EMPLOYEE DATA ===--- 1. Display Employee Information 2. Add Employee 3. Update Employee Salary 4. Remove Employee 0. Exit Please select from the above options: 5 ERROR: Incorrect Option: Try Again 1. Display Employee Information 2. Add Employee 3. Update Employee Salary 4. Remove Employee 0. Exit Please select from the above options: 1 EMP ID EMP AGE EMP SALARY ====== ======= ========== 1. Display Employee Information 2. Add Employee 3. Update Employee Salary 4. Remove Employee 0. Exit Please select from the above options: 2 Adding Employee =============== Enter Employee ID: 222 Enter Employee Age: 22 Enter Employee Salary: 22222.22 1. Display Employee Information 2. Add Employee 3. Update Employee Salary 4. Remove Employee 0. Exit Please select from the above options: 2 Adding Employee =============== Enter Employee ID: 333 Enter Employee Age: 33 Enter Employee Salary: 33333.33 1. Display Employee Information 2. Add Employee 3. Update Employee Salary 4. Remove Employee 0. Exit Please select from the above options: 2 Adding Employee =============== Enter Employee ID: 444 Enter Employee Age: 44 Enter Employee Salary: 44444.44 1. Display Employee Information 2. Add Employee 3. Update Employee Salary 4. Remove Employee 0. Exit Please select from the above options: 2 Adding Employee =============== Enter Employee ID: 555 Enter Employee Age: 55 Enter Employee Salary: 55555.55 1. Display Employee Information 2. Add Employee 3. Update Employee Salary 4. Remove Employee 0. Exit Please select from the above options: 2 Adding Employee =============== ERROR!!! Maximum Number of Employees Reached 1. Display Employee Information 2. Add Employee 3. Update Employee Salary 4. Remove Employee 0. Exit Please select from the above options: 1 EMP ID EMP AGE EMP SALARY ====== ======= ========== 222 22 22222.22 333 33 33333.33 444 44 44444.44 555 55 55555.55 1. Display Employee Information 2. Add Employee 3. Update Employee Salary 4. Remove Employee 0. Exit Please select from the above options: 3 Update Employee Salary ====================== Enter Employee ID: 123 *** ERROR: Employee ID not found! *** Enter Employee ID: 321 *** ERROR: Employee ID not found! *** Enter Employee ID: 333 The current salary is 33333.33 Enter Employee New Salary: 99999.99 1. Display Employee Information 2. Add Employee 3. Update Employee Salary 4. Remove Employee 0. Exit Please select from the above options: 1 EMP ID EMP AGE EMP SALARY ====== ======= ========== 222 22 22222.22 333 33 99999.99 444 44 44444.44 555 55 55555.55 1. Display Employee Information 2. Add Employee 3. Update Employee Salary 4. Remove Employee 0. Exit Please select from the above options: 4 Remove Employee =============== Enter Employee ID: 789 *** ERROR: Employee ID not found! *** Enter Employee ID: 987 *** ERROR: Employee ID not found! *** Enter Employee ID: 333 Employee 333 will be removed
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
Step by step
Solved in 5 steps with 11 images