1.1.1 HRRSS
User
Update user
User Info retrieved
Update
D
1
User details
1.3.1 HRRSS
1.2.1 HRRSS
Registration
Search
User Info saved
User Info retrieved
User Info updated
User Information
User
User services
User
|
User Info removed
|
D
4
|
Archive info
|
|
|
|
|
|
1.4.1 HRRSS
Archive
26
Figure 8: DFD Level 1 for User Management
Service Information
Employee
Registration
Search services
Expatriate
Search
D
2
Services details
D
4
Archive info
D
3
D
5
Renting info
D
3
House details
D
4
Archive info
2.3.1 HRRSS
Update
2.4.1 HRRSS
Update Service
Employee
Archive
Figure 9:DFD Level 1 for Service Management
Services Info updated
Service Info retrieved
House Info retrieved
Employee
Remove service Info
3.2.1 HRRSS
House availability
Service Info saved
4.4.4.3 DFD Level 1 for Service Management
2.1.1 HRRSS
2.2.1 HRRSS
Service Info removed
4.4.4.4 DFD Level 1 for House Management
3.1.1 HRRSS
House Information
Employee
Registration
House Info saved
Retrieve renting
Renting Info
3.3.1 HRRSS
Renting
3.4.1 HRRSS
Rent a house
Expatriate
Update house Info
Employee
Update
House Info
House Info
Remove house
Employee
House Info
Archive
House Info
3.5.1 HRRSS
Expatriate
Check house
House details
28
4.5 WAYS OF RECORDING INFORMATION
The information will be recorded in Mysql database. A database
contains different parts which are used to record and manipulate information.
The following steps elaborate on the components and design of an ERDM.
4.5.1 Entity Relationship Diagram
An ERD is a specialized graphic that illustrates the
interrelationships between entities in a database. ERD often use symbols to
represent three different types of information. Boxes are commonly used to
represent entities. Diamonds are normally used to be solved while retaining its
essential features one-to-one relationships.
This type of relationship takes place when a single occurrence
of an entity is relationship to just one occurrence of a second entity.
The term entity is widely used in database circles and is used
to mean any distinguishable object that is to be represented in the database.
ERDM is based on a perception of a real world that consists of a collection of
basic object called entities and also of relationships among these objects.
4.5.2 Designing the ERD
Entities are described in a database by set of attribute, like
the attribute username, password, telephone number, employee id and address
describe the entity, employees in the ERDM illustrated below. The primary key
employee id is used to uniquely identify an employees (since it may be possible
to have two employees with same name, surname, etc) the entity relationships
are shown in diamond shapes. The set of all entities of the same type and set
of all relationships of same type are termed as an entity set and relationship
set respectively, the overall logical structure (schema) of a database can be
expressed graphically by an ERD, which is built up from the following
components:
Rectangle: represent entity sets
Ellipse: represent attributes
Diamonds: represent relationship among entity sets Lines:
links attributes to entity sets and sets and entity sets to relationships Each
component is labeled with the entity or relationship that it represents.
29
| 
