SDLC - Analysis Part 3

What is the purpose of E-R diagramming?

• To analyze financial data

• To design user interfaces

• To create simple diagrams for presentations

• To capture the richest possible understanding of the meaning of the data necessary for an information system or organization

What is a candidate key in conceptual data modeling?

• A key used to unlock the database

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

• A key that is randomly generated

• An attribute that is not important

What is the purpose of domains in data modeling?

• To generate reports

• To design user interfaces

• To create relationships between entities

• To verify that the values for an attribute are valid

What is a triggering operation in conceptual data modeling?

• A key used to trigger events in the system

• A type of relationship between entities

• An assertion or rule that governs the validity of data manipulation operations such as insert, update, and delete

• A type of entity in the database

What is the role of prepackaged database models in data modeling?

• To create complex data structures

• To restrict access to the database

• To analyze financial data

• To provide generic models that can be customized for a particular organization’s business rules

What is a unary relationship in data modeling?

• A relationship between one entity type; also called a recursive relationship

• A relationship between two entity types

• A relationship between entities and attributes

• A relationship between three entity types

What are the four basic types of business rules in a conceptual data model?

• Primary keys, foreign keys, indexes, constraints

• Entity integrity, referential integrity constraints, domains, triggering operations

• Data types, relationships, entities, attributes

• Data manipulation, data storage, data retrieval, data security

What is the purpose of a conceptual data model?

• To create detailed reports

• To design user interfaces

• To capture the overall structure of organizational data and be independent of any database management system or other implementation considerations

• To analyze financial data

What is an entity type in data modeling?

• A specific instance of an entity

• A collection of entities that share common properties or characteristics

• A relationship between entities

• A type of database table

What is a multivalued attribute in data modeling?

• An attribute that may take on more than one value for each entity instance

• An attribute that has only one value for each entity instance

• An attribute that is not important

• An attribute that is used for sorting