CHAPTER 7From Data Model to Relational Schema

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 about 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.

There is no way to get a perfect or complete model. All that can be done is to agree on a model that accurately reflects the essential requirements of the real-world problem. This will involve numerous ...

Get Beginning Database Design now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.