FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Relational Model Characteristics

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 2

Short Answer

Review LaterAdd Note

Review Later

The ____________________ relationship is the relational database norm.

Correct Answer

verified

1:M

Question 3

Multiple Choice

Review LaterAdd Note

The relational database model enables you to view data ____ rather than ____.

Only a single attribute, not multiple attributes, can define functional dependence.

The following example exhibits ____________________ integrity: The CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. Similarly, the AGENT table's primary key is AGENT_CODE, and this primary key column also is free of null entries.

RDBMSs enforce integrity rules automatically.

____________________ joins are especially useful when you are trying to determine what value(s) in related tables cause(s) referential integrity problems.

The logical view of the relational database is facilitated by the creation of data relationships based on a logical construct known as a(n) ____________________.

A(n) ____________________ key can be described as a superkey without unnecessary attributes.

In a relational model, if A determines B, C, and D, you write A = B, C, D.

The SELECT operator yields a vertical subset of a table.

When you define a table's primary key, the DBMS automatically creates a(n) ____ index on the primary key column(s) you declared.

____ data can have only a true or false (yes or no) values.

A(n) ____________________ provides a detailed description of all tables found within the user/designer-created database.

In an outer join, the matched pairs would be retained and any unmatched values in the other table would be left ____.

Tables within a database share common attributes that enable the tables to be linked together.

Any attribute that is part of a key is known as a ____.

____ yields a vertical subset of a table.

The order of the rows and columns is important to the DBMS.

What is a key and why is it important in the relational model?