Summary Gis Final Based On Final Exam Review Questions And Answers (Latest Update 2023)

flat file database {Ans: } stores rows of information in a text or binary file, not efficient for search and queryHierarchical database {Ans: } has multiple files, each of which contains different records and fields (parent-child linked through a key, fixed/predefined relationship), efficient for specific queriesrelational database {Ans: } Widely used in GIS: has multiple tables stored as files. the relationships are not defined ahead of time, the user can associate two tables if they share a common field called a join (same as Hierarchical, but flexible)Join table/source table v.s target/destination table {Ans: } The table that contains the information to be appended is the join table while the table that receives the appended information is called the target tableunmatched records in joins- values {Ans: } when a target record has no match in the join tableRule of Joining {Ans: } each record in the destination table must have one and only one matching record in the source tablecardinality that follow the rule of joining {Ans: } one-to-one and many-to-onerelate v.s. join {Ans: } relates used in the case of one to many because it can not be joined and displayed as a single table. tables remain separate but are