Database - ER Model and Business Rules

Exercise :: ER Model and Business Rules - General Questions

6. 

A rectangle represents which of the following in an EER?

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

Answer: Option B

Explanation:

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

7. 

Which one of the following symbols is not used in an ERD?

A. Rectangle
B. Oval
C. Diamond
D. Circle

Answer: Option D

Explanation:

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

8. 

Specialization is which of the following processes?

A. Defining one or more subtypes of the supertype and forming supertype/subtype relationships.
B. Defining one or more supertypes of the subtype and forming supertype/subtype relationships.
C. Defining one or more subtypes of the supertype and not forming supertype/subtype relationships.
D. Defining one or more supertypes of the subtype and not forming supertype/subtype relationships.

Answer: Option A

Explanation:

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

9. 

Which of the following statements concerning business rules is true?

A. It should be complex.
B. It should not be convertible to computer code.
C. It may include restrictions.
D. All of the above.

Answer: Option C

Explanation:

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

10. 

A supertype/subtype hierarchy has which of the following features?

A. Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.
B. Attributes are assigned at the highest logical level.
C. Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
D. Attributes are assigned at the lowest logical level.

Answer: Option B

Explanation:

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