SQA Advanced Higher Computing Science Database Design and Development overview quiz quiz

An entity

An attribute

A relationship

A primary key

With a single shared column

With a link (junction) entity and two one-to-many relationships

It cannot be represented at all

By merging the two entities into one table

Foreign key

Composite attribute

Primary key

Index

Another foreign key

A computed column

An aggregate value

That table's primary key

Repeating groups

Transitive dependencies

Foreign keys

Partial-key dependencies

Transitive dependencies

Partial-key dependencies

Functional dependencies

Referential dependencies

Partial-key dependencies

Repeating groups

Transitive dependencies

Primary-key dependencies

SELECT

UPDATE

ALTER

INSERT

HAVING

WHERE

ORDER BY

FROM

LIKE

SUM

JOIN

ALTER

A subquery

A wildcard

A join

A computed column

Exactly one character

Only digits

Only the start of a string

Any sequence of characters

A subquery

A join

An alias

An aggregate

A foreign key elsewhere

Unique and never null

A single attribute only

Automatically generated

Is always null

Is unique across the table

Matches an existing primary key, or is null

Equals the primary key of its own table

By checking it runs without an error message

By timing how long it takes

By counting how many tables it uses

By comparing the actual rows returned against an expected result decided in advance