Complete Systems Analysis: The Workbook, the Textbook, the Answers

4.3. Solutions: Data Models

Before You Reached Here ...

You have attempted the data model problem given in Chapter 2.5 Data Models. Even if you haven’t, you will benefit from reading this discussion and relating it to the problem statement.

Exercise: The Barbican Data Model

The data model that we derived from the user’s statement and from the sample documents is shown in Figure 4.3.1.

Figure 4.3.1: Data model for the Barbican Centre exercise.

A partial data dictionary to accompany the data model is this:

Booking = Booking Date + Booking Price Paid + Booking Discount Amount

Discount Qualification = * Data element *[“School Child” | “Senior ...