4.8 THE CONCEPTUAL LEVEL 4.8.1 The Treatment Conceptual
Model
The conceptual model of treatment permits to treat the
dynamism of the information system, it means that operations are achieved
according to events. This model permits to represent schematic way the activity
of an information system without making reference to organizational choices or
the means of execution therefore. That is to say it allows defining what must
be done merely, but it doesn't say when, how, nor where.
32
The event
An event represents a change in the outside environment to the
information system; it can also represent a change in the information system
itself.
An external event is a change of the outside universe of the
information system
Symbol used:
An internal event is an internal change to the information
system
Symbol used: The Process A process is a subset of the activity of
the enterprise. It means that the activity of the enterprise is constituted of
a set of process. A process is itself composed of treatments regrouped in a set
named operations.
Symbols used:
The Operation
An operation is a set of actions executed by the system following
an event, or to a conjunction of events. This sets of actions are interrupted,
that means that the events are not taken so much into consideration, as long as
the operation has not yet been accomplished.
The synchronization
The synchronization of an operation defines a Boolean condition
on the contributive events having to trigger an operation. These are therefore
conditions at the level of events governed by a logical condition achieved by
the logical operations: EITHER, AND and NO.
4.8.2 Treatment Conceptual Model for House
information
House information
Verification of information
Check house availability
Accept Reject
House available
House not available
33
Figure 13: Treatment Conceptual Model for House information
4.8.3 Treatment Conceptual Model for confirming
registration
Expatriate information
Verification of information
Check form
Complete information
Accept Reject
Figure 14: Treatment Conceptual Model for confirming
registration
34
4.8.4 Treatment Conceptual Model for services
information
Services information
Select service
Service details
Get information
Show
Figure 15: Treatment Conceptual Model for services
information
4.9 DATA DICTIONARY
A data dictionary is a collection of descriptions of the data
objects or items in a data model for the benefit of programmers and others who
need to refer to them or the dictionary of data is at a time the pillar of work
and the result of research and analysis of data. It is just like a depicted
picture of the entire work. This dictionary of data defines all categories of
data or data types, brief the all essential information about the software is
included.
|
TABLE
|
FIELD
|
DESCRIPTION
|
TYPE
|
CONSTRAINTS
|
|
ORGANIZATIONS
|
OrgId
|
Identification of the Organizations
|
varchar(10)
|
Primary key
|
|
|
Names
|
Names of Organizations
|
varchar(120)
|
Not null
|
|
email
|
Email of the organizations
|
varchar(150)
|
Not null
|
|
website
|
Website of Organizations
|
varchar(120)
|
Not null
|
|
POBox
|
POBox of Organizations
|
varchar(15)
|
Not null
|
|
Phones
|
Phone numbers of Organizations
|
varchar(15)
|
Not null
|
|
LocId
|
Identification of Locations
|
varchar(10)
|
Foreign key
|
|
EMPLOYEES
|
EmId
|
Identification of Employees
|
varchar(10)
|
Primary key
|
|
LName
|
Last Name of Employees
|
varchar(120)
|
Not null
|
|
FName
|
First Name of Employees
|
varchar(100)
|
Not null
|
|
Sex
|
Sex of Employees
|
varchar(1)
|
Not null
|
35
|
DOB
|
Birth date of Employees
|
date
|
Null
|
|
Phones
|
Phone numbers of Employees
|
varchar(15)
|
Null
|
|
email
|
Email of Employees
|
varchar(150)
|
Null
|
|
OrgId
|
Identification of the Organizations
|
varchar(10)
|
Foreign key
|
|
LOCATIONS
|
LocId
|
Identification of Locations
|
varchar(10)
|
Primary key
|
|
Street
|
Street of Locations
|
varchar(120)
|
Not null
|
|
Region
|
Region of Locations
|
varchar(150)
|
Not null
|
|
District
|
District of Locations
|
varchar(120)
|
Not null
|
|
LOCATE
|
LoId
|
Identification of Locate
|
varchar(10)
|
Primary key
|
|
ExId
|
Identification of Expatriates
|
varchar(10)
|
Foreign key
|
|
SerId
|
Identification of Hospitals
|
varchar(10)
|
Foreign key
|
|
EXPATRIATES
|
ExId
|
Identification of Expatriates
|
varchar(10)
|
Primary key
|
|
LName
|
Last name of Expatriates
|
varchar(120)
|
Not null
|
|
FName
|
First of Expatriates
|
varchar(150)
|
Not null
|
|
Sex
|
The sex of Expatriates
|
varchar(1)
|
Null
|
|
DOB
|
The birth date of Expatriates
|
date
|
Null
|
|
Phones
|
Phone numbers of Expatriates
|
varchar(15)
|
Not null
|
|
email
|
Email of Expatriates
|
varchar(150)
|
Not null
|
|
OrgId
|
Identification of the Organizations
|
varchar(10)
|
Foreign key
|
|
OWNERS
|
OwId
|
Identification of the owners
|
varchar(10)
|
Primary key
|
|
FName
|
First Name of the owners
|
varchar(120)
|
Not null
|
|
LName
|
Last Name of the owners
|
varchar(150)
|
Not null
|
|
DOB
|
The birth date of the owners
|
date
|
Null
|
|
Sex
|
The sex of the owners
|
varchar(1)
|
Null
|
|
email
|
The Email of the owners
|
varchar(120)
|
Not null
|
|
Phones
|
Phone numbers of the owners
|
varchar(15)
|
Not null
|
|
HOUSES
|
HouId
|
Identification of the houses
|
varchar(10)
|
Primary key
|
|
Names
|
Names of the houses
|
varchar(120)
|
Not null
|
|
Price
|
The price of the houses
|
varchar(15)
|
Not null
|
|
Rooms
|
Rooms that the house has
|
int(11)
|
Not null
|
|
OwId
|
Identification of the owners
|
varchar(10)
|
Foreign key
|
|
LocId
|
Identification of Locations
|
varchar(10)
|
Foreign key
|
|
SERVICES
|
SerId
|
Identification of the services
|
varchar(10)
|
Primary key
|
|
Hospital
|
Services about hospital
|
varchar(120)
|
Not null
|
|
Club of language
|
Services about club of language
|
varchar(120)
|
Not null
|
|
Market
|
Services about market
|
varchar(120)
|
Not null
|
|
School
|
Services about school
|
varchar(120)
|
Not null
|
|
Web list
|
Services about web list
|
varchar(120)
|
Not null
|
|
LocId
|
Identification of Locations
|
varchar(10)
|
Foreign key
|
|
MARKET
|
MarId
|
Identification of the market
|
varchar(10)
|
Primary key
|
|
Name
|
Name of market
|
varchar(120)
|
Not null
|
|
Email
|
email of market
|
varchar(15)
|
Not null
|
|
Pobox
|
Pobox of market
|
varchar(15)
|
Not null
|
|
Phone
|
phone of market
|
varchar(15)
|
Not null
|
|
SerId
|
Identification of Locations
|
varchar(15)
|
Foreign key
|
|
SCHOOL
|
SchId
|
Identification of the school
|
varchar(10)
|
Primary key
|
36
|
Name
|
Name of school
|
varchar(120)
|
Not null
|
|
Email
|
email of school
|
varchar(15)
|
Not null
|
|
Pobox
|
Pobox of school
|
varchar(15)
|
Not null
|
|
Phone
|
phone of school
|
varchar(15)
|
Not null
|
|
SerId
|
Identification of Locations
|
varchar(15)
|
Foreign key
|
|
CLUB
|
ClId
|
Identification of the Club
|
varchar(10)
|
Primary key
|
|
Name
|
Name of Club
|
varchar(120)
|
Not null
|
|
Email
|
email of Club
|
varchar(15)
|
Null
|
|
Pobox
|
Pobox of Club
|
varchar(15)
|
Not null
|
|
Phone
|
phone of Club
|
varchar(15)
|
Not null
|
|
SerId
|
Identification of Locations
|
varchar(15)
|
Foreign key
|
|
HOSPITAL
|
HosId
|
Identification of the Hospital
|
varchar(10)
|
Primary key
|
|
Name
|
Name of Hospital
|
varchar(120)
|
Not null
|
|
Email
|
email of Hospital
|
varchar(15)
|
Null
|
|
Pobox
|
Pobox of Hospital
|
varchar(15)
|
Not null
|
|
Phone
|
phone of Hospital
|
varchar(15)
|
Not null
|
|
SerId
|
Identification of Locations
|
varchar(15)
|
Foreign key
|
|
WEBLIST
|
WeId
|
Identification of the Weblist
|
varchar(10)
|
Primary key
|
|
Job
|
Name of job
|
varchar(120)
|
Not null
|
|
Company
|
Name the company
|
varchar(150)
|
Not null
|
|
Link
|
Website that provide more information
|
varchar(100)
|
Not null
|
|
SerId
|
Identification of Locations
|
varchar(15)
|
Foreign key
|
|
LOGIN
|
LogId
|
Identification of Login
|
varchar(10)
|
Primary key
|
|
Uname
|
User name for login
|
varchar(120)
|
Not null
|
|
Pword
|
Password for login
|
varchar(150)
|
Not null
|
|
Ftion
|
User function
|
varchar(150)
|
Not null
|
|
ARCHIVES
|
ArchId
|
Identification of Archive
|
varchar(15)
|
Primary key
|
|
SerId
|
Identification of Services
|
varchar(15)
|
Null
|
|
HouId
|
Identification of Houses
|
varchar(15)
|
Null
|
|
EmpId
|
Identification of Employees
|
varchar(15)
|
Null
|
|
ExpId
|
Identification of Expatriates
|
varchar(15)
|
Null
|
Table 2: HRRSS Data dictionary
| 
