WorksheetsUnit 2.1 - Intro & Entity Relationship Modelling
Total questions: 11
Worksheet time: 7mins
What does RDBMS stand for?
(a)
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
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?
(a)
Databases is the most fun subject to exist (Select all answers that apply)
True
True
True
False
What is typically the primary key of a link table?
New primary key you make yourself
Fields in the table
Composite key made up of the two primary keys from the original many-to-many problem
A super key made up of foreign keys and primary keys
