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

True/False

Review LaterAdd Note

Review Later

Character data can contain any character or symbol intended for mathematical manipulation.

A) True
B) False

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

If the attribute (B)is functionally dependent on a composite key (A)but not on any subset of that composite key,the attribute (B)is fully functionally dependent on (A).

A) True
B) False

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

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

In a natural join,the column on which the join was made occurs twice in the new table.

A data dictionary is sometimes described as "the database designer's database" because it records the design decisions about tables and their structures.

When two or more tables share the same number of columns,and when their corresponding columns share the same or compatible domains,they are said to be .

A(n)index is an index in which the index key can have only one pointer value (row)associated with it.

The proper use of keys is crucial to controlling data redundancy.

__ returns only the attributes requested,in the order in which they are requested.

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

Define entity integrity.What are the two requirements to ensure entity integrity?

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

A(n) only returns matched records from the tables that are being joined.

You can think of a table as a persistent representation of a logical relation.

______relationships cannot be implemented as such in the relational model.

In a database context,the word indicates the use of the same attribute name to label different attributes.

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

The constraint can be placed on a column to ensure that every row in the table has a value for that column.

PRODUCT yields all possible pairs of rows from two tables,also known as the product.

Each table represents an attribute.