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 1

Multiple Choice

Review LaterAdd Note

Review Later

A ____ is a textual representation of the database tables where each table is listed by its name followed by the list of its attributes in parentheses.

A) relational dictionary
B) logical schema
C) relational schema
D) data dictionary

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

Depending on the sophistication of the application development software,nulls can create problems when functions such as COUNT,AVERAGE,and SUM are used.

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

There is never a good reason to use null values in a database.

The relational model's creator,E.F.Codd,used the term relation as a synonym for ____.

Numeric data are data on which you can perform meaningful arithmetic procedures.

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

Since it is used to link the tables that originally were related in a M:N relationship,the composite entity structure includes-as foreign keys-at least the ____ keys of the tables that are to be linked.

The relational operators have the property of ____________________; that is,the use of relational algebra operators on existing relations (tables)produces new relations.

Date attributes contain calendar dates stored in a special format known as the ____ date format.

Current relational database software generally provides only a system catalog (and not a data dictionary).

A(n) ____ is perceived as a two-dimensional structure composed of rows and columns.

The SELECT operator yields a vertical subset of a table.

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

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

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

A(n) ____ join links tables by selecting only the rows with common values in their common attribute(s) .

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

In a relational table,each column has a specific range of values known as the ____________________ domain.

Describe the use of the UNION operator.

____ yields a vertical subset of a table.