Accés restreint aux usagers connectés
Titre : | Gestion environnementale des carrières : Création d'un outil en collaboration avec LAFARGEHOLCIM |
Auteurs : | Aurore DUPUY ; Agathe ROCAFULL BARRACO |
Type de document : | Mémoire d'initiation à la recherche |
Année de publication : | 2021 |
Concepts : |
CARRIERE
BASE DE DONNEES |
Résumé : | Aggregate extraction areas in France are Installations Classified for Environmental Protection (ICEP). They are subject to regulations that vary over time and according to the department in which they are located. In order to control the impact of quarries on the environment, regular environmental monitoring is carried out. Measurements are taken to determine, for example, the quality of water discharged as well as noise levels and dust emissions. LAFARGEHOLCIM France wishes to centralise the values obtained by its various service providers in a single database. The company is looking for an easy-to-use tool, allowing it to have an overview of the water, noise and dust compliance of the sites it operates. The objective of this thesis is the creation of a functional and efficient database for the exploitation of data related to environmental monitoring in quarries (water/noise/dust) in order to optimise their management. This dissertation presents the research and the reflection carried out within the framework of the construction of the database, based on the data provided by LAFARGEHOLCIM France. Based on the understanding of the functioning and regulations of the Oise sector, it was possible to generalise the structure of the database to the whole of France. In the version provided with this thesis, the database has 36 tables. The basic queries required are functional. No forms have been added to allow time to develop them for oral presentation. In this case, only a person with knowledge of Access can complete and operate this database. Compliance is obtained for specific points of the site, there is no global vision of the compliance of the site. Furthermore, the database does not take into account the occasional modification of regulatory thresholds. |
Spécialité : | Géologie |
Numéro de promo : | 83 |
numéro MIR : | 928 |