Which operator in Relational Algebra is used to combine two relations and display all unique values from both?

UNION (U)

True or False: In a relational database, a NULL value is considered the same as an empty string.

False. NULL values indicate unknown or missing data and are distinct from empty strings.

Riddle: I connect tables with shared fields, ensuring data integrity and relationships, what am I?

Foreign Key

Fill in the blank: The structure of a relation is defined by a ______, which includes its attributes.

Relational Schema

Which of the following is a feature of the Relational Model? A) Hierarchical structure B) Use of tables C) Object-oriented design D) Document-oriented storage

B) Use of tables

What is the primary purpose of normalization in the relational model?

To eliminate redundancy and ensure data integrity.

Fill in the blank: The number of tuples in a relation is referred to as its ______.

Cardinality

True or False: The projection operator in Relational Algebra allows for the selection of specific rows from a relation.

False. The projection operator selects specific columns, not rows.

Which relational algebra operator retrieves tuples based on a specified condition?

Selection (σ)

Riddle: I define the range of possible values for an attribute in a relation, what am I?

Domain of an Attribute