Data manipulation (databases) — IGCSE Information And Communication Technology (0417) questions by topic

A bookshop is setting up a database of the books that it sells. Part of the database is shown. Nameofbook Typeofbook Price Dateofpublication --- --- --- --- Baines Brief Lives N…

Describe the differences between a flat file database and a relational database.

You are now going to prepare a report. Dates must be imported in the format day month year (DMY). Make sure all required data is fully visible. Use database software to import the…

Import the file j2521access.csv as a new table in your database. Set all data types to text. Set AAcode as the primary key. Place in your Evidence Document a screenshot showing…

Examine the file j2521class.csv and identify the most appropriate data to use as a primary key. Close this file. Import the file j2521class.csv as a new table in your database.…

Create one-to-many relationships as links between: - the AAcode field in the access table and the AAcode field in the learners' table - the primary key field in the class table…

Add the following as a new record in the learners' table: Field Value --- --- Surname Norris Forename Emma Gender Female Learnerno 10218427 DOB 10/07/2009 Telephone 0770090457…

Using fields from all the tables produce a tabular report that: - selects the records where: - Gender is Female - Accessarrangement includes the text time - shows only the fields…

Using fields from all the tables produce labels which: - select the records where: - AAcode is AA01 - Classcode includes the numbers 5 or 6 - are sorted in descending order of…

You are now going to prepare some reports. Make sure all required data is fully visible. Use database software to import the file j2522runners.csv as a new table. Use these field…

Import the file j2522group.csv as a new table in your database. Set all the data types to text. Set Catcode as the primary key. Place in your Evidence Document a screenshot…

Create a one-to-many relationship between Catcode in the group table and Category in the runners' table. Place in your Evidence Document a screenshot showing the one-to-many…

Add the following as a new record in the runners' table: Field Value --- --- Firstname Nina Lastname Harris Raceno 2512 Category FSN30 YOB 2000 Age 25 PaceKM 0.002961065 SpeedKM/h…

Using fields from both tables, produce a tabular report that: - selects the records where: - Category starts with F - Categoryrank is 1 or 2 - shows only the fields Category,…

Task 3 - Database (Steps 11-18). Build and query a relational database for Tawara Tots Childcare. Steps: (11) import j2421child.csv as a new table with correct field types and…

Task 3 - Database (Steps 13-17). Build and query a relational database for Tawara Agricultural College. Steps: (13) import j2422students.csv as a new table (11 fields, correct…

Task 3 - Database (Steps 14-19). Build and query a relational database. Steps: (14) import n2402students.csv as a new table (10 fields, correct types; DOB DMY dd-MMM-yy, Duration…

Task 3 - Database (Steps 15-21). Build a relational database from the results, starttimes and catcodes CSV files and produce reports. Steps: (15) import Results table (11 fields,…

Task 3 - Database (Steps 15-21). Build a relational database from the race and clubs CSV files and produce a form and reports. Steps: (15) import Race table (10 fields, PK BibNo);…

Task 3 - Database (Steps 16-22). Build a relational database from the vgames and platforms CSV files and produce reports. Steps: (16) import VGames table (9 fields, PK GameCode,…