Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

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 5

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 6

When creating a table in the relational database design from an entity in the extended E-R model,the attributes of the entity become the rows of the table.

Accepted Answer

A) True 
 B)False

Question 7

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)  either B or D 
A)  column 
B)  primary key 
C)  foreign key 
D)  alternate key 
E)  either B or D

Question 8

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 9

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 10

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 11

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 12

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 13

The first step of database design is to define a table for each ________.

Accepted Answer

The answer of The first step of database design is...

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

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

Accepted Answer

A)  the key of the child is placed as a foreign key into the parent 
B)  the key of the parent is placed as a foreign key into the child 
C)  the keys of both tables are placed in a third table 
D)  the keys of both tables are joined into a composite key 
E)  Both C and D 
A)  the key of the child is placed as a foreign key into the parent 
B)  the key of the parent is placed as a foreign key into the child 
C)  the keys of both tables are placed in a third table 
D)  the keys of both tables are joined into a composite key 
E)  Both C and D

Question 17

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 18

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.

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

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

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

Which of the following is not true about 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 ________.

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

When creating a table in the relational database design from an entity in the extended E-R model,the attributes of the entity become the rows of the table.

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

Microsoft Access does not create N:M relationships because ________.

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

A surrogate key should be considered when ________.

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

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

The first step of database design is to define a table for each ________.

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

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.

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

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

Which of the following is the correct technique for representing a 1:N relationship in 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 true about representing a weak entity with the relational model?

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

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

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

Which of the following is not true about 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 ________.

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

When creating a table in the relational database design from an entity in the extended E-R model,the attributes of the entity become the rows of the table.

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

Microsoft Access does not create N:M relationships because ________.

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

A surrogate key should be considered when ________.

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

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

The first step of database design is to define a table for each ________.

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

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.

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

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

Which of the following is the correct technique for representing a 1:N relationship in 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 true about representing a weak entity with the relational model?

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