Abstract
Abstract Soil maps and soil descriptions can be combined with other data sets within a geographical information system, to be used for analysis and modelling. As the amount of data to be included in such a database and the number of users of the database increase, the need for a structured approach to database design arises. In this paper, we discuss the conceptual design of a geographical database of soil information. We use an Extended Entity-Relationship (EER) model to capture the semantics and constraints of the database. The EER schema is then mapped into the relational data model. We show how the Structured Query Language (SQL) can be used to formulate sample queries that may be of interest to users of such a soil database. We also illustrate uses of the EER model in graphical formulation of database queries. Because of its high level of abstraction and intuitive simplicity, the EER model constitutes a convenient tool for both database design and formulation of database queries.
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callMore From: International journal of geographical information systems
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
