ECM3434 Business Analysis 1 - Data Modelling

Why do we need data modeling in Business Analysis projects? (Select all that apply)

• To model data to be created, stored, and manipulated by a system

• To understand the required functionality of a system

• To understand business rules that govern data creation, storage, manipulation and retrieval in a system

• Data models help decrease the development costs of a solution

Is data modelling exclusively useful for BA projects that involve creating new systems from scratch?

• Yes, it is only useful for such projects

• No, data modelling is versatile and can aid various BA projects

• No, it is only useful for projects involving off-the-shelf solutions

Which of the following are recognized as data modelling techniques or notations? (Select all that apply)

• UML class diagram

• UML use case diagrams

• Chen's notation

• IDEF1X

• Ellis-Barker notation

Which of the following methods are effective for gathering data necessary for developing data models?

(Select all that apply)

• Interviewing stakeholders

• Observing business processes

• Analysing organisational documentation

• Just guessing

• Creating and analysing business process models

What type of data model should be created to understand the main blocks of information and data in the business environment?

• Logical data model

• Conceptual data model

• Physical data model

What type of data model should be created in order to design a data structure in detail, for example, a database?

• Conceptual data model

• Physical data model

• Logical data model

What aspects can business rules define? (Select all that apply)

• Organisational policy constraints

• Legal and regulatory constraints

• Operational procedures

Select one statement you mostly agree with

• A business analyst should never question business rules

• A business analyst should understand the reasons behind business rules and question them only if it is allowed and necessary for process improvement

• A business analyst should always question business rules as this is the only approach to process improvement

What role do business rules play in data modelling?

(Select all that apply)

• They determine the structure and constraints of the data model

• They are crucial for defining the relationships between different data entities

• They have no role in the data modelling process

• They help in pinpointing essential data entities for accurate business analysis

Why is it important to resolve M2M relationships in data models?

(Select all that apply)

• Data models can't have M2M relationships

• Relational DBMS can't model M2M relationships

• A diagram with M2M relationships does not represent data items efficiently

• M2M relationships can hide other important entities and their attributes, which can be useful for accurate modelling