Timedora
Free Online Flashcard Deck

Relational Tables and Keys Free Online Flashcards

Study Relational Tables and Keys with 12 free online flashcards. Review key terms, definitions, and concepts with this interactive flashcard deck.

12 cards
01
Front

What is a relational table?

Back

A relational table, or relation, organizes information into rows and columns.

02
Front

What is a row in a relational table called?

Back

Rows in a relational table are called tuples.

03
Front

What is a column in a relational table called?

Back

Columns in a relational table are called attributes.

04
Front

What is defined for each column in a relational table?

Back

Each column in a relational table has a defined type.

05
Front

What role does a primary key play?

Back

A primary key identifies rows in a table.

06
Front

What role does a foreign key play?

Back

A foreign key links rows between tables.

07
Front

In a relational table, what are the terms for rows and columns?

Back

Rows are tuples; columns are attributes.

08
Front

What two parts make up a relational table?

Back

A table consists of rows, also called tuples, and columns, also called attributes.

09
Front

How do the roles of primary and foreign keys differ?

Back

A primary key identifies rows; a foreign key links rows between tables.

10
Front

Which kind of key identifies rows in a table?

Back

The primary key identifies rows in a table.

11
Front

Which kind of key links rows between tables?

Back

The foreign key links rows between tables.

12
Front

Which are tuples: rows or columns?

Back

Rows are the table's tuples, while columns are its attributes.