Checklist: Data Model








var backPath = './../../../';
var imgPath = './../../../images/';
var nodeInfo=[{view: "view:_LVCagP5WEdmAzesbYywanQ", path: ["_LVCagP5WEdmAzesbYywanQ", "_zRigkAILEdq-_NKqZM1EhA", "_QV4x0AISEdqTna4sZVFRow", "_kjFBYN7HEdm8G6yT7-Wdqw", "{9DCF1723-1A21-4F48-BEDE-DBC543489682}", "2.800761632096845E-305"]}, {view: "view:_FCx1oN7CEdmsEI4YDGX2ag", path: ["_FCx1oN7CEdmsEI4YDGX2ag", "_Jvt1cAIaEdqEutyfYo0quQ", "_EOvXUN7HEdm8G6yT7-Wdqw", "_kjFBYN7HEdm8G6yT7-Wdqw", "{9DCF1723-1A21-4F48-BEDE-DBC543489682}", "2.800761632096845E-305"]}, {view: "view:_FCx1oN7CEdmsEI4YDGX2ag", path: ["_FCx1oN7CEdmsEI4YDGX2ag", "_Jvt1cAIaEdqEutyfYo0quQ", "_jijhYAIaEdqEutyfYo0quQ", "_mTMIkN7REdmjRZts2c4ZjQ", "{9DCF1723-1A21-4F48-BEDE-DBC543489682}", "2.800761632096845E-305"]}, {view: "view:_FCx1oN7CEdmsEI4YDGX2ag", path: ["_FCx1oN7CEdmsEI4YDGX2ag", "_jD8dUAIbEdqEutyfYo0quQ", "_wl69ADIdEdqDs_9ORT1Rig", "2.800761632096845E-305"]}];
contentPage.preload(imgPath, backPath, nodeInfo, '', true, false, false);

//override the subsection text
contentPage.subSection.expandAllText = 'Expand All Check Items';
contentPage.subSection.collapseAllText = 'Collapse All Check Items';










Checklist: Data Model















This checklist helps make sure that the Data Model is correct and complete.






Relationships



Related Elements


Database Design


Data Model






Main Description







Check Items




All persistent classes that use the database for persistency have been mapped to database structures







Many-to-many relationships have an intersecting table







Primary keys have been defined for each table, unless there is a performance reason not to define a primary key







The storage and retrieval of data has been optimized



If a relational database is used, tables have been denormalized (where necessary) to improve performance. Where denormalization has been used, all update, insert and delete scenarios have been considered to ensure the denormalization does not degrade performance for those operations.



Indexes have been defined to optimize access







The impact of index updates has been considered in the other table operations







The distribution of data has been planned







Data and referential integrity constraints have been defined







A plan exists for maintaining validation constraints when the data rules change







Stored procedures and triggers have been defined







The persistence mechanism uses stored procedures and database triggers consistently













©  Copyright IBM Corp. 1987, 2006.  All Rights Reserved.







contentPage.onload();