Question Constellation Sign up for free AQA · GCSE · Computer Science · Higher
Actor table field identifiers
A relational database is being developed to store information about actors and the films they have performed in.
The database contains three tables: Film, Performance and Actor. Some of the contents of the tables are shown in Figure 8.
State the identifier of a field from the Actor table in Figure 8.
Write your answer first. You can study the marking guidance whenever you need it.
Study the marking See what earns credit and compare it with a full-mark answer.
Marking points
- 1 States one of ActorID, Firstname or Lastname.
Full-mark answer
ActorID
Why this answer loses marks
I copied a value from one row of the table.
The question asks for a field identifier from the target table, not a stored row value or a table name.