Question 1

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

Accepted Answer

The answer of What is a key and why is...

Question 2

All RDBMSs enforce integrity rules automatically.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A)  key attribute 
B)  logical attribute 
C)  key determiner 
D)  selector

Question 4

The ____________________ catalog can be described as a detailed system data dictionary that describes all objects within the database,including data about table names,the table's creator and creation date,the number of columns in each table,the data type corresponding to each column,index filenames,index creators,authorized users,and access privileges.

Accepted Answer

The answer of The ____________________ catalog can be described as...

Question 5

Attribute A determines attribute B (that is,B is functionally ____________________ on A)if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.

Accepted Answer

The answer of Attribute A determines attribute B (that is,B...

Question 6

A ____ key can be described as a superkey without unnecessary attributes,that is,a minimal superkey.

Accepted Answer

A)  secondary 
B)  candidate 
C)  primary 
D)  foreign

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

If one department chair-a professor-can chair only one department and one department can have only one department chair,then the entities PROFESSOR and DEPARTMENT exhibit a(n)____________________ relationship.

Accepted Answer

The answer of If one department chair-a professor-can chair only...

Question 9

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

Accepted Answer

The answer of A(n)____________________ key can be described as a...

Question 10

In the following table description,____ is the primary key.
PRODUCT (PROD_CODE,PROD_DESCRIPT,PROD_PRICE,PROD_ON_HAND,VEND_CODE)

Accepted Answer

A)  PROD_DESCRIPT 
B)  PROD_CODE 
C)  PROD_PRICE 
D)  PROD_ON_HAND

Question 11

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

Accepted Answer

A)  relationally,hierarchically 
B)  hierarchically,relationally 
C)  physically,logically 
D)  logically,physically

Question 12

The equijoin takes its name from the comparison operator ____ used in the condition.

Accepted Answer

A)  * 
B)

Question 13

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

Accepted Answer

The answer of ____________________ relationships can be implemented by creating...

Question 14

The ____ relationship should be rare in any relational database design.

Accepted Answer

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

Question 15

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

Accepted Answer

A)  lookup 
B)  foreign 
C)  candidate 
D)  secondary

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

The index key can have multiple attributes,this is called a(n)____________________ index.

Accepted Answer

The answer of The index key can have multiple attributes,this...

Question 18

The practical significance of taking the logical view of a database is that it serves as a reminder of the simple file concept of data storage.

Accepted Answer

A) True 
 B)False

Question 19

____ relational type is the "relational model ideal."

Accepted Answer

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

Question 20

A 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.

Accepted Answer

A)  entity 
B)  referential 
C)  complete 
D)  null

Exam 3: The Relational Database Model

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

All RDBMSs enforce integrity rules automatically.

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

Attribute A determines attribute B (that is,B is functionally ____________________ on A)if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.

A ____ key can be described as a superkey without unnecessary attributes,that is,a minimal superkey.

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

If one department chair-a professor-can chair only one department and one department can have only one department chair,then the entities PROFESSOR and DEPARTMENT exhibit a(n)____________________ relationship.

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

In the following table description,____ is the primary key. PRODUCT (PROD_CODE,PROD_DESCRIPT,PROD_PRICE,PROD_ON_HAND,VEND_CODE)

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

The equijoin takes its name from the comparison operator ____ used in the condition.

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

The ____ relationship should be rare in any relational database design.

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

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

The index key can have multiple attributes,this is called a(n)____________________ index.

The practical significance of taking the logical view of a database is that it serves as a reminder of the simple file concept of data storage.

____ relational type is the "relational model ideal."

A 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.