O-LevelComputer ScienceDatabases2210/22 · May/June 2023 · Q106 Marks
A music streaming service has a new database table named Songs to store details of songs available for streaming. The table contains the fields: • SongNumber - the catalogue number, for example AG123 • Title - the title of the song • Author - the name of the song writer(s) • Singer - the name of the singer(s) • Genre - the type of music, for example rock • Minutes - the length of the song in minutes, for example 3.75 • Recorded - the date the song was recorded.
- (a)Identify the field that will be the most appropriate primary key for this table.[1]
- (b)Complete the table to identify the most appropriate data type for the fields in Songs Field Data type SongNumber Title Recorded Minutes[2]
- (c)Explain the purpose of the structured query language (SQL) statements. SUM (Minutes) FROM Songs WHERE Genre = "rock"; COUNT (Title) FROM Songs WHERE Genre = "rock";[3]
Mark scheme
Marking points from the official mark scheme (May/June 2023). The mark or mark type is shown in brackets.
- [1] SongNumber
- [2] One mark for every two correct data types Field Data Type SongNumber Text/Alphanumeric Title Text/Alphanumeric Recorded Date/time Minutes Real
- [3] One mark for each point • to find the total number of minutes of music • to find the total number of songs • available for the genre rock
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 →