System Development: Process Modeling, Data Flow Diagrams, and Data Modeling Techniques
What do physical data models focus on?
All except data groups and data object relationship
During which phase are logical data models developed?
Analytical phase
Which of the following is not a primary concern when developing a physical data model?
Classification and identification of opportunities
What is the highest level in the hierarchy of DFDs?
Context diagram
What are some benefits of process modeling in system development?
Improved efficiency and coordination
What does an External Entity represent in a DFD?
It symbolizes an actor external to the system
What is the purpose of balancing in DFD development?
To ensure that the DFDs align with use cases
What is the primary goal of process modeling in system development?
To identify potential areas of improvement in internal processes
What is normalization used for?
To remove attribute redundancy between data entities in relational model design
Which process do systems analysts perform to ensure that a model accurately represents real-world conditions and functions as intended?
Validation
How can attributes be defined?
As a property or characteristic of an entity
Which type of file helps ensure data integrity by storing records of all updates, deletions, and insertions made to a database?
Audit files
What refers to the number of times instances of one entity can be related to instances of another entity?
Cardinality
What term describes the number of associations that can exist between instances of two connected entities in a data model?
Cardinality
Which technique is commonly used for developing system process models?
Data flow diagrams (DFDs)
Which of the following is NOT one of the four main elements of a DFD?
Data variables
What best describes the 1:1 (one to one) relationship?
Each apartment will only have one mailbox and each mailbox will only be for one apartment
What is part of the outline for a system DFD creation?
Identify major processes of the system
What is NOT a benefit from logical process modeling?
Identify the start and end points of a given process
Which statement is true for Level 1 DFD?
It does not depict the external entities that receive information from or contribute information to the system
How is data modeling different from process modeling?
It looks at how data is organized and used by the system at a more granular level
What are the two types of process models commonly developed in system development?
Logical and physical process models
Which relationship type involves more than two entities, rather than a binary relationship?
Many to many
What technique is used in relational model design to remove attribute redundancy between data entities?
Normalization
Which type of process model focuses on how data will be stored in files and databases?
Physical process models
