INMT 342 EXAM 1 ACTUAL QUESTIONS AND 100

INMT 342 EXAM 1 (ACTUAL / ) QUESTIONS AND 100%

VERIFIED CORRECT ANSWERS 100%

attributes - ----Answers----- properties or characteristics of entities or relationships

• actual data we want to capture

classifications of attributes - ----Answers----- identifier

• required
• composite
• multi-valued
• derived

identifier (underlined) - ----Answers----identifies individual instances of an entity type (ex. employee ID)

required attributes (bolded) - ----Answers----must be captured for a valid entity (ex. employee ID)

composite attribute (...) - ----Answers----can be broken down further (ex. employee name(...))

multi-valued attribute { } - ----Answers----has multiple values (ex. {skills})

• / 2

derived attribute [ ] - ----Answers----value can be calculated from the values of other attributes (ex. [years employeed])

associative entity - ----Answers----- entity and relationship

• many-to-many
• relationship attribute
• more than two entities involved

subtypes and supertypes - ----Answers----1. share some attributes, but not others

• subtypes inherit all attributes

completeness constraint - ----Answers----must every entity in the supertype belong to a suptype also? (total vs partial specialization)

disjointness constraint - ----Answers----can en entity instance belong to more than one subtype? (disjoint vs overlap)

partial specialization - ----Answers----instance of the supertype that is not a subtype (model with single line)

total specialization - ----Answers----every instance of the supertype must be a subtype (model with double lines)

• / 2