Exam 7: Structuring System Requirements: Conceptual Data Modeling

Constraints on systems development may include such factors as:

The most common format used for data modeling is:

A simultaneous relationship among instances of three entity types is a:

Discuss unary, binary, and ternary relationships.

Identifying mandatory features by surveying users and other stakeholders who have been involved in requirements determination would occur:

For each of the following statements, answer "a" if it is a true statement or answer "b" if the statement is false. -The name of the identifier of each entity is underlined on an E-R diagram.

During systems design, a conceptual data model with attributes is prepared.

During alternative generation and selection, choices on the implementation environment may place technical limitations on the subsequent design phase activities.

A ternary relationship is the equivalent of three binary relationships.

An attribute (or combination of attributes) that uniquely identifies each instance of an entity type defines:

Conceptual data modeling is typically done in parallel with other requirements analysis and structuring steps during:

Analysts should consider substituting single-attribute surrogate keys for large composite keys.

Employee identification number, name, address, and skill are examples of attributes.

During systems planning and selection:

Cost is the primary focus of high-end alternatives.

A system design strategy represents a particular approach to developing a system.

A multivalued attribute is an attribute that may take on more than one value for each entity instance.

Analysts should use intelligent keys as identifiers.

Match each of the following terms with its corresponding definition. -A collection of entities that share common properties or characteristics

Processes, rather than data, are the most complex aspects of many modern information systems.