Business Analysis 2 - Data modelling

When should Business Analysts model information?

(Select all relevant answers)

• To understand the information needs of the business

• To define the solution requirements correctly

• To plan and design the integration of enterprise applications

• To design a database

Select the data modelling notations.

• IDEF0

• IDEF1X

• BPMN

• Information Engineering

• UML class diagrams

Which of the two statements is correct in relation to E-R diagrams?

• M2M relationships are allowed

• M2M relationships are not allowed

Why are many-to-many (M2M) relationships recommended to be resolved?

(Select all relevant reasons)

• They don't look nice on diagrams

• Data models become complicated if these are not resolved

• Relational databases can't accommodate M2M relationships

• Many Business Analysts simply don't like M2M relationships

• M2M relationships can hide some information, which can be useful for accurate modelling

Why should redundant relationships in data models be avoided?

(Select the correct reason)

• Data models can become needlessly complicated

• Redundant relationships are simply not allowed

• Many Business Analysts simply don't like them

• Relational DBs can't accommodate them

What is a ternary relationship in data modelling?

• A relationship between three entities

• Three different relationships between a pair of entities

• Three relationships logically combined into one

• Three similar relationships between any pairs of entities

Ternary relationships are ...

(Continue the sentence with the correct statement)

• Allowed in all data modelling notations

• Not allowed in all data modelling notations

• Allowed only in Chen's notation

• Allowed only in Ellis-Barker's notation

• Allowed only in Information Engineering notation

Why is it recommended to create generic data models?

(Select all relevant reasons)

• More simple diagrams are always better!

• To avoid complexity and inflexibility when dealing with many various entity types

• Generic models represent the modelled situation more accurately

• To create future-proof models (To be ready to cover various situations)