Unit 2.1 - Intro & Entity Relationship Modelling

What does RDBMS stand for?

Which of these is NOT one of the main purposes for using a RDBMS like Microsoft Access?

• Data Storage

• Data Retrieval

• Data Analysis Visualisation

• Data Manipulation

Answer explanation

Whilst data visualisation is possible in Microsoft Access (such as through charts), its main purpose is not this.

It would be more appropriate to take the data required for analysis, and then analyse it in a separate programme such as Microsoft Excel or Tableau.

Which of these Entity Relationship Types is inefficient and should be avoided?

• One-to-One

• One-to-Many

• Many-to-Many

• Primary Key

Which song topped the UK charts Sumer 2025?

• Love Me Not

  Ravyn Lenae

• Ordinary

  Alex Warren

• Manchild

  Sabrina Carpenter

• Pink Pony Club

  Chappell Roan

St Thomas More has lots of pupils.

How would you represent this using an E-R Diagram?

A field which can uniquely identify one record in a table is typically known as a ...

• Super Key

• Primary Key

• Foreign Key

• Modem Key

When a Primary Key from one table is used as a link in another table, this is known as a ...

• Candidate Key

• Abroad Key

• Foreign Key

• Super Key

Which of these is the correct definition of candidate key?

• A key which is used as candidates in multiple table

• A field which represents the various candidates within a database

• A field which could potentially be used as the primary key

• A key which could potentially be used as a foreign key

What do we need to use to overcome a many-to-many problem?

Databases is the most fun subject to exist (Select all answers that apply)

• True

• True

• True

• False