Question 1

Associative entities are also called ________.

Accepted Answer

The answer of Associative entities are also called ________....

Question 2

The attribute on the left-hand side of the arrow in a functional dependency is the:

Accepted Answer

A)  candidate key. 
B)  Determinant. 
C)  foreign key. 
D)  primary key. 
A)  candidate key. 
B)  Determinant. 
C)  foreign key. 
D)  primary key.

Question 3

The ________ states that no primary key attribute can be null.

Accepted Answer

referentia

Question 4

An attribute that may have more than one meaning is called a(n)________.

Accepted Answer

The answer of An attribute that may have more than...

Question 5

When creating tables using the CREATE TABLE statement,NOT NULL constrains an attribute from being assigned a(n)________ value.

Accepted Answer

The answer of When creating tables using the CREATE TABLE...

Question 6

In the figure below,what type of relationship is depicted?

Accepted Answer

A)  One-to-one 
B)  Unary 
C)  One-to-many 
D)  Many-to-many 
A)  One-to-one 
B)  Unary 
C)  One-to-many 
D)  Many-to-many

Question 7

The normal form which removes any remaining functional dependencies because there was more than one primary key for the same nonkeys is called:

Accepted Answer

A)  Fifth normal form. 
B)  Fourth normal form. 
C)  Boyce-Codd normal form. 
D)  Sixth normal form. 
A)  Fifth normal form. 
B)  Fourth normal form. 
C)  Boyce-Codd normal form. 
D)  Sixth normal form.

Question 8

When two or more attributes describe the same characteristic of an entity,they are synonyms.

Accepted Answer

A) True 
 B)False

Question 9

In the SQL language,the ________ statement is used to make table definitions.

Accepted Answer

A)  create session 
B)  create table 
C)  create index 
D)  select 
A)  create session 
B)  create table 
C)  create index 
D)  select

Question 10

The entity integrity rule states that:

Accepted Answer

A)  no primary key attribute can be null. 
B)  referential integrity must be maintained across all entities. 
C)  each entity must have a primary key. 
D)  a primary key must have only one attribute. 
A)  no primary key attribute can be null. 
B)  referential integrity must be maintained across all entities. 
C)  each entity must have a primary key. 
D)  a primary key must have only one attribute.

Question 11

When normalizing,the goal is to decompose relations with anomalies to produce smaller,well-structured relations.

Accepted Answer

A) True 
 B)False

Question 12

When transforming a one-to-one relationship,a new relation is always created.

Accepted Answer

A) True 
 B)False

Question 13

An attribute (or attributes)that uniquely identifies each row in a relation is called a:

Accepted Answer

A)  column. 
B)  foreign field. 
C)  primary key. 
D)  duplicate key. 
A)  column. 
B)  foreign field. 
C)  primary key. 
D)  duplicate key.

Question 14

Sample data are useful for developing prototype applications and for testing queries.

Accepted Answer

A) True 
 B)False

Question 15

A two-dimensional table of data is called a:

Accepted Answer

A)  group. 
B)  set. 
C)  declaration. 
D)  relation. 
A)  group. 
B)  set. 
C)  declaration. 
D)  relation.

Question 16

Explain what a candidate key is and how it might be used.

Accepted Answer

A candidate key is an attribute or a com

Question 17

A referential integrity constraint states that each ________ value must match a(n)________ value in another relation or be blank.

Accepted Answer

foreign ke

Question 18

Explain how subtype/supertype relationships are converted to relations.

Accepted Answer

When we have a supertype/subtype relatio

Question 19

The primary key of the many side migrates to the one side when transforming a one-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 20

What is an anomaly and what are the three types of anomalies?

Accepted Answer

An anomaly is an error or inconsistency

Associative entities are also called ________.

The attribute on the left-hand side of the arrow in a functional dependency is the:

The ________ states that no primary key attribute can be null.

An attribute that may have more than one meaning is called a(n)________.

When creating tables using the CREATE TABLE statement,NOT NULL constrains an attribute from being assigned a(n)________ value.

In the figure below,what type of relationship is depicted?

The normal form which removes any remaining functional dependencies because there was more than one primary key for the same nonkeys is called:

When two or more attributes describe the same characteristic of an entity,they are synonyms.

In the SQL language,the ________ statement is used to make table definitions.

The entity integrity rule states that:

When normalizing,the goal is to decompose relations with anomalies to produce smaller,well-structured relations.

When transforming a one-to-one relationship,a new relation is always created.

An attribute (or attributes)that uniquely identifies each row in a relation is called a:

Sample data are useful for developing prototype applications and for testing queries.

A two-dimensional table of data is called a:

Explain what a candidate key is and how it might be used.

A referential integrity constraint states that each value must match a(n) value in another relation or be blank.

Explain how subtype/supertype relationships are converted to relations.

The primary key of the many side migrates to the one side when transforming a one-to-many relationship.

What is an anomaly and what are the three types of anomalies?

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 4: Logical Database Design and the Relational Model

Associative entities are also called ________.

The attribute on the left-hand side of the arrow in a functional dependency is the:

The ________ states that no primary key attribute can be null.

An attribute that may have more than one meaning is called a(n)________.

When creating tables using the CREATE TABLE statement,NOT NULL constrains an attribute from being assigned a(n)________ value.

In the figure below,what type of relationship is depicted?

The normal form which removes any remaining functional dependencies because there was more than one primary key for the same nonkeys is called:

When two or more attributes describe the same characteristic of an entity,they are synonyms.

In the SQL language,the ________ statement is used to make table definitions.

The entity integrity rule states that:

When normalizing,the goal is to decompose relations with anomalies to produce smaller,well-structured relations.

When transforming a one-to-one relationship,a new relation is always created.

An attribute (or attributes)that uniquely identifies each row in a relation is called a:

Sample data are useful for developing prototype applications and for testing queries.

A two-dimensional table of data is called a:

Explain what a candidate key is and how it might be used.

A referential integrity constraint states that each ________ value must match a(n)________ value in another relation or be blank.

Explain how subtype/supertype relationships are converted to relations.

The primary key of the many side migrates to the one side when transforming a one-to-many relationship.

What is an anomaly and what are the three types of anomalies?

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

A referential integrity constraint states that each value must match a(n) value in another relation or be blank.