Personnel - Employee Entity, Conceptual Design

In this page we will look at creating the basic (concrete) entity Employee as it can exist without referencing other entities (contains no FKs).

Employee Entity

Conceptual Design

"Discover and organise information about the user’s data requirements, from the users’ perspective."

First we need to consider what data we want to store about our Employees.

EMPLOYEE (LastName, FirstName, Title (Mr, Mr, Ms, Dr, etc.), Address, Mobile Phone)

Next we need identify how we will uniquely identify each employee. In the physical world we use a person's name, but it is common in a large database that we could have people with the same name. So we will give them an Employee number. It is useful to call this an Employee Identifier (EmpID).

EMPLOYEE (EmployeeID, LastName, FirstName, Title (Mr, Mr, Ms, Dr, etc.), Address, Mobile Phone)

As shown previously, if we created a Spreadsheet containing the Employee data it could look like: