Exam 7: Structuring System Requirements: Conceptual Data Modeling

A relationship between instances of two entity types is a:

Cardinality is the number of instances of entity B that can (or must) be associated with each instance of entity A.

Which of the following types of alternatives represent compromise solutions?

Match each of the following alternatives with its corresponding description.(Answers may occur more than once.) -These alternatives are the most conservative in terms of the effort, cost, and technology involved in developing a new system.

An entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.

For each of the following statements, answer "a" if it is a true statement or answer "b" if the statement is false. -A recursive relationship is a relationship between the instances of two entity types.

During the alternative generation and selection step of the analysis phase, you would propose different ways to source or acquire the various sets of capabilities for the different implementation environments.

When generating alternative design strategies, a high-end alternative will provide all desired features using advanced technologies that often allow the system to expand to meet future requirements.

Match each of the following terms with its corresponding definition. -An attribute that can have more than one value for each entity instance

Reviewing computer screens, reports, and business forms for the purpose of gaining an understanding of data is indicative of the:

For each of the following statements, answer "a" if it is a true statement, or answer "b" if the statement is false. -Many instances of an entity type may be represented by data stored in the database.

Some systems developers believe that a data model is the most important part of the statement of information system requirements because:

An analyst would ask "What must we know about each object in order to run a business?" in order to determine relationships, their cardinality, and degrees.

What are multivalued attributes and repeating groups? Provide an example of each.

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

During alternative generation and selection, management may decide to end the project for a variety of reasons, including the fact that the needs of the organization have changed.

For each of the following statements, answer "a" if it is a true statement, or answer "b" if the statement is false. -Upper- and lowercase letters are used in naming an entity type.

In order to determine attributes and secondary keys, an analyst might ask, "What characteristics describe each object?"

For each of the examples listed below, indicate if it is a relationship, an entity, or an attribute.(Answers may occur more than once.) -sale

Briefly discuss generating alternative design strategies.