Liste des
abréviations
INPP
|
Institut National de Préparation Professionnelle
|
VB
|
Visual Basic
|
SGBD
|
Système de Gestion de Base de Données
|
RDC
|
République Démocratique du Congo
|
S.I
|
Système d'Information
|
SP
|
Système de Pilotage
|
SOP
|
Système Opérant
|
BDD
|
Base De Données
|
OS
|
Operating System
|
NB
|
Noté Bien
|
CODD
|
Contrôle De Données
|
BDDR
|
Base De Données Relationnelle
|
ESFORCA
|
Ecole Supérieur de Formation de Cadre
|
WWW
|
World Wide Web
|
CIF
|
Contrainte d'Intégrité Fonctionnelle
|
MCD
|
Modèle Conceptuel de Données
|
MCT
|
Modèle Conceptuel de Traitement
|
MOD
|
Modèle Organisationnel de Données
|
MLD
|
Modèle Logique de Données
|
MPD
|
Modèle Physique de Données
|
|
|
Liste des figures
Figure 1: Structure organisationnelle d'un
système
3
Figure 2: Exemple du modèle
hiérarchique
13
Figure 3: exemple du modèle réseau
14
Figure 4: Organigramme du service
concerné
24
Figure
5: Exemple d'un contrat d'engagement
25
Figure
6: Exemple d'une fiche d'engagement
26
Figure 7: Présentation du MCD
40
Figure 8: Présentation du MCT
42
Figure 9: Présentation du modèle
organisationnel de données
44
Figure 10: Présentation du MLD Brut
46
Figure 11: Présentation du MLD
Validé
48
Liste des tableaux
Tableau 1: Etudes des moyens matériels
3
Tableau 2: Commentaires sur le schéma de
circulation des informations
31
Tableau 3: Description des objets
37
Tableau 4: T-contrat
49
Tableau 5: T- présence
49
Tableau 6: T-service
50
Tableau 7: T- contrat
50
Tableau 8: T-rapport
50
INTRODUCTION
Computer management discipline is a set of all knowledge, techniques and tools
to ensure data management and more specifically the organization of information
system.
An information system should be organized, finished and controlled. It is a
means an optimization of the performance of the company average. How to set up
a database that can help manage a business? The answer to this question is
focus on the present study.
O.1. PRESENTATION OF THE
TOPIC
The title of this work is 'Design and
implementation of a database for personnel management' (case of a Branch of the
National Institute for Vocational Preparation). The basis for setting up data
will serve as a storage place for available all data related to personnel. The
processing of this data will produce information for users, and will facilitate
perform some basic tasks related to personnel management.
O.2 THE PROBLEM
The problem is the set of issues
concerning a theme and shows the strength and necessity of research questions.
In our work, the problem is the question that we will try to answer.
The construction of the problem is based on an
exposed part of the sentence which reflects the implied (hidden meaning) and
allows to highlight the logic between the terms of the subject links view. The
problem does not require a definition of a word. It involves a reformulation
which may be in the form of a paradox.
Nowadays the number of staff that will
gradually weigh in our institutions, they get into trouble because of
unavailability in the management of personnel: in the case of the National
Institute for Vocational Preparation which is a public establishment of service
with good reputation for leadership training. The personnel management is
manual and managers are experiencing many difficulties; those workers for
example to detect assigned to such service and are in such province.
As the system is manual, the INPP cannot master the management
of its staff.
The identified difficulties are expressed as follow:
- How can we help the National Institute of Vocational
Preparation to have good command concerning the personnel management using
computer?
- As a computer scientist, which information system should
be put in installed to menage the staff?
- How will this new system be relevant?
|