O-LevelComputer ScienceDatabases2210/22 · May/June 2025 · Q96 Marks
A database table, CapitalCity, stores data about capital cities from around the world. Field | Description ------|------------- Identification | a unique identifier Name | the name of the city Country | the name of the country in which the city is located Continent | the name of the continent in which the city is located Population | the number of people living in the city Founded | the year the city was founded AverageIncome | average income of the city's population, in $, rounded to 2 decimal places Subway | whether or not the city has an underground railway system
- (a)Complete the table by writing one appropriate field from CapitalCity for each data type. Each field must be different. Data type | Field ----------|------ Boolean | integer | real | text |[2]
- (b)Complete the structured query language (SQL) statement to list only the name, country and population of all the cities in CapitalCity from the continent of Asia. SELECT ..................................................................................................... FROM CapitalCity WHERE ..................................................................................................... ;[4]
Mark scheme
Marking points from the official mark scheme (May/June 2025). The mark or mark type is shown in brackets.
- [2] (a) Two marks for all four fields correctly identified One mark for two or three fields correctly identified Data type | Field ----------|------ Boolean | Subway integer | Population // Founded // Identification real | AverageIncome text | Name // Country // Continent // Identification
- [4] (b) One mark per mark point MP1 All correct fields in SELECT MP2 Correct use of key word FROM MP3 Correct field in WHERE: Continent MP4 Correct criterion in WHERE: "Asia" // 'Asia' Correct code: SELECT Name, Country, Population FROM CapitalCity WHERE Continent = "Asia"; // 'Asia';
Write your answer and get it marked
On Oracle Prep you can write or photograph your own answer and have it marked by AI against this mark scheme, with feedback on what you missed.
Sign up free →