DBMS-Relational Algebra and Calculus Questions and Answers

In 1980 Dr. E.F. Codd was working with Oracle Corporation.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               

DB2, System R, and ORACLE are examples of relational DBMS.

In the RDBMS terminology, a table is called a relation.

The relational model is based on the core concept of relation.

Cardinality of a table means the number of columns in the table.

In the RDBMS terminology, an attribute means a column or a filed.

A domain is a set of atomic values

Data values are assumed to be atomic, which means that they have no internal structure as far as the model is concerned.

A table cannot have more than one attribute, which can uniquely identify the rows.

A candidate key is an attribute that can uniquely identify a row in a table.