Let's look at the human resource in our database structure.
Earlier, we have installed several tables under the H.R. database.
So let's look at each of them.
We have installed the folding tables, we have region which contains the list of global regions, for
example, like America, Europe, Middle East and Africa, etc., we have we also have countries which
contains the list of countries like New York, Singapore, etc., etc. We also have location.
Location contains all the sample location addresses that can be a road address or so departments is
the list of the department of the company, for example, sales, marketing, I.T., etc cetera.
The jobs table contain a list of jobs.
This is the identification of jobs that a company will have.
For example, an employee will work in admin group or sales group or marketing.
And then you have job underscore history.
This table contains the employee job information, for example, was the employee ID, was the start
and end date for this particular employee, was the job I.T. and was the department in which it works?
Actually, during that time, the last table is the employee's table.
This is the most important table which contains all about employee information.
It's demographics like its first name, last name, phone, email address, higher salary commission,
who is his manager, etc., etc..
So this is the typical table that we have now.
Let's look at the interrelation of these tables.
These tables are designed in such a way that they have primary and secondary keys.
So let's look at the region.
Region has the primary key called Region ID country will have a country ID location as a location ID
department head department employee is an employee ID job is a job ID and job history has employed as
well as start date.
Now the region, countries, locations, jobs, employee, department and job history has individual
roles.
For example, in the employees table we have foreign kids, foreign keys as in like they refer to the
foreign table, for example, and the employee table.
We have a job ID which refers to the job within the jobs table.
And then you have department I.D., which refers to the department.
Similar to that in the countries table.
We have region which refers to the region idea here.
This is the foreign key.
And in the location we have the country ID, which is the foreign key in the country ID table.
So these tables are interconnected to each other as well.
In the following sessions, we will go through with them in more detail how they are connected to each
other.
But importantly, what you need to understand is that each table is designed in such a way that they
refer to the individuals, set up tables and set up tables as in regions, countries, location.
And then you have a transaction table called Employee, which contains transactions about employees.
So we will go through in more detail in the following sessions.