Question 1

Microsoft Access does not create N:M relationships because Microsoft Access creates databases based on ________.

Accepted Answer

The answer of Microsoft Access does not create N:M relationships...

Question 2

An entity needs to be examined according to normalization criteria before creating a table from it in the relational database design.

Accepted Answer

A) True 
 B)False

Question 3

In many-to-many relationships in a relational database design,________.

Accepted Answer

A) the intersection table is ID-dependent on one of the parents 
B) the intersection table is ID-dependent on both of the parents 
C) the minimum cardinality from the intersection table to the parents is always M 
D) A and B 
E) B and C 
A) the intersection table is ID-dependent on one of the parents 
B) the intersection table is ID-dependent on both of the parents 
C) the minimum cardinality from the intersection table to the parents is always M 
D) A and B 
E) B and C

Question 4

A(n)________ is a relationship among entities of the same class.

Accepted Answer

recursive

Question 5

When transforming an ID-dependent E-R data model relationship into a relational database design and the child entity is designed to use a surrogate key,then ________.

Accepted Answer

A) the parent entity must also use a surrogate key 
B) the relationship remains an ID-dependent relationship 
C) the relationship changes to a non-ID-dependent relationship 
D) A and B 
E) A and C 
A) the parent entity must also use a surrogate key 
B) the relationship remains an ID-dependent relationship 
C) the relationship changes to a non-ID-dependent relationship 
D) A and B 
E) A and C

Question 6

Which of the following is the correct technique for representing a M:N relationship using the relational model?

Accepted Answer

A) An intersection relation is created,and the key of either entity is placed as a key in both the intersection relation and in the other relation. 
B) An intersection relation is created with a surrogate key,which is placed in each of the parent entities. 
C) An intersection relation is created,and the keys of both parent entities are placed as a composite key in the intersection relation. 
D) The key from either relation is placed as a foreign key in the other relation. 
E) None of the above 
A) An intersection relation is created,and the key of either entity is placed as a key in both the intersection relation and in the other relation. 
B) An intersection relation is created with a surrogate key,which is placed in each of the parent entities. 
C) An intersection relation is created,and the keys of both parent entities are placed as a composite key in the intersection relation. 
D) The key from either relation is placed as a foreign key in the other relation. 
E) None of the above

Question 7

Which of the following is true about representing a weak entity with the relational model?

Accepted Answer

A) If the weak entity is existence-dependent,the key of the parent must be part of the key of the weak entity. 
B) If the strong entity has a minimum cardinality of 1,the key of the weak entity must be part of the strong entity. 
C) If the weak entity is ID-dependent,the key of the weak entity must be part of the key of the parent entity. 
D) If the weak entity is ID-dependent,the key of the parent entity must be part of the key of the weak entity. 
E) If the parent entity is existence-dependent,then the minimum cardinality of the weak entity is zero. 
A) If the weak entity is existence-dependent,the key of the parent must be part of the key of the weak entity. 
B) If the strong entity has a minimum cardinality of 1,the key of the weak entity must be part of the strong entity. 
C) If the weak entity is ID-dependent,the key of the weak entity must be part of the key of the parent entity. 
D) If the weak entity is ID-dependent,the key of the parent entity must be part of the key of the weak entity. 
E) If the parent entity is existence-dependent,then the minimum cardinality of the weak entity is zero.

Question 8

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 9

As far as Microsoft Access is concerned,there are no:

Accepted Answer

A) 1:1 relationships. 
B) 1:N relationships. 
C) N:1 relationships. 
D) N:M relationships. 
E) recursive relationships. 
A) 1:1 relationships. 
B) 1:N relationships. 
C) N:1 relationships. 
D) N:M relationships. 
E) recursive relationships.

Question 10

The key of the parent entity becomes part of the key of an ID-dependent entity.

Accepted Answer

A) True 
 B)False

Question 11

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 12

What relationship pattern is illustrated in the following schema?
VEHICLE (VehicleID, Cost)
CAR (VehicleID, NumberOfSeats)
TRUCK (VehicleID , CargoCapacity)
VehicleID in CAR must exist in VehicleID in VEHICLE
	VehicleID in TRUCK must exist in VehicleID in VEHICLE

Accepted Answer

A) Association relationship 
B) Intersection relationship 
C) Recursive relationship 
D) Strong entity relationship 
E) Supertype/subtype relationship 
A) Association relationship 
B) Intersection relationship 
C) Recursive relationship 
D) Strong entity relationship 
E) Supertype/subtype relationship

Question 13

What relationship pattern is illustrated in the following schema?
PRODUCT (ProductID, Description)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
PRODUCT_SUPPLIER (ProductID, SupplierID, Cost)
ProductID in PRODUCT_SUPPLIER must exist in ProductID in PRODUCT
SupplierID in PRODUCT_SUPPLIER must exist in SupplierID in PRODUCT

Accepted Answer

A) Association relationship 
B) Intersection relationship 
C) Recursive relationship 
D) Strong entity relationship 
E) Supertype/subtype relationship 
A) Association relationship 
B) Intersection relationship 
C) Recursive relationship 
D) Strong entity relationship 
E) Supertype/subtype relationship

Question 14

By default,when Microsoft Access creates a relationship between two tables,it creates a(n):

Accepted Answer

A) 1:1 relationship. 
B) 1:N relationship. 
C) N:M relationship. 
D) association relationship. 
E) recursive relationship. 
A) 1:1 relationship. 
B) 1:N relationship. 
C) N:M relationship. 
D) association relationship. 
E) recursive relationship.

Question 15

The identifier of the entity becomes the ________ of the corresponding table.

Accepted Answer

A) primary key 
B) foreign key 
C) supertype 
D) subtype 
E) either A or B 
A) primary key 
B) foreign key 
C) supertype 
D) subtype 
E) either A or B

Question 16

A surrogate key is appropriate when the primary key of a table contains a lengthy text field.

Accepted Answer

A) True 
 B)False

Question 17

To normalize a relation,the determinant of every functional dependency should be a(n)________.

Accepted Answer

The answer of To normalize a relation,the determinant of every...

Question 18

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

Accepted Answer

To represent an entity using the relatio

Question 19

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 20

Which of the following is the correct technique for representing a 1:N relationship in the relational model?

Accepted Answer

A) The key of the entity on the one side is placed into the relation for the entity on the many side. 
B) The key of the child is placed into the relation of the parent. 
C) The key of either relation can be placed into the other relation. 
D) The key of the entity on the many side is placed into the relation for the entity on the one side. 
E) An intersection relation is created,and the keys from both parent entities are placed as keys in the intersection relation. 
A) The key of the entity on the one side is placed into the relation for the entity on the many side. 
B) The key of the child is placed into the relation of the parent. 
C) The key of either relation can be placed into the other relation. 
D) The key of the entity on the many side is placed into the relation for the entity on the one side. 
E) An intersection relation is created,and the keys from both parent entities are placed as keys in the intersection relation.

Microsoft Access does not create N:M relationships because Microsoft Access creates databases based on ________.

An entity needs to be examined according to normalization criteria before creating a table from it in the relational database design.

In many-to-many relationships in a relational database design,________.

A(n)________ is a relationship among entities of the same class.

When transforming an ID-dependent E-R data model relationship into a relational database design and the child entity is designed to use a surrogate key,then ________.

Which of the following is the correct technique for representing a M:N relationship using the relational model?

Which of the following is true about representing a weak entity with the relational model?

A surrogate key should be considered when ________.

As far as Microsoft Access is concerned,there are no:

The key of the parent entity becomes part of the key of an ID-dependent entity.

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

What relationship pattern is illustrated in the following schema? VEHICLE (VehicleID, Cost) CAR (VehicleID, NumberOfSeats) TRUCK (VehicleID , CargoCapacity) VehicleID in CAR must exist in VehicleID in VEHICLE VehicleID in TRUCK must exist in VehicleID in VEHICLE

By default,when Microsoft Access creates a relationship between two tables,it creates a(n):

The identifier of the entity becomes the ________ of the corresponding table.

A surrogate key is appropriate when the primary key of a table contains a lengthy text field.

To normalize a relation,the determinant of every functional dependency should be a(n)________.

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

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

Which of the following is the correct technique for representing a 1:N relationship in the relational model?

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

Microsoft Access does not create N:M relationships because Microsoft Access creates databases based on ________.

An entity needs to be examined according to normalization criteria before creating a table from it in the relational database design.

In many-to-many relationships in a relational database design,________.

A(n)________ is a relationship among entities of the same class.

When transforming an ID-dependent E-R data model relationship into a relational database design and the child entity is designed to use a surrogate key,then ________.

Which of the following is the correct technique for representing a M:N relationship using the relational model?

Which of the following is true about representing a weak entity with the relational model?

A surrogate key should be considered when ________.

As far as Microsoft Access is concerned,there are no:

The key of the parent entity becomes part of the key of an ID-dependent entity.

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

What relationship pattern is illustrated in the following schema? VEHICLE (VehicleID, Cost) CAR (VehicleID, NumberOfSeats) TRUCK (VehicleID , CargoCapacity) VehicleID in CAR must exist in VehicleID in VEHICLE VehicleID in TRUCK must exist in VehicleID in VEHICLE

By default,when Microsoft Access creates a relationship between two tables,it creates a(n):

The identifier of the entity becomes the ________ of the corresponding table.

A surrogate key is appropriate when the primary key of a table contains a lengthy text field.

To normalize a relation,the determinant of every functional dependency should be a(n)________.

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

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

Which of the following is the correct technique for representing a 1:N relationship in the relational model?

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