"PRIDE"-Data Base Engineering Methodology (DBEM)

PRIDE

-DBEM

Data Base Engineering Methodology
PHASE 5 - APPLICATION 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 5 - APDBM 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)? _______ APDBM FILES MATRIX YES/NO? A. Are all of the APDBM physical files for the data base present? _______ B. Does the matrix accurately show file relationships? _______ APDBM RECORDS MATRIX YES/NO? A. Are all of the APDBM 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? _______ ALDBM/APDBM FILES MATRIX YES/NO? A. Are all of the pertinent ALDBM and APDBM files present? _______ B. Does each APDBM file implement at least one ALDBM object? _______ C. Is each ALDBM object implemented by at least one APDBM file? _______ D. Does the APDBM appear to correctly implement the ALDBM? _______ ALDBM/APDBM RECORDS MATRIX YES/NO? A. Are all of the pertinent ALDBM and APDBM records present? _______ B. Does each APDBM record implement at least one ALDBM view? _______ C. Is each ALDBM view implemented by at least one APDBM record? _______ D. Does the APDBM appear to correctly implement the ALDBM? _______ EPDBM/APDBM FILES MATRIX YES/NO? A. Are all of the pertinent EPDBM and APDBM files present? _______ B. Does each APDBM file relate to at least one EPDBM file? _______ C. Does the APDBM appear to correctly relate to the EPDBM? _______ EPDBM/APDBM RECORDS MATRIX YES/NO? A. Are all of the pertinent EPDBM and APDBM records present? _______ B. Does each APDBM record relate to at least one EPDBM view? _______ D. Does the APDBM appear to correctly implement the EPDBM? _______ APPLICATION 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: ____________________________________________________________________________ ____________________________________________________________________________ ____________________________________________________________________________ ____________________________________________________________________________ ____________________________________________________________________________