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.
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
