Which relational operator combines all tuples from two relations, excluding duplicates?

Group of answer choices

A$.$ Select

B$.$ Difference

C$.$ Product

D$.$ Union

Flag this Question

Question $221$ pts

Determine the relational operator that returns a horizontal subset of a relation.

Group of answer choices

A$.$ DIFFERENCE

B$.$ JOIN

C$.$ SELECT

D$.$ UNION

Flag this Question

Question $231$ pts

What is the purpose of relational algebra in a database?

Group of answer choices

A$.$ Determine table relations

B$.$ Manipulate relations

C$.$ Show data from two relations

D$.$ Prevent duplications

Flag this Question

Question $241$ pts

From the table below, what is the result of Table $1$ INTERSECT Table $2?$

Table $1$

$72$ TABLE $1.$JPG

Table $2$

$72$ TABLE $2.$JPG

Group of answer choices

A$.$ Jane, Muriel, Elaine, Mari

B$.$ Elaine, Mari, Jane, Muriel, Jane, Elaine

C$.$ Jane, Elaine

D$.$ Jane, Elaine, Mari

Flag this Question

Question $251$ pts

What other name refers to derived attributes?

Group of answer choices

A$.$ Composite attributes

B$.$ Computed attributes

C$.$ Multivalued attributes

D$.$ Relational attributes

Flag this Question

Question $261$ pts

You are determining the number of instances of one entity that are associated with one instance of a related entity. Which relationship constraint are you using?

Group of answer choices

A$.$ Association

B$.$ Cardinality

C$.$ Multiplicity

D$.$ Relationship