book

Modelling Business Information

by Keith Gordon

September 2017

Intermediate to advanced

202 pages

5h 38m

English

BCS, The Chartered Institute for IT

Read now

Unlock full access

What is business analysis?Information and dataThe importance for a business analyst of understanding information needsThe role of models in business analysisData models and dataEntity relationship modellingClass modellingUse of data models in business analysisWhat makes a good data model?Introducing data analysis
Entities and objectsNaming of entity types and object classesIntroduction to relationships and associationsRelationship notation in entity relationship modelsAssociation notation in UML class modelsDegrees of cardinality and optionalityMultiple relationships and associationsRecursive relationships and reflexive associationsExercises for Chapter 2
The problems with many-to-many relationships and associationsResolving entity relationship model many-to-many relationships Resolving class model many-to-many associationsThe ‘bill of materials’ structureMutually exclusive relationships and associationsGeneralisation and specialisation in entity relationship modelsGeneralisation and specialisation in class modelsAggregation and compositionExercises for Chapter 3
The model drawing processIdentifying the entity types or the object classesIdentifying the relationships or associationsDrawing the initial diagramValidating the diagramExercises for Chapter 4
Revisiting entity types, object classes, relationships and associationsIntroduction to attributesThe naming of attributesEntity type, object class or attribute?Unique identifiersDomainsThe UML extended attribute notationShowing operations on class modelsExercises for Chapter 5
What is normalisation?The relational model of dataThe rules of normalisationStarting the normalisation processFirst normal formSecond normal formThird normal formThe third normal form data modelCandidate keys, primary keys and alternate keysThe relationship of normalisation to modellingExercises for Chapter 6
The IDEF1X notationThe Information Engineering notationThe Chen notationComparison of the notations
The naming of entity types or object classesThe naming of domainsThe naming of attributesThe naming of relationships in Ellis-Barker entity relationship models The naming of associations on UML class models
Genericity and specificity in modelsThe nine characteristics of a good data model The six principles of high quality data models The five dimensions of data model qualityThe layout of models
The problems Principles for the development of a corporate model
The data landscapeDatabases
The data warehouseThe multidimensional model of dataDimensional modelling
The basics of SQLNew SQL data typesThe futureImplications for business analysts and information modellers
First-cut database design stageOptimised database design stage