Question 1

Microsoft Access uses the same pure N:M relationships that occur in data modeling.

Accepted Answer

A) True 
 B)False

Question 2

What relationship pattern is illustrated in the following schema? EMPLOYEE (EmployeeID,OfficePhone,Manager)
Manager in EMPLOYEE must exist in EmployeeID in EMPLOYEE

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

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 5

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 6

For a 1:1 relationship,the key of each table should be placed in the other table as the foreign key.

Accepted Answer

A) True 
 B)False

Question 7

Relationships that are 1:1 do not require referential integrity constraints.

Accepted Answer

A) True 
 B)False

Question 8

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 9

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 10

Explain the pragmatic reason for using surrogate keys.

Accepted Answer

Primary keys are commonly included in in

Question 11

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 12

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 13

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 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

The answer of By default,when Microsoft Access creates a relationship...

Question 17

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 18

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 19

Which of the following is not true about surrogate keys?

Accepted Answer

A)  They are identifiers that are supplied by the system, not the users. 
B)  They have no meaning to the users. 
C)  They are nonunique within a table. 
D)  They can be problematic when combining databases. 
E)  The DBMS will not allow their values to be changed. 
A)  They are identifiers that are supplied by the system, not the users. 
B)  They have no meaning to the users. 
C)  They are nonunique within a table. 
D)  They can be problematic when combining databases. 
E)  The DBMS will not allow their values to be changed.

Question 20

How are one-to-one recursive relationships addressed using the relational model?

Accepted Answer

One-to-one recursive relationships are a

Microsoft Access uses the same pure N:M relationships that occur in data modeling.

What relationship pattern is illustrated in the following schema? EMPLOYEE (EmployeeID,OfficePhone,Manager) Manager in EMPLOYEE must exist in EmployeeID in EMPLOYEE

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

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

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

For a 1:1 relationship,the key of each table should be placed in the other table as the foreign key.

Relationships that are 1:1 do not require referential integrity constraints.

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

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 the relational model,many-to-many relationships cannot be directly represented by relations the way 1:1 and 1:N relationships can.

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

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

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.

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

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

Which of the following is not true about surrogate keys?

How are one-to-one recursive relationships addressed using 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 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

Microsoft Access uses the same pure N:M relationships that occur in data modeling.

What relationship pattern is illustrated in the following schema? EMPLOYEE (EmployeeID,OfficePhone,Manager) Manager in EMPLOYEE must exist in EmployeeID in EMPLOYEE

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

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

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

For a 1:1 relationship,the key of each table should be placed in the other table as the foreign key.

Relationships that are 1:1 do not require referential integrity constraints.

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

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 the relational model,many-to-many relationships cannot be directly represented by relations the way 1:1 and 1:N relationships can.

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

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

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.

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

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

Which of the following is not true about surrogate keys?

How are one-to-one recursive relationships addressed using 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 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