11 markeasy
(a)
A database table, 2018MOV, is used to keep a record of movie details.
State the number of records in the database table.
Computer Science
Databases (Cambridge International IGCSE Computer Science): Exam Questions
Exam code:047814 questions · 39 marks · ≈ 39 min
22 markseasy
1 mark
Give the name of the field that would be used for the primary key.
1 mark
Extract:
The name of the field that would be used for the primary key is:
- CatNo [1 mark]
State the reason for choosing this field for the primary key
32 markseasy
(a)
A database table, PERFORMANCE, is used to keep a record of the performances at a local theatre.
| ShowNumber | Type | Title | Date | SoldOut |
|---|---|---|---|---|
| SN091 | Comedy | An Evening at Home | 01 Sept | Yes |
| SN102 | Drama | Old Places | 02 Oct | No |
| SN113 | Jazz | Acoustic Evening | 03 Nov | No |
| SN124 | Classical | Mozart Evening | 04 Dec | Yes |
| SN021 | Classical | Bach Favourites | 01 Feb | Yes |
| SN032 | Jazz | 30 Years of Jazz | 02 Mar | Yes |
| SN043 | Comedy | Street Night | 03 Apr | No |
| SN054 | Comedy | Hoot | 04 May | No |
State the number of fields and records in the table.
42 markseasy
1 mark
(a)
A computer game shop records its stock levels in a database table called GAMES. The fields used in the stock table are shown.
| Name | Description |
|---|---|
| GameID | primary key |
| GameName | the name of each game |
| AgeRestriction | the minimum age at which a person is allowed to play each game |
| GamePrice | the selling price for each game |
| NumberStock | the quantity of each game currently in stock |
| OnOrder | whether or not each game is on order from the suppliers |
| DateLastOrdered | the date the most recent order for each game was placed |
| GameDescription | a summary of the contents and purpose of each game |
State the number of fields that are in the table GAMES.
1 mark
(b)
State one important fact that must be true for a field to be a primary key.
51 markeasy
(b)
A database table, NURSE, is used to keep a record of disposable items worn by veterinary nurses.
This is part of the table:
| ItemNumber | Description | SingleUse | Uses | StockLevel | ReorderLevel |
|---|---|---|---|---|---|
| DIG1 | Glove (pair) | Y | 1 | 500 | 800 |
| DIA1 | Apron | Y | 1 | 700 | 800 |
| DIM5 | Hair net | Y | 1 | 650 | 500 |
| DIA2 | Apron | N | 5 | 25 | 100 |
| DIS4 | Suit | N | 3 | 70 | 50 |
| DIV9 | Shoe cover (pair) | Y | 1 | 400 | 250 |
Give a reason why the field SingleUse is not required in the table NURSE.
64 markseasy
2 marks
(a)
A database table called TVRange shows the main features and prices of a range of televisions.
Give the name of the field that is most suitable to be the primary key.
State the reason for this choice.
2 marks
(b)
The database uses the data types:
- text
- character
- Boolean
- integer
- real
- date/time
Complete the table to show the most appropriate data type for each field. Each data type must be different.
| Field | Data type |
|---|---|
TVCode | |
ScreenSize | |
SmartTV | |
Price\$ |
73 markseasy
1 mark
(a)
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 AG123Title– the title of the songAuthor– the name of the song writer(s)Singer– the name of the singer(s)Genre– the type of music, for example rockMinutes– the length of the song in minutes, for example 3.75Recorded– the date the song was recorded.
Identify the field that will be the most appropriate primary key for this table.
2 marks
(b)
Extract:
- 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.
Complete the table to identify the most appropriate data type for the fields in Songs
| Field | Data type |
|---|---|
SongNumber | |
Title | |
Recorded | |
Minutes |
82 markseasy
Describe what a field is in a database.
Provide an example of a field in a student database
91 markeasy
(a)
A database table called SoftDrinks stores details of the soft drinks sold by a small shop
| Field | Example data |
|---|---|
Name | Cola |
Supplier | Cambridge Beverages |
Container | Can |
SizeCl | 330 |
NumberInStock | 30 |
ReorderLevel | 15 |
Reordered | Yes |
State whether any of the given fields would be suitable as a primary key and give a reason for your answer.
102 marksmedium
(b)
A database table, PERFORMANCE, is used to keep a record of the performances at a local theatre.
ShowNumber | Type | Title | Date | SoldOut |
|---|---|---|---|---|
| SN091 | Comedy | An Evening at Home | 01 Sept | Yes |
| SN102 | Drama | Old Places | 02 Oct | No |
| SN113 | Jazz | Acoustic Evening | 03 Nov | No |
| SN124 | Classical | Mozart Evening | 04 Dec | Yes |
| SN021 | Classical | Bach Favourites | 01 Feb | Yes |
| SN032 | Jazz | 30 Years of Jazz | 02 Mar | Yes |
| SN043 | Comedy | Street Night | 03 Apr | No |
| SN054 | Comedy | Hoot | 04 May | No |
Give two validation checks that could be performed on the ShowNumber field
114 marksmedium
2 marks
A database table contains the following fields:
- StudentID (integer)
- FirstName (text)
- LastName (text)
- DateOfBirth (date)
- Email (text)
Identify which field could benefit from a format check validation and justify your answer
2 marks
Extract:
A database table contains the following fields:
- StudentID (integer)
- FirstName (text)
- LastName (text)
- DateOfBirth (date)
- Email (text)
Identify which field would require a type check validation and justify your answer.
123 markshard
Consider the following database table for an online shopping system:
| OrderID | CustomerName | ProductCode | Quantity | PricePerUnit | TotalPrice |
|---|---|---|---|---|---|
| 1001 | John Smith | PC12345 | 3 | 19.99 | 59.9 |
Suggest two different types of validation that could be applied to the ProductCode field.
Explain why they would be important.
136 markshard
A school database is used to store information about students and their exam scores. The following fields have been identified:
StudentIDFirstNameLastNameDateOfBirthExamScorePassedExam
Describe the most appropriate data type for each of the following fields and justify your choice.
StudentIDExamScorePassedExam
146 markshard
4 marks
In a database for an online store, there are two tables: Customers and Orders.
- Customers Table:
| CustomerID | Name | PhoneNumber | |
|---|---|---|---|
| C001 | Alice Brown | alice@example.com | 0123456789 |
| C002 | Bob Smith | bob@example.com | 0987654321 |
- Orders Table:
| OrderID | CustomerID | OrderDate | TotalAmount |
|---|---|---|---|
| O001 | C001 | 2024-08-01 | 150.00 |
| O002 | C002 | 2024-08-02 | 200.00 |
Identify the primary key for each table and explain why it is suitable.
2 marks
Extract:
In a database for an online store, there are two tables: Customers and Orders.
- Customers Table:
| CustomerID | Name | PhoneNumber | |
|---|---|---|---|
| C001 | Alice Brown | alice@example.com | 0123456789 |
| C002 | Bob Smith | bob@example.com | 0987654321 |
- Orders Table:
| OrderID | CustomerID | OrderDate | TotalAmount |
|---|---|---|---|
| O001 | C001 | 2024-08-01 | 150.00 |
| O002 | C002 | 2024-08-02 | 200.00 |
Describe how you would use the CustomerID field in the Orders table to link it to the Customers table.