A logistics company uses a database to track its delivery operations. Below is the structure of two tables within this database:
tbl_Courier
CourierID (Primary Key)FullNameVehicleTypetbl_Consignment
ConsignmentID (Primary Key)DestinationPostcodeWeightKgCourierIDState the foreign key in tbl_Consignment.
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.