Database - ERM - A Level AQA

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