Suppose you want to store the records of the employees of your company. They all have employee ID's like IT-012 for the IT department, LG-012 for the Legal department, RD-012 for the records department, and so on. Today, you get a message from the office that "Mr. Habib " has been promoted to Senior Procurer of Office Foodstuffs (SPOF), and because you're in the Database department you have to update his records (he got promoted from Junior Procurer). They also tell you his employee ID,IT-6767.In the massive company where you work, there are literally thousands of employees. To make stuff worse, "Habib" is a pretty common name, and there may be many Habib’s in different departments. So, what do you do? Design a relevant data structure which stores the information of all the employees. Now it’s your task to maintain all departments and store 5 to 10 employees with their IDs, then search the employee ID of ‘Mr. Habib’ to change the post in database. For this you have to print the updated record of promoted employee. Note: You are not allowed to use any built-in Data Structure classes to implement above scenario

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

Suppose you want to store the records of the employees of your company. They all have
employee ID's like IT-012 for the IT department, LG-012 for the Legal department, RD-012 for
the records department, and so on. Today, you get a message from the office that "Mr. Habib "
has been promoted to Senior Procurer of Office Foodstuffs (SPOF), and because you're in the
Database department you have to update his records (he got promoted from Junior Procurer).
They also tell you his employee ID,IT-6767.In the massive company where you work, there are
literally thousands of employees. To make stuff worse, "Habib" is a pretty common name, and
there may be many Habib’s in different departments. So, what do you do? Design a relevant data
structure which stores the information of all the employees.
Now it’s your task to maintain all departments and store 5 to 10 employees with their IDs, then
search the employee ID of ‘Mr. Habib’ to change the post in database. For this you have to print
the updated record of promoted employee.
Note: You are not allowed to use any built-in Data Structure classes to implement above
scenario

Expert Solution
steps

Step by step

Solved in 2 steps

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