Question 1

Explain the representation of ID-dependent weak entities using the relational model.

Accepted Answer

A weak entity is represented in the rela

Question 2

Which of the following is not true about representing subtypes in a relational database design?

Accepted Answer

A)  One table is created for the supertype and one for each subtype. 
B)  All of the attributes of the supertype are added to the subtype relations. 
C)  The key of the supertype is made the key of the subtypes. 
D)  A subtype and its supertype are representations of the same underlying table. 
E)  An instance of the supertype may be related to one instance each of several subtypes. 
A)  One table is created for the supertype and one for each subtype. 
B)  All of the attributes of the supertype are added to the subtype relations. 
C)  The key of the supertype is made the key of the subtypes. 
D)  A subtype and its supertype are representations of the same underlying table. 
E)  An instance of the supertype may be related to one instance each of several subtypes.

Question 3

Explain the process of representing an entity using the relational model.

Accepted Answer

To represent an entity using the relatio

Question 4

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 5

How are 1:1,1:N and N:M relationships handled in Microsoft Access?

Accepted Answer

By default,when Microsoft Access creates

Question 6

Which of the following would be a reason to denormalize a relation?

Accepted Answer

A)  Relax security 
B)  Lack of design time 
C)  End user preference 
D)  Improve performance 
E)  None of the above 
A)  Relax security 
B)  Lack of design time 
C)  End user preference 
D)  Improve performance 
E)  None of the above

Question 7

To represent a 1:N relationship in the relational model,the key of either entity may be placed as a foreign key in the other entity.

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

Write the schema to represent the entities below,including tables,the proper placement of the foreign key,and referential integrity constraint.

Accepted Answer

STUDENT (StudentID,StuName,Stu

Question 10

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

Accepted Answer

Edit Relat

Question 11

A surrogate key should be considered when ________.

Accepted Answer

A)  a relationship is M:N 
B)  a composite key is required 
C)  the key contains a lengthy text field 
D)  the key contains a number 
E)  an index needs to be created 
A)  a relationship is M:N 
B)  a composite key is required 
C)  the key contains a lengthy text field 
D)  the key contains a number 
E)  an index needs to be created

Question 12

Relations should always be normalized to the highest degree possible.

Accepted Answer

A) True 
 B)False

Question 13

The first step in transforming an extended E-R model into a relational database design is to ________.

Accepted Answer

A)  create a table for each relationship 
B)  evaluate the entities against the normalization criteria 
C)  create a table for each entity 
D)  remove any recursive relationships 
E)  document referential integrity constraints 
A)  create a table for each relationship 
B)  evaluate the entities against the normalization criteria 
C)  create a table for each entity 
D)  remove any recursive relationships 
E)  document referential integrity constraints

Question 14

If a weak entity is ID-dependent but not existence-dependent,it can be represented using the same techniques as a strong entity.

Accepted Answer

A) True 
 B)False

Question 15

In a relational database design,all relationships are expressed by ________.

Accepted Answer

A)  creating a primary key 
B)  creating a foreign key 
C)  creating a supertype 
D)  creating a subtype 
E)  creating a line between entities 
A)  creating a primary key 
B)  creating a foreign key 
C)  creating a supertype 
D)  creating a subtype 
E)  creating a line between entities

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

To represent a 1:N relationship in the relational model,the key of the entity on the one side of the relationship is placed as a foreign key in the entity on the many side of the relationship.

Accepted Answer

A) True 
 B)False

Question 18

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 19

The first step in representing entities using the relational model is to determine which identifier will be used as the key.

Accepted Answer

A) True 
 B)False

Question 20

To represent a M:N relationship in the relational model,an intersection relation is created to represent the relationship itself.

Accepted Answer

A) True 
 B)False

Explain the representation of ID-dependent weak entities using the relational model.

Which of the following is not true about representing subtypes in a relational database design?

Explain the process of representing an entity using the relational model.

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

How are 1:1,1:N and N:M relationships handled in Microsoft Access?

Which of the following would be a reason to denormalize a relation?

To represent a 1:N relationship in the relational model,the key of either entity may be placed as a foreign key in the other entity.

What is denormalization and why can it be desirable?

Write the schema to represent the entities below,including tables,the proper placement of the foreign key,and referential integrity constraint.

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

A surrogate key should be considered when ________.

Relations should always be normalized to the highest degree possible.

The first step in transforming an extended E-R model into a relational database design is to ________.

If a weak entity is ID-dependent but not existence-dependent,it can be represented using the same techniques as a strong entity.

In a relational database design,all relationships are expressed by ________.

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

To represent a 1:N relationship in the relational model,the key of the entity on the one side of the relationship is placed as a foreign key in the entity on the many side of the relationship.

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.

The first step in representing entities using the relational model is to determine which identifier will be used as the key.

To represent a M:N relationship in the relational model,an intersection relation is created to represent the relationship itself.

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 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters

Exam 5: Database Design

Explain the representation of ID-dependent weak entities using the relational model.

Which of the following is not true about representing subtypes in a relational database design?

Explain the process of representing an entity using the relational model.

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

How are 1:1,1:N and N:M relationships handled in Microsoft Access?

Which of the following would be a reason to denormalize a relation?

To represent a 1:N relationship in the relational model,the key of either entity may be placed as a foreign key in the other entity.

What is denormalization and why can it be desirable?

Write the schema to represent the entities below,including tables,the proper placement of the foreign key,and referential integrity constraint.

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

A surrogate key should be considered when ________.

Relations should always be normalized to the highest degree possible.

The first step in transforming an extended E-R model into a relational database design is to ________.

If a weak entity is ID-dependent but not existence-dependent,it can be represented using the same techniques as a strong entity.

In a relational database design,all relationships are expressed by ________.

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

To represent a 1:N relationship in the relational model,the key of the entity on the one side of the relationship is placed as a foreign key in the entity on the many side of the relationship.

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.

The first step in representing entities using the relational model is to determine which identifier will be used as the key.

To represent a M:N relationship in the relational model,an intersection relation is created to represent the relationship itself.

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 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters