Chapter 20

Structured System Analysis and Design


Chapter Summary

Structured methods take a system requirement and construct a logical design before moving on to the physical design of the new system. In analysing the requirement, complex problems are decomposed into their component sub-systems for further analysis and design. Structured methods make extensive use of diagramming techniques to represent the requirement and the proposed system. These techniques include:

  • Data flow diagrams.
  • Logical data structure / entity relationship diagram.
  • Relational data analysis.
  • Entity life histories.
We looked at the lifecycle in the last chapter and, in this chapter (and with a bit of practice) we will learn these four ways of modelling and designing the system. It is noted that most chapters in this book are intended to be covered as a single unit of study (a lecture and a tutorial / self study). This chapter will take considerably longer, say four units of study.

Erratum

In the section on relational data analysis there is an error in the Second Normal Form column of figure 12.10. The bicycle attributes have been assigned to the bicycle entity (key bike-reg-no) and should have been removed from the rental line (key: rental-no + bike-reg-no).



Link to Exercises for Chapter 20
Link to Slides for Chapter 20
Link to Test for Chapter 20 link not yet activated


Home | Chapters | Information