Defining the Preliminary Table List

During this portion of the database-design process, you'll define a preliminary table list that you'll use to identify and establish the tables for the new database. You'll use three procedures to develop this list. The first involves using the preliminary field list, the second involves using the list of subjects you gathered during the interviewing process, and the third involves using the mission objectives you defined at the beginning of the database-design process. You'll then move on to build the structure of each table using fields from the preliminary field list.

Identifying Implied Subjects

The process of defining the tables for the database begins with a review of the preliminary field list. ...

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.