An archaeological research group uses a relational database to log discoveries made during an excavation. The structures of two of the database tables are defined below:
tbl_Trench
TrenchID (Primary Key)DepthInMetresSupervisortbl_Artifact
ArtifactID (Primary Key)MaterialTypeEstimatedCenturyTrenchIDIdentify the foreign key in the table tbl_Artifact.
159 exam-style questions on Edexcel GCSE Computer Science Algorithms, covering Constructs for solving problems, Variables, constants and data structures, Arithmetic, relational and logical operators, Tracing algorithm output with trace tables, Types of error and correcting logic errors, Standard algorithms (sorts and searches), and Evaluating algorithm fitness and efficiency. Each one has a worked solution and a mark scheme showing where the marks go.