Unit 2.1 - Intro & Entity Relationship Modelling

What does RDBMS stand for? [This question might not work properly on mobile phones]

A simple, two-dimension data table is known as a ​ ​ (a)   while a database that connections multiple tables together through some relationship is known as a ​ (b)  

• Flat File database
• Relational Database
• Microsoft Excel
• Equation
• Field
• Entity
• Database
• Variable

Data is divided up into defined...​ ​ ​ (a)   A table is sometimes called a...​ (b)   Each row of data is called a... ​ (c)   ​ ​

• Relation
• Cardinality
• Record or Tuple
• Field or Attribute
• Domain

The number of unique values for a given field is known as its... ​ (a)   ​ The number of acceptable values for a field is known as its... ​ (b)  

• Relation
• Cardinality
• Record or Tuple
• Field or Attribute
• Domain

This table represents the subscription details for a magazine company. It links to tables on customers and products.

What is the Primary Key of the Table?

Lets test your knowledge... Match these people to their last names

• No last name...

• 
• Miss. Turner

• 
• Mr. Gullit

• 
• Mr. Luther

• 
• Miss. Spears

• 

This table represents the subscription details for a magazine company. It links to tables on customers and products.

What two fields are examples of Foreign Keys in this table?

This table represents the subscription details for a magazine company. It links to tables on customers and products.

Select the cell that shows the SubID for the record with ProductID P47

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.

Match the following

• Designed for distributed multi-user DBs

• Desktop Systems

• Need to buy a license

• Client-server database systems

• Available to public for free

• Open Source

• Designed for personal use

• Proprietary