Relational Algebra And Calculus

Question 1

Relational Algebra

Answer 1

A procedural language for manipulating relations.

Question 2

Procedural

Answer 2

Language that provides a step by step method for solving problems.

Question 3

Relational Calculus

Answer 3

A nonprocedural language for defining query solutions.

Question 4

Nonprocedural

Answer 4

Language that provides a means for stating what is desired rather than how to get it.

Question 5

Relationally complete

Answer 5

Having the same logical power as relational algebra or calculus.

Question 6

Union

Answer 6

Relational algebra operation that creates the set union of two union-compatible relations.

Question 7

Union Compatible

Answer 7

Two or more relations that have equivalent columns as to number and domains.

Question 8

Intersection

Answer 8

Relational algebra operation that creates the set intersection of two union-compatible relations.

Question 9

Difference

Answer 9

operation that creates the set difference of two union compatible relations.

Question 10

Subtraction

Answer 10

The relational algebra difference between Operation.

Question 11

Product

Answer 11

Relational algebra operation that creates the cartesian product of two relations.

Question 12

Select

Answer 12

Relational algebra operations that use a condition to select a condition to select rows from a relation.

Question 13

Project

Answer 13

Relational algebra operation that creates a relation by deleting columns from an existing relation.

Question 14

Projection

Answer 14

Relation resulting from a project operation.

Question 15

Join

Answer 15

Relational algebra operation that connects relations.

Question 16

Natural Join

Answer 16

Join operation that connects relations when common columns have equal values.

Question 17

Theta Join

Answer 17

Join operation that connects relations when values from specified columns have a specified relationship.

Question 18

Equiijoin

Answer 18

Theta join based on equality of specified columns.

Question 19

Outer Join

Answer 19

Expansion of the natural join that includes all rows from both relations.

Question 20

Divide

Answer 20

Relational algebra operation creates a new relation by selecting the rows in one relation that matches every row in another relation.

Question 21

Assignment

Answer 21

Relational algebra operation that gives a name to a relation.

Question 22

Target List

Answer 22

A list in a relational calculus statement that defines the attributes of the solution relation.

Question 23

Qualifying Statement

Answer 23

A condition in a relational calculus statement that restricts membership in a solution relation.

Question 24

Existential Quantifier

Answer 24

Relational calculus expression affirming the existence of at least one row to which a condition applies.

Question 25

Universal Quantifier

Answer 25

Relational calculus expression stating that some condition applies to every row of some type.