Deck 8: Structuring System Data Requirements

Question 1

An ________ model is a detailed,logical representation of the entities,associations,and data elements for an organization or business area.

A)E-D
B)E-O
C)E-R
D)E-A

Answer 1

C

Question 2

Each entity type in an E-R model is given a ________ because it represents a class or set,it is singular.

A)Class
B)Type
C)Name
D)Degree

Answer 2

C

Question 3

An entity ________ is described just once in a data model,whereas many ________ of that may be represented by data stored in the database.

A)Type; instances
B)Type; classes
C)Instance; types
D)Class; objects

Answer 3

A

Question 4

Conceptual data modeling is not done in parallel with other requirements analysis and structuring steps during systems analysis.

Question 5

The other deliverable from conceptual data modeling is a full set of entries about data objects that will be stored in the project dictionary,repository,or data modeling software.

Question 6

A(n)________ is a person,place,object,event,or concept in the user environment about which the organization wishes to maintain data.

A)Dimension
B)Attribute
C)Object
D)Entity

Question 7

Event entity types should be named for the result of the ________,not the activity or process of the event.

A)Event
B)Class
C)Entity
D)Object

Question 8

The process of conceptual data modeling begins with developing a conceptual data model for the system being replaced,if a system already exists.This is essential for planning the conversion of the current files or database into the database of the new system.

Question 9

A common mistake many people make when they are just learning to draw E-R diagrams,especially if they already know how to do data flow diagramming,is to confuse data entities with ________ and relationships with data flows.

A)Classes
B)Sinks
C)Relationships
D)Attributes

Question 10

During requirements structuring,a ________ model represents conceptual data requirements for a particular system.

A)Business
B)Project
C)Data
D)Relationship

Question 11

The most common format used for data modeling is ________ diagramming.

A)Entity-class
B)Entity-object
C)Entity-subject
D)Entity-relationship

Question 12

The primary deliverable from the physical data modeling step within the analysis phase is an E-R diagram.

Question 13

Describe conceptual data modeling.How is it used? Describe the process.

Question 14

Why do some systems developers believe the data model is the most important part of IS requirements?

Question 15

A physical data model is a detailed model that captures the overall structure of organizational data that is independent of any database management system or other implementation considerations.

Question 16

An entity ________ is a collection of entities that share common properties or characteristics.

A)Object
B)Type
C)Subject
D)Relationship

Question 17

An entity ________ is a single occurrence of an entity type.

A)Instance
B)Object
C)Attribute
D)Class

Question 18

On what basis are objects referenced,selected,qualified,sorted,and categorized?

A)Attributes and secondary keys
B)Entities
C)Primary keys
D)Index

Question 19

What unique characteristic(s)distinguish(es)each object from other objects of the same type?

A)Secondary key
B)Primary key
C)Composite key
D)Index

Question 20

A(n)________ data model is a detailed model that captures the overall structure of organizational data that is independent of any database management system or other implementation considerations.

A)Conceptual
B)Physical
C)Logical
D)Entity

Question 21

Similar attributes of different entity types should use ________ but distinguishing names.

A)Similar
B)Different
C)Unique
D)Duplicate

Question 22

A(n)________ is an association between the instances of one or more entity types that is of interest to the organization.

A)Attribute
B)Repeating group
C)Relationship
D)Identifier

Question 23

An entity instance (also known simply as an instance)is a single occurrence of an entity type and is described just once in a data model,whereas many instances of that entity type may be represented by data stored in the database.

Question 24

An object type is a collection of entities that share common properties or characteristics.

Question 25

The ________ of a relationship is the number of entity types that participate in that relationship.

A)Object
B)Degree
C)Identifier
D)Measure

Question 26

A ternary relationship is a simultaneous relationship among instances of ________ entity type(s).

A)One
B)Two
C)Three
D)Ten

Question 27

A unary relationship is a relationship between the instances of ________ entity type(s).

A)One
B)Two
C)Three
D)Five

Question 28

A(n)________ is an entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances.

A)Relationship
B)Associative entity
C)Identifier
D)Cardinality

Question 29

A ________ relationship is a relationship between instances of two entity types and is the most common type of relationship encountered in data modeling.

A)Secondary
B)Binary
C)Primary
D)Ternary

Question 30

A(n)________ is an attribute that has meaningful component parts.

A)Optional attribute
B)Composite attribute
C)Required attribute
D)Derived attribute

Question 31

A(n)________ is an attribute that may not have a value forevery entity instance.

A)Required attribute
B)Derived attribute
C)Composite attribute
D)Optional attribute

Question 32

A ________ key is an attribute (or combination of attributes)that uniquely identifies each instance of an entity type.

A)Primary
B)Unique
C)Candidate
D)Duplicate

Question 33

The ________ defines the number of instances of entity B that can (or must)be associated with each instance of entity A.

A)Cardinality
B)Relationship
C)Identifier
D)Association

Question 34

A(n)________ is an attribute that must have a value forevery entity instance.

A)Derived attribute
B)Composite attribute
C)Required attribute
D)Optional attribute

Question 35

A(n)________ is a named property or characteristic of an entity that is of interest to the organization.

A)Event
B)Instance
C)Relationship
D)Attribute

Question 36

Event entity types should be named for the result of the event,not the activity or process of the event.

Question 37

A recursive relationship is also known as a ________ relationship.

A)Binary
B)Ternary
C)Secondary
D)Unary

Question 38

A(n)________ is an attribute that may take on more than one value for each entity instance.

A)Multi-valued attribute
B)Single-valued attribute
C)Identifier
D)Candidate key

Question 39

An entity has its own identity that distinguishes it from each other entity.

Question 40

A(n)________ is an attribute whose value can be computed from related attribute values.

A)Derived attribute
B)Composite attribute
C)Required attribute
D)Optional attribute

Question 41

A ternary relationship is a relationship between instances of two entity types and is the most common type of relationship encountered in data modeling.

Question 42

An entity type that associates the instances of only one type and contains attributes that are peculiar to the relationship between those entity instances.

Question 43

A ________ is an entity type that is meaningful to the organization and that shares common attributes or relationships distinct from other sub-groupings.

A)Repeating group
B)Multi-valued
C)Super-type
D)Subtype

Question 44

An identifier is a candidate key that has been selected to be used as the unique characteristic for an entity type.

Question 45

The ________ rule specifies that if an entity instance of the super type is a member of one subtype,it cannot simultaneously be a member of any other subtype.

A)Business
B)Overlap
C)Disjoint
D)Partial specialization

Question 46

List at least four requirements for determination questions for data modeling.Include a question and which asset is related to that determination.

Question 47

List and explain the following key data modeling terms: entity,attribute,relationship,degree,cardinality,and associative entity.

Question 48

A state is a named property or characteristic of an entity that is of interest to the organization.

Question 49

One situation in which a relationship must be turned into an associative entity is when the associative entity has other relationships with entities besides the relationship that caused its creation.

Question 50

A relationship definition explains what action is being taken and possibly why it is important.It may be important to state who or what does the action,but it is not important to explain how the action is taken.

Question 51

The ________ rule specifies that each entity instance of the super-type must be a member of some subtype of the relationship.

A)Partial specialization
B)Business
C)Overlap
D)Total specialization

Question 52

What is the link between a data model and a DFD?

Question 53

The ________ rule specifies that an entity instance of the super type does not have to belong to any subtype.

A)Total specialization
B)Partial specialization
C)Overlap
D)Disjoint

Question 54

Define unary,binary,and ternary relationships.Provide an example of each relationship.

Question 55

A supertype is a generic entity type that has a relationship with one or more subtypes.

Question 56

The minimum cardinality of a relationship is the minimum number of instances of entity B that may be associated with each instance of entity A.

Question 57

An aggregation is an association between the instances of one or more entity types that is of interest to the organization.

Question 58

Explain the concept of cardinality.Give an example.

Question 59

A primary key is an attribute (or combination of attributes)that uniquely identifies each instance of an entity type.

Question 60

Naming relationships can be difficult.Describe at least three guidelines for naming relationships.

Question 61

A domain is the set of all data types and ranges of values that ________ may assume.

A)Entities
B)Instances
C)Attributes
D)Events

Question 62

Domain definitions typically specify some (or all)of the following characteristics of attributes: data type,length,format,range,allowable values,meaning,uniqueness,and null support (whether an attribute value may or may not be null).

Question 63

The disjoint rule specifies that if an entity instance of the supertype is a member of one subtype,it can simultaneously be a member of any other subtype.

Question 64

Which business rule specifies constraints on valid values for attributes?

A)Triggering operations
B)Referential integrity
C)Entity integrity
D)Domains

Question 65

Define domains for the following attributes: Account number.

Question 66

A(n)________ is an assertion or rule that governs the validity of data manipulation operations such as insert,update,and delete.

A)Domain
B)Event
C)Referential integrity
D)Triggering operation

Question 67

Projects with purchased models take less time and cost more because the initial discovery steps are no longer necessary,leaving only iterative tailoring and refinement to the local situation.

Question 68

The ________ rule specifies that an entity instance can simultaneously be a member of two (or more)subtypes.

A)Business
B)Overlap
C)Disjoint
D)Total specialization

Question 69

Which business rule specifies rules concerning the relationships between entity types?

A)Triggering operations
B)Referential integrity constraints
C)Entity integrity
D)Domains

Question 70

Briefly identify four important business rules for supertype/subtype relationships.

Question 71

A(n)________ is a concise statement of the business rule to be enforced by the triggering operation.

A)Event
B)User rule
C)Action
D)Condition

Question 72

There is/are ________ principal type(s)of packaged data model(s).

A)One
B)Two
C)Three
D)Five

Question 73

Which business rule specifies that each instance of an entity type must have a unique identifier that is not null?

A)Triggering operations
B)Referential integrity
C)Entity integrity
D)Domains

Question 74

________ rules are specifications that preserve the integrity of the logical data model.

A)Business
B)Disjoint
C)Overlap
D)Total specialization

Question 75

Which business rule specifies the validity of attribute values?

A)Triggering operations
B)Referential integrity
C)Entity integrity
D)Domains

Question 76

A(n)________ is the data manipulation operation (insert,delete,or update)that initiates the operation.

A)Event
B)User rule
C)Action
D)Condition

Question 77

Define triggering operation.Provide an example and include the components.

Question 78

________ data models are generic data models that are designed to be used by organizations within specific industries.

A)Universal
B)Conceptual
C)Logical
D)Industry-specific

Question 79

The term ________ data model means a conceptual data model with some additional properties associated with the most popular type of database technology like relational databases.

A)Universal
B)Physical
C)Logical
D)Industry-specific

Question 80

How many types of business rules are there in conceptual data modeling?

A)One
B)Two
C)Three
D)Four