A database is used by a record label to store information about their releases. Below is the structure of two tables in the database:
tbl_Artist
ArtistID (Primary Key)ArtistNameGenretbl_Album
AlbumID (Primary Key)AlbumTitleReleaseYearArtistIDState the foreign key in tbl_Album.
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.