Basic Math Flashcards

Front

What is 2 + 2?

Back

4

Front

What is the square root of 16?

Back

4

Front

What is 5 * 6?

Back

30

Front

What does a NULL value for a primary key imply?

Back

It implies that we cannot identify some tuples, making it difficult to distinguish between them.

Front

What are key constraints and entity integrity constraints?

Back

They are specified on individual relations to ensure that each tuple can be uniquely identified.

Front

What is a referential integrity constraint?

Back

It is specified between two relations to maintain consistency among tuples, ensuring that a tuple in one relation refers to an existing tuple in another.

Front

What is a foreign key?

Back

A set of attributes in one relation that references the primary key of another relation.

Front

What is the purpose of the SELECT operation in relational algebra?

Back

To select a subset of tuples from a relation that satisfies a selection condition.

Front

What does the PROJECT operation do?

Back

It selects certain columns from a relation and discards the others.

Front

What are the three standard set operations in relational algebra?

Back

UNION, INTERSECTION, and SET DIFFERENCE (MINUS).