FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: The Relational Database Model

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Short Answer

Review LaterAdd Note

Review Later

Proper data design requires carefully defined and controlled data redundancies to function properly.

Correct Answer

verified

Show Answer

Question 22

Short Answer

Review LaterAdd Note

Review Later

The relationship is the relational database norm.

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

The CUSTOMER table's primary key is CUS_CODE.The CUSTOMER primary key column has no null entries,and all entries are unique.This is an example of integrity.

RDBMSs enforce integrity rules automatically.

As rare as 1:1 relationships should be,certain conditions absolutely require their use.

In a relational model,are also used to establish relationships among tables and to ensure the integrity of the data.

Relational algebra defines the theoretical way of manipulating table contents using relational operators.

__ logic,used extensively in mathematics,provides a framework in which an assertion (statement of fact) can be verified as either true or false.

The is actually a system-created database whose tables store the user/designer-created database characteristics and contents.

The DIVIDE operation uses one single­column table (e.g.,column "a")as the divisor and one two­column table (e.g.,columns "a" and "b")as the dividend.

_____ relationships can be implemented by creating a new entity in 1:M relationships with the original entities.

__ is the real power behind the relational database,allowing the use of independent tables linked by common attributes.

A key is defined as a key that is used strictly for data retrieval purposes.

__ ,also known as RESTRICT,yields values for all rows found in a table that satisfy a given condition.

The relationship is the "relational model ideal."

The one­to­many (1: M)relationship is easily implemented in the relational model by putting the foreign key of the "1" side in the table of the "many" side as a primary key.

The DIFFERENCE operator subtracts one table from the other.

A table is also called a(n)because the relational model's creator,E.F.Codd,used the two terms as synonyms.

A(n) is an orderly arrangement used to logically access rows in a table.

A is the primary key of one table that has been placed into another table to create a common attribute.