Defining the Final Table List

Your preliminary table list is as complete as it can be at this point, so you'll now transform it into a final table list. This new list incorporates two elements that are not currently on the preliminary table list: table type and table description. Figure 7.9 shows an example of a final table list.

Figure 7.9. An example of a final table list.

image

A table type allows you to classify a table by the role it plays within the database and provides you with a means of identifying tables that function in a similar manner. The table's role determines its type, and there are four table types that you can associate with ...

Get Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition now with O’Reilly online learning.

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