From Data Model to Relational Database Design
Let’s recap the story so far, in our endeavors to design a database. We started with use cases to describe the basic requirements of a problem and developed an initial data model. By looking carefully at the details of the model, we were able to develop questions to help understand further subtleties and complexities of the real–world problem. We then looked at a number of situations that occur in many models in the hope that these would be useful when difficult situations arose in other contexts.
The goal is not to attempt to get a perfect or complete model. The outcome we are seeking ...