Assembling the Database Documentation

Throughout the database-design process, you've generated a number of lists, specification sheets, and diagrams used to record various aspects of the database-design. You should now assemble them into a central repository, preferably in a set of binders. (Incidentally, you could generate and store these documents using a computer program.) The design repository should consist of the following sets of documents:

Final table list

Relationship diagrams

Field Specifications sheets

Business Rule Specifications sheets

Calculated-field list

View diagrams

Table structure diagrams

View Specifications sheets

Two additional sets of items you may consider keeping with this documentation are ...

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.