Question 1

Data names should always relate to business characteristics.

Accepted Answer

A) True 
 B)False

Question 2

In an E-R diagram,there are ________ business rule(s) for every relationship.

Accepted Answer

A)   two
B)   three
C)   one
D)   none

Question 3

Data rather than processes are the most complex aspects of many modern information systems.

Accepted Answer

A) True 
 B)False

Question 4

One reason to use an associative entity is if the associative entity has one or more attributes in addition to the identifier.

Accepted Answer

A) True 
 B)False

Question 5

The logical representation of an organization's data is called a(n) :

Accepted Answer

A)   database model.
B)   entity-relationship model.
C)   relationship systems design.
D)   database entity diagram.

Question 6

The following figure shows an example of:

Accepted Answer

A)   a one-to-many relationship.
B)   a strong entity and its associated weak entity.
C)   a co-dependent relationship.
D)   a double-walled relationship.

Question 7

The common types of entities are:

Accepted Answer

A)   strong entities.
B)   weak entities.
C)   associative entities.
D)   all of the above.

Question 8

In an E-R Diagram,an associative entity is represented by a rounded rectangle.

Accepted Answer

A) True 
 B)False

Question 9

In the figure shown below,which of the following is true?

Accepted Answer

A)   A person can marry at most one person.
B)   A person has to be married.
C)   A person can marry more than one person, but that person can only be married to one person.
D)   A person can marry more than one person.

Question 10

In the following diagram,which is true?

Accepted Answer

A)   It depicts a unary relationship.
B)   It depicts a many-to-many relationship.
C)   There is an associative entity.
D)   All of the above.

Question 11

For the relationship represented in the figure below,which of the following is true?

Accepted Answer

A)   An employee can work in more than one department but does not have to work for any department.
B)   A department must have at least one employee.
C)   A department can have more than one employee.
D)   An employee has to work for more than one department.

Question 12

What is the difference between a simple attribute and a composite attribute?

Accepted Answer

A simple attribute cannot be broken down...

Question 13

The number of entity types that participate in a relationship is called the:

Accepted Answer

A)   number.
B)   identifying characteristic.
C)   degree.
D)   counter.

Question 14

The following figure shows an example of:

Accepted Answer

A)   a composite attribute.
B)   a relational attribute.
C)   a derived attribute.
D)   a multivalued attribute.

Question 15

A ________ is an association between two or more terms.

Accepted Answer

The answer of A ________ is an association between two...

Question 16

A person,place,object,event,or concept about which the organization wants or needs to store data is called a(n)________.

Accepted Answer

The answer of A person,place,object,event,or concept about which the organization...

Question 17

A meaningful relationship between entity types is called a(n)________.

Accepted Answer

The answer of A meaningful relationship between entity types is...

Question 18

How is a strong entity different from a weak entity?

Accepted Answer

A strong entity type exists independentl...

Question 19

When choosing an identifier,choose one that will not change its value often.

Accepted Answer

A) True 
 B)False

Question 20

A fact is an association between two or more terms.

Accepted Answer

A) True 
 B)False

Exam 2: Modeling Data in the Organization

In the following diagram,which is true?

Correct AnswerverifiedShow Answer

One reason to use an associative entity is if the associative entity has one or more attributes in addition to the identifier.

Correct AnswerverifiedShow Answer

The number of entity types that participate in a relationship is called the:

Correct AnswerverifiedShow Answer

A fact is an association between two or more terms.

Correct AnswerverifiedShow Answer

A meaningful relationship between entity types is called a(n)________.

Correct AnswerverifiedShow Answer

The common types of entities are:

Correct AnswerverifiedShow Answer

When choosing an identifier,choose one that will not change its value often.

Correct AnswerverifiedShow Answer

In an E-R Diagram,an associative entity is represented by a rounded rectangle.

Correct AnswerverifiedShow Answer

For the relationship represented in the figure below,which of the following is true?

Correct AnswerverifiedShow Answer

What is the difference between a simple attribute and a composite attribute?

Correct AnswerverifiedA simple attribute cannot be broken down...View AnswerShow Answer

How is a strong entity different from a weak entity?

Correct AnswerverifiedA strong entity type exists independentl...View AnswerShow Answer

Data names should always relate to business characteristics.

Correct AnswerverifiedShow Answer

The following figure shows an example of:

Correct AnswerverifiedShow Answer

A ________ is an association between two or more terms.

Correct AnswerverifiedShow Answer

In an E-R diagram,there are ________ business rule(s) for every relationship.

Correct AnswerverifiedShow Answer

Data rather than processes are the most complex aspects of many modern information systems.

Correct AnswerverifiedShow Answer

In the figure shown below,which of the following is true?

Correct AnswerverifiedShow Answer

The logical representation of an organization's data is called a(n) :

Correct AnswerverifiedShow Answer

A person,place,object,event,or concept about which the organization wants or needs to store data is called a(n)________.

Correct AnswerverifiedShow Answer

The following figure shows an example of:

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A simple attribute cannot be broken down...
View Answer

Correct Answer
verified
A strong entity type exists independentl...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified