Quiz # 2 (Chapter 3 & 4)
12 Questions
| Attempts: 154
Spring 2010, Database System Quiz # 2
Questions and Answers
- 1.If an attribute has different number of values for each entity, it will be modeled as:
- A.
Atomic
- B.
Composite
- C.
Derived
- D.
Multivalued
- 2.Each simple attribute of an entity type is associated with a value set, which specified the set of values that may be assigned to that attribute for each individual entity. This value set is called
- A.
Attribute
- B.
Entity
- C.
Domain
- D.
Constraint
- 3.The key attribute is chosen after carefully studying the
- A.
ER Diagram
- B.
Text Book
- C.
User Requirements
- D.
DBMS
- 4.The basic object that the ER model represents is
- A.
Entity
- B.
Cardinality
- C.
Participation
- D.
Relationship
- 5.The attribute which is not divisible and has only one meaning is called a
- A.
Derived Attribute
- B.
Atomic Attribute
- C.
Composite Attribute
- D.
Single Attribute
- 6.Entity types which can not exists independently are called
- A.
1:1
- B.
Strong
- C.
Weak
- D.
Derived
- 7.A collection of entities that have the same attributes is called
- A.
ER Diagram
- B.
Entity Type
- C.
Entity Set
- D.
ER Schema
- 8.An entity type usually has an attribute whose values are distinct for each individual entity in the entity set. Such an attribute is called a
- A.
Global Attribute
- B.
Underlined Attribute
- C.
Key Attribute
- D.
Derived Attribute
- 9.Each simple attribute of an entity type is associated with a _______________ , which specified the set of values that may be assigned to that attribute for each individual entity.
- 10.The degree of a relationship is the number of ________ in it.
- 11.The participation constraint is defined as the:
- A.
Min # of relationships possible
- B.
Mix # of relationships possible
- C.
Min # of relationships required
- D.
Mix # of relationships required
- 12.In addition to the all the modeling concepts of ER model, the EER includes the concepts of
- A.
Subclass \ superclass & specialization \ generalization
- B.
Specialization \ generalization & relationship
- C.
Subclass \ superclass & specialization
- D.
Superclass & specialization \ generalization
Related Topics
Back to top