Our study of entity-relationship design inChapter 7 provides an excellent starting
point for creating a relational database design. We saw in Section 7.6 that it
is possible to generate a set of relation schemas directly from the E-R design.
Obviously, the goodness (or badness) of the resulting set of schemas depends
on how good the E-R design was in the first place. Later in this chapter, we shall
study precise ways of assessing the desirability of a collection of relation schemas.
However, we can go a long way toward a good design using concepts we have
already studied.