Modeling Data in the Organization - General Questions

1.

A good business rule is which of the following?

A.	Declarative
B.	Imprecise
C.	Redundant
D.	Compound

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

2.

When the minimum number of instances of an entity is one, you know which of the following?

A.	Mandatory one
B.	Optional one
C.	Mandatory many
D.	Cannot tell

Answer: Option D

Explanation:

No answer description available for this question. Let us discuss.

3.

A ternary relationship involves how many entities?

A.	3 or less
B.	3
C.	More than 3
D.	3 or more

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

4.

A binary relationship cannot be which of the following?

A.	One-to-One
B.	One-to-Many
C.	Many-to-Many
D.	Zero-to-Zero

Answer: Option D

Explanation:

No answer description available for this question. Let us discuss.

5.

A composite attribute is which of the following?

A.	An attribute that can be broken into components
B.	An attribute that cannot be broken into components
C.	Multiple attributes
D.	An identifier

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

6.

An attribute name should be which of the following?

A.	Singular verb or verb phrase
B.	Follow a standard format
C.	Use a alias
D.	All of the above.

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

7.

When the minimum and maximum number of instances of an entity is one, you know which of the following?

A.	Mandatory one
B.	Optional one
C.	Mandatory many
D.	Cannot tell

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

8.

An oval represents which of the following in an ERD?

A.	Attribute
B.	Entity
C.	Optional One
D.	Relationship

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

1
2