"PRIDE"-Data Base Engineering Methodology (DBEM)

PRIDE

-DBEM

Data Base Engineering Methodology
PHASE 4 - ENTERPRISE PHYSICAL DATA BASE DESIGN
REVIEW CHECKLIST

TRANSLATE THIS PAGE TO... Chinese (simple) Japanese Dutch French German Italian
Free Translation courtesy of ALS Chinese (traditional) Korean Portuguese Russian Spanish

PROJECT NUMBER/NAME: PHASE 4 - EPDBM DESIGN MANUAL PHASE COVER PAGE YES/NO? A. Are all of the appropriate names listed on the distribution list? _______ B. Has pertinent copyright notation been printed on the report (optional)? _______ C. Has an introductory letter been prepared to summarize the report and schedule the review meeting (optional)? _______ EPDBM NARRATIVE YES/NO? A. Is the narrative written clearly? _______ B. Are the physical storage media requirements clearly defined? (Include manual files as well as computer files.) _______ C. Are the file management tools and techniques clearly defined? _______ D. Are Data Communications considerations clearly defined? _______ E. Does the narrative accurately support the EPDBM Matrices? _______ EPDBM FILES MATRIX YES/NO? A. Are all of the EPDBM physical files for the data base present? _______ B. Does the matrix accurately show file relationships? _______ EPDBM RECORDS MATRIX YES/NO? A. Are all of the EPDBM physical records for the data base present? _______ B. Does the matrix accurately show record relationships? _______ DATA RESOURCE LAYOUTS YES/NO? A. Is there a layout for each Output, Input, File or individual Record? _______ B. Is each physical format clear and understandable? _______ ELDBM/EPDBM FILES MATRIX YES/NO? A. Are all of the pertinent ELDBM and EPDBM files present? _______ B. Does each EPDBM file implement at least one ELDBM object? _______ C. Is each ELDBM object implemented by at least one EPDBM file? _______ D. Does the EPDBM appear to correctly implement the ELDBM? _______ ELDBM/EPDBM RECORDS MATRIX YES/NO? A. Are all of the pertinent ELDBM and EPDBM records present? _______ B. Does each EPDBM record implement at least one ELDBM view? _______ C. Is each ELDBM view implemented by at least one EPDBM record? _______ D. Does the EPDBM appear to correctly implement the ELDBM? _______ ALDBM/EPDBM FILES MATRIX YES/NO? A. Are all of the pertinent ALDBM and EPDBM files present? _______ B. Does each EPDBM file implement at least one ALDBM object? _______ C. Does the EPDBM appear to correctly implement ALDBM requirements? _______ ALDBM/EPDBM RECORDS MATRIX YES/NO? A. Are all of the pertinent ALDBM and EPDBM records present? _______ B. Does each EPDBM record implement at least one ALDBM view? _______ C. Does the EPDBM appear to correctly implement ALDBM requirements? _______ ENTERPRISE PHYSICAL DATA BASE DIAGRAM (ATTACHMENT) YES/NO? A. Does the diagram accurately represent the file management technique being used? _______ B. Does the design appear to be correct and a viable solution? _______ DATA DEFINITION LANGUAGE (ATTACHMENT) YES/NO? A. Have the appropriate DDL Statements been created? _______ B. Do data labels etc. conform to installation standards? _______ C. Are the DDL entries stored in the "PRIDE"-IRM, either in text form, or as special entries for automatic generation? _______ OTHER CONSIDERATIONS YES/NO? A. Has Quality Assurance reviewed/approved the deliverables? _______ NOTES: ____________________________________________________________________________ ____________________________________________________________________________ ____________________________________________________________________________ ____________________________________________________________________________ ____________________________________________________________________________