6 RATIONALISING DATA USING NORMALISATION

This chapter involves a change of direction. Our discussion so far has involved computer-independent models – the models that represent the information needs of a business. They use data modelling notation but they can be called information models as they represent what information needs to be recorded to run the business. This chapter starts to describe a how model – a platform-independent (or logical) data model. We are looking at the first stage of database design.

These models are based upon the theory of the relational model of data. This is the ‘model’ that underpins all of the database management systems that use SQL database language. These models are ‘normalised’ models. This chapter introduces ...

Get Modelling Business Information now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.