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

Amenan Anne Mary Kouassi-kouadio; Petemanagnan Jean-Marie Ouattara; N’Da Akoua Alice Koua-Koffi; Talnan Jean Honore Coulibaly; Lacina Coulibaly

doi:doi:10.11648/j.ijema.20221005.11

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

Amenan Anne Mary Kouassi-kouadio, Petemanagnan Jean-Marie Ouattara, N’Da Akoua Alice Koua-Koffi, Talnan Jean Honore Coulibaly, Lacina Coulibaly

Published in International Journal of Environmental Monitoring and Analysis (Volume 10, Issue 5)

Received: 1 August 2022 Accepted: 24 August 2022 Published: 8 September 2022

Views: Downloads:

Download PDF

Share This Article

Twitter
Linked In
Facebook

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), 2024. 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

Plain Text BibTeX RIS

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

Amenan Anne Mary Kouassi-kouadio

Laboratory of Environment and Aquatic Biology, Department of Sciences and Environment Management, Nangui Abrogoua University, Abidjan, Ivory Coast
Petemanagnan Jean-Marie Ouattara

Laboratory of Environment and Aquatic Biology, Department of Sciences and Environment Management, Nangui Abrogoua University, Abidjan, Ivory Coast
N’Da Akoua Alice Koua-Koffi

Department of Agronomic, Forestry and Environmental Engineering, University of Man, Man, Ivory Coast
Talnan Jean Honore Coulibaly

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

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

Download PDF

Sections

Plain Text BibTeX RIS

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