SNHU DAD 220 Exam Questions
With Revised Correct
Detailed Answers
ALREADY GRADED A+ PASS >>
BRAND NEW VERSION!!
1. Cardinality - ANSWER maxima and minima of relationships and
attributes.
2. Attribute maximum - ANSWER greatest number of attribute instances
possible for a single entity instance. Attribute maximum is specified as one
or many
3. Attribute minimum - ANSWER least number of attribute instances
possible for a single entity instance. Attribute minimum is specified as zero
or one
4. Singular attribute - ANSWER each entity instance has at most one
attribute instance
5. Plural attribute - ANSWER each entity instance can have many
attribute instances.
, 6. Required attribute - ANSWER In ER modeling, an attribute that must
have a value. In other words, it cannot be left empty.
7. Optional attribute - ANSWER In ER modeling, an attribute that does not
require a value; therefore, it can be left empty.
8. Unique Attribute - ANSWER attribute whose value is different for each
entity instance
9. On ER diagrams, a 1 follows the name of a unique attribute
10. Relationship maximum - ANSWER greatest number of instances of one
entity that can relate to a single instance of another entity
11. determine maximum for the relationship:
city-iscapitalof-state - ANSWER one-one
12. Determine maximum for the relationship:
Person-Has-Passport - ANSWER one-many
a person can have many passports but a passport can only be for one person
13. Relationship minimum - ANSWER the least number of instances of one
entity that can relate to a single instance of another entity
, A relationship has two minima, one for each of the related entities. Minima are
usually specified as zero or one. On ER diagrams, minima are shown after maxima,
in parentheses. Ex: M(1) or M(0).
14. Dependent Entity - ANSWER An entity that requires a relationship to
another entity for identification.
15. Dependency relationship - ANSWER a relationship between attributes
where one entity only exists in relation to the other entity
16. Master entity - ANSWER The master entity is the entity that the
dependent entity relies on with dependent entity relationships
17. Independent entity - ANSWER does not depend on any other entity
18. Subtype Entity - ANSWER (subcategory) a subset of another entity
type. On ER diagrams, subtype entities are drawn within the supertype.
19. Supertype Entity - ANSWER the entity that has subtype entities
20. Partition - ANSWER a group of mutually exclusive subtype entities.
Subtype entities in a partition cannot share common instances
21. Partition attribute - ANSWER Each partition corresponds to a partition
attribute of the supertype entity.
With Revised Correct
Detailed Answers
ALREADY GRADED A+ PASS >>
BRAND NEW VERSION!!
1. Cardinality - ANSWER maxima and minima of relationships and
attributes.
2. Attribute maximum - ANSWER greatest number of attribute instances
possible for a single entity instance. Attribute maximum is specified as one
or many
3. Attribute minimum - ANSWER least number of attribute instances
possible for a single entity instance. Attribute minimum is specified as zero
or one
4. Singular attribute - ANSWER each entity instance has at most one
attribute instance
5. Plural attribute - ANSWER each entity instance can have many
attribute instances.
, 6. Required attribute - ANSWER In ER modeling, an attribute that must
have a value. In other words, it cannot be left empty.
7. Optional attribute - ANSWER In ER modeling, an attribute that does not
require a value; therefore, it can be left empty.
8. Unique Attribute - ANSWER attribute whose value is different for each
entity instance
9. On ER diagrams, a 1 follows the name of a unique attribute
10. Relationship maximum - ANSWER greatest number of instances of one
entity that can relate to a single instance of another entity
11. determine maximum for the relationship:
city-iscapitalof-state - ANSWER one-one
12. Determine maximum for the relationship:
Person-Has-Passport - ANSWER one-many
a person can have many passports but a passport can only be for one person
13. Relationship minimum - ANSWER the least number of instances of one
entity that can relate to a single instance of another entity
, A relationship has two minima, one for each of the related entities. Minima are
usually specified as zero or one. On ER diagrams, minima are shown after maxima,
in parentheses. Ex: M(1) or M(0).
14. Dependent Entity - ANSWER An entity that requires a relationship to
another entity for identification.
15. Dependency relationship - ANSWER a relationship between attributes
where one entity only exists in relation to the other entity
16. Master entity - ANSWER The master entity is the entity that the
dependent entity relies on with dependent entity relationships
17. Independent entity - ANSWER does not depend on any other entity
18. Subtype Entity - ANSWER (subcategory) a subset of another entity
type. On ER diagrams, subtype entities are drawn within the supertype.
19. Supertype Entity - ANSWER the entity that has subtype entities
20. Partition - ANSWER a group of mutually exclusive subtype entities.
Subtype entities in a partition cannot share common instances
21. Partition attribute - ANSWER Each partition corresponds to a partition
attribute of the supertype entity.
