Font size
WorksheetsDatabase - ERM - A Level AQA
Total questions: 10
Worksheet time: 5mins
What does ERM stand for
Enhanced Relationship Modelling
Entity Relation Modelling
Entity Relationship Modelling
What does ERD stand for
Entity Relationship Diagram
Entity Relation Diagram
Entity Relationship Diagnostics
Which is not a valid relationship between entities
one to one
one to many
none to none
In a relational database what is another term for table
attribute
relation
relationship
A record is represented as a
row
column
grid
Which is not a type of database
SQL
NoSQL
Swift
What is a Primary Key
an identifier which uniquely identifies a particular record
a set of 2 or more attributes
a numeric field
What is a composite primary key
two or more attributes
two or more attributes to uniquely define a record
two or more numeric fields
What is represented in the column of a relation
table
record
attribute
What is a foreign key - choose 2
an attribute that creates a join between two relations
an attribute which is the primary key in the first relation
an attribute which is not used in any relation
