Analysis, Design and Implementation of a Pilot Relational Database for Groundwater in the State of Arkansas
Data, groundwater, system analysis
There are several agencies within the state of Arkansas dealing with underground water. Each agency has its own database that acts as an isolated depository of data. Practically, the communication among these databases is zero, not because there is no need for it, but because the communication is very difficult if not impossible. Data redundancy, inconsistency, and lack of integrity is overwhelming. In this study we have addressed the problem of lack of unity among the databases belonging to different agencies. Also, as an alternative we have developed a relational database. In this database the data was normalized to 4NF. This pilot program uses the ORACLE Database Management System. It deals with data for 38 water wells. For each well more than 300 data attributes have been collected where available.
Hashemi-Nassab, Ray. 1989. Analysis, Design and Implementation of a Pilot Relational Database for Groundwater in the State of Arkansas. Arkansas Water Resources Center, Fayetteville, AR. PUB144. 77
Fresh Water Studies Commons, Hydrology Commons, Soil Science Commons, Water Resource Management Commons