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

Multiple Choice

Review LaterAdd Note

Review Later

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

A) 1:N
B) M:1
C) M:N
D) 1:1

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

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

A) primary rule
B) superkey
C) relationship
D) index

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.

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

RDBMSs enforce integrity rules automatically.

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

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

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.

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

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

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

The relationship is the relational database norm.

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

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

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 is actually a system-created database whose tables store the user/designer-created database characteristics and contents.

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

The DIFFERENCE operator subtracts one table from the other.

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