Question 1

In relational database design,ID-dependent entities are used to ________.

Accepted Answer

A) represent 1:1 relationships 
B) represent 1:N relationships 
C) represent N:M relationships 
D) handle recursive relationships 
E) eliminate the need for weak entities being converted to tables. 
A) represent 1:1 relationships 
B) represent 1:N relationships 
C) represent N:M relationships 
D) handle recursive relationships 
E) eliminate the need for weak entities being converted to tables.

Question 2

To create a 1:1 relationship in Microsoft Access,the Indexed property of the foreign key column must be set to Yes (No Duplicates).

Accepted Answer

A) True 
 B)False

Question 3

In the relational model,many-to-many relationships cannot be directly represented by relations the way 1:1 and 1:N relationships can.

Accepted Answer

A) True 
 B)False

Question 4

For a(n)________ weak entity,it is necessary to add the key of the parent entity to the weak entity's relation so that this added attribute becomes part of the weak entity's key.

Accepted Answer

The answer of For a(n)________ weak entity,it is necessary to...

Question 5

Microsoft Access does not create N:M relationships because:

Accepted Answer

A) Microsoft Access creates databases based on database designs instead of data models. 
B) Microsoft Access creates databases based on data models instead of database designs. 
C) Microsoft Access cannot implement association relationships. 
D) Microsoft Access cannot implement supertype/subtype relationships. 
E) Microsoft Access cannot implement recursive relationships. 
A) Microsoft Access creates databases based on database designs instead of data models. 
B) Microsoft Access creates databases based on data models instead of database designs. 
C) Microsoft Access cannot implement association relationships. 
D) Microsoft Access cannot implement supertype/subtype relationships. 
E) Microsoft Access cannot implement recursive relationships.

Question 6

There are cases where it is possible to normalize a table too far,in which case there may be a need for ________.

Accepted Answer

The answer of There are cases where it is possible...

Question 7

The key for an intersection relation is always the combination of the keys of the parent entities.

Accepted Answer

A) True 
 B)False

Question 8

What is denormalization and why can it be desirable?

Accepted Answer

Denormalization is the process of consol

Question 9

From a pragmatic standpoint,the only important rule of normalization is that the determinant of every functional dependency must be a candidate key.

Accepted Answer

A) True 
 B)False

Question 10

In certain circumstances,there may be a preference as to which table in a 1:1 relationship contains the foreign key.

Accepted Answer

A) True 
 B)False

Question 11

One of the important properties of an attribute is whether or not it is required.

Accepted Answer

A) True 
 B)False

Question 12

Explain the pragmatic reason for using surrogate keys.

Accepted Answer

Primary keys are commonly included in in

Question 13

When transforming an E-R data model into a relational database design,the key of the parent entity should be placed as part of the primary key into the child entity ________.

Accepted Answer

A) when the child entity is ID-dependent 
B) when the child entity is non-ID-dependent 
C) when the child entity has a 1:1 relationship with the parent entity 
D) when the child entity has a 1:N relationship with the parent entity 
E) when the child entity has a recursive relationship with the parent entity 
A) when the child entity is ID-dependent 
B) when the child entity is non-ID-dependent 
C) when the child entity has a 1:1 relationship with the parent entity 
D) when the child entity has a 1:N relationship with the parent entity 
E) when the child entity has a recursive relationship with the parent entity

Question 14

What is an association relationship,and how does it differ from an N:M relationship?

Accepted Answer

An association relationship is very simi

Question 15

To create a 1:1 relationship between two tables in Microsoft Access:

Accepted Answer

A) the Indexed property of the foreign key column must be set to No. 
B) the Indexed property of the foreign key column must be set to Yes (Duplicates OK). 
C) the Indexed property of the foreign key column must be set to Yes (No Duplicates). 
D) the Data Type of the foreign key column must be set to AutoNumber. 
E) the Smart Tag property of the foreign key column must be set to Foreign Key. 
A) the Indexed property of the foreign key column must be set to No. 
B) the Indexed property of the foreign key column must be set to Yes (Duplicates OK). 
C) the Indexed property of the foreign key column must be set to Yes (No Duplicates). 
D) the Data Type of the foreign key column must be set to AutoNumber. 
E) the Smart Tag property of the foreign key column must be set to Foreign Key.

Question 16

Explain the representation of a many-to-many strong entity relationship in a relational database design.

Accepted Answer

Many-to-many relationships cannot be dir

Question 17

Each attribute of an entity becomes a(n)________ of a table.

Accepted Answer

A) column 
B) primary key 
C) foreign key 
D) alternate key 
E) B or D 
A) column 
B) primary key 
C) foreign key 
D) alternate key 
E) B or D

Question 18

After a 1:1 relationship has been created between two tables in Microsoft Access,the Relationship Type of One-To-One appears:

Accepted Answer

A) in the Relationship Type property of the primary key column in table Design View. 
B) in the Relationship Type property of the foreign key column in table Design View. 
C) in the table object in the Relationships window. 
D) in the Show Table dialog box. 
E) in the Edit Relationships dialog box. 
A) in the Relationship Type property of the primary key column in table Design View. 
B) in the Relationship Type property of the foreign key column in table Design View. 
C) in the table object in the Relationships window. 
D) in the Show Table dialog box. 
E) in the Edit Relationships dialog box.

Question 19

All recursive relationships are 1:1.

Accepted Answer

A) True 
 B)False

Question 20

To represent a many-to-many relationship in the relational model,a(n)________ table is used.

Accepted Answer

The answer of To represent a many-to-many relationship in the...

In relational database design,ID-dependent entities are used to ________.

To create a 1:1 relationship in Microsoft Access,the Indexed property of the foreign key column must be set to Yes (No Duplicates).

In the relational model,many-to-many relationships cannot be directly represented by relations the way 1:1 and 1:N relationships can.

For a(n)________ weak entity,it is necessary to add the key of the parent entity to the weak entity's relation so that this added attribute becomes part of the weak entity's key.

Microsoft Access does not create N:M relationships because:

There are cases where it is possible to normalize a table too far,in which case there may be a need for ________.

The key for an intersection relation is always the combination of the keys of the parent entities.

What is denormalization and why can it be desirable?

From a pragmatic standpoint,the only important rule of normalization is that the determinant of every functional dependency must be a candidate key.

In certain circumstances,there may be a preference as to which table in a 1:1 relationship contains the foreign key.

One of the important properties of an attribute is whether or not it is required.

Explain the pragmatic reason for using surrogate keys.

When transforming an E-R data model into a relational database design,the key of the parent entity should be placed as part of the primary key into the child entity ________.

What is an association relationship,and how does it differ from an N:M relationship?

To create a 1:1 relationship between two tables in Microsoft Access:

Explain the representation of a many-to-many strong entity relationship in a relational database design.

Each attribute of an entity becomes a(n)________ of a table.

After a 1:1 relationship has been created between two tables in Microsoft Access,the Relationship Type of One-To-One appears:

All recursive relationships are 1:1.

To represent a many-to-many relationship in the relational model,a(n)________ table is used.

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Administration

Database Processing Applications

Big Data Data Warehouses and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters

Exam 5: Database Design

In relational database design,ID-dependent entities are used to ________.

To create a 1:1 relationship in Microsoft Access,the Indexed property of the foreign key column must be set to Yes (No Duplicates).

In the relational model,many-to-many relationships cannot be directly represented by relations the way 1:1 and 1:N relationships can.

For a(n)________ weak entity,it is necessary to add the key of the parent entity to the weak entity's relation so that this added attribute becomes part of the weak entity's key.

Microsoft Access does not create N:M relationships because:

There are cases where it is possible to normalize a table too far,in which case there may be a need for ________.

The key for an intersection relation is always the combination of the keys of the parent entities.

What is denormalization and why can it be desirable?

From a pragmatic standpoint,the only important rule of normalization is that the determinant of every functional dependency must be a candidate key.

In certain circumstances,there may be a preference as to which table in a 1:1 relationship contains the foreign key.

One of the important properties of an attribute is whether or not it is required.

Explain the pragmatic reason for using surrogate keys.

When transforming an E-R data model into a relational database design,the key of the parent entity should be placed as part of the primary key into the child entity ________.

What is an association relationship,and how does it differ from an N:M relationship?

To create a 1:1 relationship between two tables in Microsoft Access:

Explain the representation of a many-to-many strong entity relationship in a relational database design.

Each attribute of an entity becomes a(n)________ of a table.

After a 1:1 relationship has been created between two tables in Microsoft Access,the Relationship Type of One-To-One appears:

All recursive relationships are 1:1.

To represent a many-to-many relationship in the relational model,a(n)________ table is used.

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Administration

Database Processing Applications

Big Data Data Warehouses and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters