| Peer-Reviewed

Design of a Relational Database for the Management of Crop Residues in Agricultural Regions: Case of the Agricultural Basin of Sassandra – Ivory Coast

Received: 1 August 2022     Accepted: 24 August 2022     Published: 8 September 2022
Views:       Downloads:
Abstract

The management of crop residues remains a major concern for the populations of regions with strong agricultural activity, because their poor management is often a source of disease. Also the absence of a consolidated database of the quantities of agricultural waste actually produced in the localities makes it difficult to exploit them. This work aims to set up a relational database making it possible to obtain information on the quantities of residues available in the localities. The quantities were estimated using agricultural statistics data from the Ministry of Agriculture and residue productivity indices. The approach adopted is the MERISE method which requires a study of the existing as well as a formalization based on the entity-association model and the use of a relational database management system, then a programming language oriented object. The result of this work is a user-friendly interface that makes it easy to enter and to view crop residue data. Thus, the “bddechetagro” database set up contains useful data for an overall assessment of the problem. She will allow operators wishing to process crop residues in recovery units to acquire information on the desired residues. Thus, from a query, it is possible to obtain the list of residues available in the basin, residues available in a locality, residues available by locality and by type of residue, information on a residue from the name, to obtain information from a producer of residue.

Published in International Journal of Environmental Monitoring and Analysis (Volume 10, Issue 5)
DOI 10.11648/j.ijema.20221005.11
Page(s) 111-119
Creative Commons

This is an Open Access article, distributed under the terms of the Creative Commons Attribution 4.0 International License (http://creativecommons.org/licenses/by/4.0/), which permits unrestricted use, distribution and reproduction in any medium or format, provided the original work is properly cited.

Copyright

Copyright © The Author(s), 2022. Published by Science Publishing Group

Keywords

Data Modeling, Merise, Database, Sassandra Watershed, Ivory Coast

References
[1] GBN (2020). Partnership Ready Ivory Coast: Management and recycling of organic waste. 8p. Available on: https://www.giz.de/en/downloads/GBN_Sector%20Brief_CIV_Bioabfall_FR_Web.pdf
[2] Mrad F. (2017) Decomposition of crop residues and bio-based materials: impact on agricultural soil microbial communities and associated functions. Agricultural sciences. Normandy University, 2018. French.
[3] MAAF (2015) Contribution of agriculture to the fight against climate change: Stéphane LE FOLL announces the launch of an international research project: the "4 per 1000". March 17 press release. http://agriculture.gouv.fr/contribution-de-lagriculture-la-lutte-contre-le-changement-climatique-lancement-dun-projet-de de.
[4] Thiebeau, P., Recous, S. (2017). Crop residues decomposition dynamics in farms practising conservation agriculture in the Grand Est region, France. Cah. Agric. 26: 65001. DOI: 10.1051/cagri/2017050.
[5] Bangoura, M. R. (2017) Management of household solid waste and socio-spatial segregation in the city of Conakry (Guinea) doctoral thesis, Toulouse University - Jean Jaurès, 560p.
[6] Sunderic, D and Woodhead, T. (2001) SQL Server 2000: Stored Procedure Programming. McGraw-Hill Professional: Berkeley, c CA, 732p.
[7] Ruf, F. and Agkpo, Jean L. (2008) Study on the income and investments of coffee and cocoa producers in the Ivory Coast: final report. s.l.: s.n., 115 p. https://agritrop.cirad.fr/548837/
[8] Girard, G., Sircoulon, J. and Touchebeuf, P. (1971) Fundamentals of Conceptual Modeling of 3D Geospatial Databases. International Review of Geomatics, 16 (1), 9-28.
[9] INS. (2014 Statistics of the population of the Ivory Coast. National Institute of Statistics. 44p.
[10] FAO (1998). Proceedings of the regional expert consultation on modern application of biomass energy. FAO Regional Wood Energy Development programme in Asia, Report 36, Bangkok, 22p.
[11] Wojda, P., Brouyère, S. and Dassargues, A. (2010) Geospatial information in hydrogeological studies. In: Malcolm G, Angerson (eds) Encyclopedia of hydrogeological sciences. Wiley, Chichester, UK. https://doi.org/10.1002/0470848944.hsa304
[12] Larrivée, S., Bédard, Y. and Pouliot, J. (2006 foundation of Conceptual Modeling of 3D Geospatial Databases. International Review of Geomatics, 16 (1), 9-28.
[13] Tardieu, H. (1991) Information-strategic system and strategic information systems, in Around and around Merise: design methods in perspective, Proceedings of the AFCET-CERAM congress, April 17-18-19, 1991, Sophia-Antipolis, publication AFCET, 1991.
[14] Nanci, D., Espinasse, B. with the collaboration of B. Cohen, J. C. Asselborn and H. Heckenroth (2001), “Information systems engineering: Merise second generation”, Vuibert editions, Paris. ISBN: 2-7117-8674-9, 416 p.
[15] Coulibaly L., Ouattara J-M. P. and Tiho, S. (2012 bBiogas potential of agro-pastoral residues and human excrement in the Sassandra River watershed (Ivory Coast). Int. J. Biol. Chem. Sci. 6 (6): 6003-6016. DOI: 10.4314/ijbcs.v6i6.28.
[16] Konan-Waidhet, AB., Kouadio, K. E., Dibi, B. AKE, G. E and Savane, I. (2010) Contribution to the creation of a Conceptual spatial database of 3D Geospatial Databases. International Review of Geomatics, 16 (1), 9-28.
[17] Konan-Waidhet, A. B., Dibi, B., Kouadio K. E., Savane I. and Gabriel, L. (2013) Contribution of geospatial techniques for the analysis of the productivity of fissured aquifers in the Dioulatiedougou region (Nord-Ouest de la Ivory Coast) Int. J. Biol. Chem. Sci. 7 (6): 2611-2625. DOI: 10.4314/ijbcs.v7i6.35.
[18] Ellis, E. A., Bentrup, G. and Schoeneberger, M. M. (2004) Computer-based tools for decision support in agroforestry: Current state and future needs. Agroforestry Systems, 61, 401–421. https://doi.org/10.1023/b:agfo.0000029015.64463.65
[19] Sahri, S. (2006) Design and Implementation of a Distributed & Scalable Database System: SD-SQL Server. Doctoral thesis in Computer Science, Paris Dauphin University, Applied Computer Science Research Center, Paris, France, 191 p.
[20] Coulibaly, N. (2009) Design of a decision support tool for the integrated management of water resources in the Denguelé region (Ivory Coast), Doctoral thesis University of Abobo-Adjamé, 156p.
[21] FIRCA (2009). The Progress Sector - Oil Palm, FIRCA Bulletin, n°5-3rd quarter Ivory Coast, 45p.
[22] Ghyselinck, L. (2006) Realization of a computer application for clinical follow-up in canine patients. Doctoral thesis, Faculty of Medicine of Créteil, France, 104 p.
Cite This Article
  • APA Style

    Amenan Anne Mary Kouassi-kouadio, Petemanagnan Jean-Marie Ouattara, N’Da Akoua Alice Koua-Koffi, Talnan Jean Honore Coulibaly, Lacina Coulibaly. (2022). Design of a Relational Database for the Management of Crop Residues in Agricultural Regions: Case of the Agricultural Basin of Sassandra – Ivory Coast. International Journal of Environmental Monitoring and Analysis, 10(5), 111-119. https://doi.org/10.11648/j.ijema.20221005.11

    Copy | Download

    ACS Style

    Amenan Anne Mary Kouassi-kouadio; Petemanagnan Jean-Marie Ouattara; N’Da Akoua Alice Koua-Koffi; Talnan Jean Honore Coulibaly; Lacina Coulibaly. Design of a Relational Database for the Management of Crop Residues in Agricultural Regions: Case of the Agricultural Basin of Sassandra – Ivory Coast. Int. J. Environ. Monit. Anal. 2022, 10(5), 111-119. doi: 10.11648/j.ijema.20221005.11

    Copy | Download

    AMA Style

    Amenan Anne Mary Kouassi-kouadio, Petemanagnan Jean-Marie Ouattara, N’Da Akoua Alice Koua-Koffi, Talnan Jean Honore Coulibaly, Lacina Coulibaly. Design of a Relational Database for the Management of Crop Residues in Agricultural Regions: Case of the Agricultural Basin of Sassandra – Ivory Coast. Int J Environ Monit Anal. 2022;10(5):111-119. doi: 10.11648/j.ijema.20221005.11

    Copy | Download

  • @article{10.11648/j.ijema.20221005.11,
      author = {Amenan Anne Mary Kouassi-kouadio and Petemanagnan Jean-Marie Ouattara and N’Da Akoua Alice Koua-Koffi and Talnan Jean Honore Coulibaly and Lacina Coulibaly},
      title = {Design of a Relational Database for the Management of Crop Residues in Agricultural Regions: Case of the Agricultural Basin of Sassandra – Ivory Coast},
      journal = {International Journal of Environmental Monitoring and Analysis},
      volume = {10},
      number = {5},
      pages = {111-119},
      doi = {10.11648/j.ijema.20221005.11},
      url = {https://doi.org/10.11648/j.ijema.20221005.11},
      eprint = {https://article.sciencepublishinggroup.com/pdf/10.11648.j.ijema.20221005.11},
      abstract = {The management of crop residues remains a major concern for the populations of regions with strong agricultural activity, because their poor management is often a source of disease. Also the absence of a consolidated database of the quantities of agricultural waste actually produced in the localities makes it difficult to exploit them. This work aims to set up a relational database making it possible to obtain information on the quantities of residues available in the localities. The quantities were estimated using agricultural statistics data from the Ministry of Agriculture and residue productivity indices. The approach adopted is the MERISE method which requires a study of the existing as well as a formalization based on the entity-association model and the use of a relational database management system, then a programming language oriented object. The result of this work is a user-friendly interface that makes it easy to enter and to view crop residue data. Thus, the “bddechetagro” database set up contains useful data for an overall assessment of the problem. She will allow operators wishing to process crop residues in recovery units to acquire information on the desired residues. Thus, from a query, it is possible to obtain the list of residues available in the basin, residues available in a locality, residues available by locality and by type of residue, information on a residue from the name, to obtain information from a producer of residue.},
     year = {2022}
    }
    

    Copy | Download

  • TY  - JOUR
    T1  - Design of a Relational Database for the Management of Crop Residues in Agricultural Regions: Case of the Agricultural Basin of Sassandra – Ivory Coast
    AU  - Amenan Anne Mary Kouassi-kouadio
    AU  - Petemanagnan Jean-Marie Ouattara
    AU  - N’Da Akoua Alice Koua-Koffi
    AU  - Talnan Jean Honore Coulibaly
    AU  - Lacina Coulibaly
    Y1  - 2022/09/08
    PY  - 2022
    N1  - https://doi.org/10.11648/j.ijema.20221005.11
    DO  - 10.11648/j.ijema.20221005.11
    T2  - International Journal of Environmental Monitoring and Analysis
    JF  - International Journal of Environmental Monitoring and Analysis
    JO  - International Journal of Environmental Monitoring and Analysis
    SP  - 111
    EP  - 119
    PB  - Science Publishing Group
    SN  - 2328-7667
    UR  - https://doi.org/10.11648/j.ijema.20221005.11
    AB  - The management of crop residues remains a major concern for the populations of regions with strong agricultural activity, because their poor management is often a source of disease. Also the absence of a consolidated database of the quantities of agricultural waste actually produced in the localities makes it difficult to exploit them. This work aims to set up a relational database making it possible to obtain information on the quantities of residues available in the localities. The quantities were estimated using agricultural statistics data from the Ministry of Agriculture and residue productivity indices. The approach adopted is the MERISE method which requires a study of the existing as well as a formalization based on the entity-association model and the use of a relational database management system, then a programming language oriented object. The result of this work is a user-friendly interface that makes it easy to enter and to view crop residue data. Thus, the “bddechetagro” database set up contains useful data for an overall assessment of the problem. She will allow operators wishing to process crop residues in recovery units to acquire information on the desired residues. Thus, from a query, it is possible to obtain the list of residues available in the basin, residues available in a locality, residues available by locality and by type of residue, information on a residue from the name, to obtain information from a producer of residue.
    VL  - 10
    IS  - 5
    ER  - 

    Copy | Download

Author Information
  • Laboratory of Environment and Aquatic Biology, Department of Sciences and Environment Management, Nangui Abrogoua University, Abidjan, Ivory Coast

  • Laboratory of Environment and Aquatic Biology, Department of Sciences and Environment Management, Nangui Abrogoua University, Abidjan, Ivory Coast

  • Department of Agronomic, Forestry and Environmental Engineering, University of Man, Man, Ivory Coast

  • Laboratory of Geoscience and Environment, Nangui Abrogoua University, Abidjan, Ivory Coast

  • Laboratory of Environment and Aquatic Biology, Department of Sciences and Environment Management, Nangui Abrogoua University, Abidjan, Ivory Coast

  • Sections