Question 1

As far as Microsoft Access is concerned,there are no N:M relationships.

Accepted Answer

A) True 
 B)False  True

Question 2

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

Accepted Answer

A) True 
 B)False  True

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  True

Question 4

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

Accepted Answer

recursive

Question 5

By default,the identifier of the entity becomes the foreign key of the corresponding table.

Accepted Answer

A) True 
 B)False

Question 6

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 7

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 8

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)  Both A and B 
E)  Both 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)  Both A and B 
E)  Both B and C

Question 9

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 10

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 11

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

Question 12

Explain the pragmatic reason for using surrogate keys.

Accepted Answer

Primary keys are commonly included in in

Question 13

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 14

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 15

Which of the following is true when representing a 1:1 binary relationship using the relational model?

Accepted Answer

A)  The key of the entity with the highest minimum cardinality must be placed in the other entity as a foreign key. 
B)  The key of each entity must be placed in the other as a foreign key. 
C)  The key of either entity is placed in the other as a foreign key. 
D)  The key of the entity with the most attributes must be placed in the other entity as a foreign key. 
E)  Both entities must have the same primary key. 
A)  The key of the entity with the highest minimum cardinality must be placed in the other entity as a foreign key. 
B)  The key of each entity must be placed in the other as a foreign key. 
C)  The key of either entity is placed in the other as a foreign key. 
D)  The key of the entity with the most attributes must be placed in the other entity as a foreign key. 
E)  Both entities must have the same primary key.

Question 16

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 17

All recursive relationships are 1:1.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

An association relationship is very simi

Question 19

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 20

One of the important properties of a column is whether or not it is ________.

Accepted Answer

A)  found in more than one entity 
B)  required 
C)  character or numeric 
D)  subject to normalization 
E)  subject to denormalization 
A)  found in more than one entity 
B)  required 
C)  character or numeric 
D)  subject to normalization 
E)  subject to denormalization

As far as Microsoft Access is concerned,there are no N:M relationships.

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

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

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

By default,the identifier of the entity becomes the foreign key of the corresponding table.

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

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

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

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

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

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

Explain the pragmatic reason for using surrogate keys.

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

Which of the following is true when representing a 1:1 binary relationship using the relational model?

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

All recursive relationships are 1:1.

What is an association relationship,and how does it differ from an N:M 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.

One of the important properties of a column is whether or not it is ________.

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters

Exam 5: Database Design

As far as Microsoft Access is concerned,there are no N:M relationships.

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

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

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

By default,the identifier of the entity becomes the foreign key of the corresponding table.

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

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

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

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

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

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

Explain the pragmatic reason for using surrogate keys.

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

Which of the following is true when representing a 1:1 binary relationship using the relational model?

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

All recursive relationships are 1:1.

What is an association relationship,and how does it differ from an N:M 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.

One of the important properties of a column is whether or not it is ________.

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters