A Relational Database Model stores data in the form of tables . Each table contains: Rows → Individual records Columns → Attributes or fields Tables can be connected using common fields called keys . Terminologies 1. Table A collection of related data arranged in rows and columns. Example: ID Name Population 1 Palakkad 130000 2 Thrissur 315000 2. Row (Record) Represents one feature or entry. 👉 Example "Palakkad" is one record. 3. Column (Field / Attribute) Represents one property of data. 👉 Example Population is a field. 4. Primary Key A unique field used to identify each record. 👉 Example ID column. 5. Foreign Key A field used to connect two tables. Example in GIS (QGIS / ArcGIS) Suppose you have: Table 1: District Boundary Layer District_ID District_Name 1 Palakkad 2 Malappuram Table 2: Rainfall Data District_ID Rainfall 1 2200 mm 2 2800 mm 👉 Both tables share District_ID Using this field, GIS joins rainfall data to district maps. Where Used in GIS Attribute tables of...
Focused on advancing knowledge and expertise in Geography, GIS, Remote Sensing, Geographical Data Science, and Analysis, I am deeply committed to teaching and conducting research in these fields. With a keen interest in leveraging data-driven approaches for informed decision-making, I specialize in crafting maps that facilitate effective analysis and interpretation of spatial information. Assistant Professor Of Geography, PG and Research Department of Geography, Government College Chittur