1.4 - Data Structures & Relational Thinking

Question 1

Why is it important to understand how data is organized?

Answer 1

Understanding data structure helps you find, connect, and analyze information efficiently.

Question 2

What is relational thinking in data analysis?

Answer 2

It’s the idea that data is stored in related tables and can be connected using shared fields (keys).

Question 3

What is a table in data terms?

Answer 3

A collection of data organized into rows and columns, where each row is a record and each column is a field.

Question 4

A single row in a table is called a ______.

Answer 4

Record

Question 5

A single column in a table is called a ______.

Answer 5

Field

Question 6

Which of these is an example of a key that connects tables?
A) Customer ID
B) Product description
C) Sales amount
D) Date of purchase

Answer 6

A) Customer ID

Question 7

Why might tables be related to each other in a database?
A) To store duplicate data
B) To link information logically for analysis
C) To make spreadsheets bigger
D) To confuse analysts

Answer 7

B) To link information logically for analysis

Question 8

What is a primary key?

Answer 8

A field in a table that uniquely identifies each record.

Question 9

What is a foreign key?

Answer 9

A field in one table that refers to the primary key of another table, creating a relationship between tables.

Question 10

Organizing data into separate but related tables is called ______.

Answer 10

Relational database design

Question 11

Give an example of relational thinking in everyday data.

Answer 11

Examples: linking customer info with orders, student info with course enrollments, employees with departments.

Question 12

Why is relational thinking important for analysis?

Answer 12

It allows you to combine different datasets logically, avoid duplication, and extract meaningful insights.