Discussion
Home ‣ Database ‣ ER Model and Business Rules Comments
- Question
A supertype/subtype hierarchy has which of the following features?
Options- 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.
- Correct Answer
- Attributes are assigned at the highest logical level.
- 1. A subtype entity name should be which of the following?
Options- A. A singular noun
- B. Specific to the organization
- C. Concise
- D. All of the above Discuss
- 2. Which of the following database activities determines the entities, attributes, and relationships of data?
Options- A. Conceptual data modeling
- B. Logical database design
- C. Physical database design and definition
- D. Database implementation Discuss
- 3. CASE tools do not include which of the following features?
Options- A. Help to draw data models
- B. Help to generate code
- C. Help to manage people
- D. Create an information repository Discuss
- 4. Strategic Planning factors do not include which of the following?
Options- A. Organizational goals
- B. Critical success factors
- C. Information engineering
- D. Problem areas Discuss
- 5. In enterprise data modeling, which is incorrect?
Options- A. You review current systems.
- B. You implement the new database.
- C. You describe the data needed at a very high level of abstraction.
- D. You plan one or more database development projects. Discuss
- 6. Which of the following is not one of the three ways to classify an action assertion?
Options- A. Condition
- B. Integrity Control
- C. Authorization
- D. Enabler Discuss
- 7. When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?
Options- A. Disjoint with total specialization
- B. Disjoint with partial specialization
- C. Overlap with total specialization
- D. Overlap with partial specialization Discuss
- 8. An action assertion must include which of the following?
Options- A. Anchor object
- B. Action
- C. Corresponding object
- D. All of the above. Discuss
- 9. An oval represents which of the following in an EER?
Options- A. Attribute
- B. Entity
- C. Optional One
- D. Relationship Discuss
- 10. Which one of the following symbols is not used in an ERD?
Options- A. Rectangle
- B. Oval
- C. Diamond
- D. Circle Discuss
ER Model and Business Rules problems
Search Results
Correct Answer: All of the above
Correct Answer: Conceptual data modeling
Correct Answer: Help to manage people
Correct Answer: Information engineering
Correct Answer: You implement the new database.
Correct Answer: Enabler
Correct Answer: Overlap with total specialization
Correct Answer: All of the above.
Correct Answer: Attribute
Correct Answer: Circle
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.