Making changes to the Employee data model
After learning about the different capabilities of the workbench, let us put our data architect hat on and modify the Employee data model using the Data Modeler subtool. If you recall, the access patterns that the Employee data model supports are as follows:
- Get employee details for a given employee login alias
- Get employee details for a given first name
- Get all employees reporting to a given manager by manager login alias
The exact query conditions are not relevant for now as we focus on making changes to this model and visualizing those changes. Let us say that you, the architect, are sent an additional business requirement to support an additional access pattern: Get all employees for a given designation
If you observe the model definition for the Employee table in the Data Modeler, there is an attribute called Designation already, but when visualizing the model with dummy data, there is no item with a value for...
