1 For every schema, list Schema, # tables, # records

2 For every schema, list table name, # attributes,# PK_ attr, # FK_ attr, # NN_attr, # IDX_attr, # CC_attr, # UQ_attrs, # PGM_attr" 3 For every schema, list Table_ID, Table_Name, attribute_id, attribute_Name, PK_ID, FK_ID, NN_ID, constraint_type, and constraint_Name

4 For every schema, analyze PK, FK,and IDX a: list tables without PK b: list tables with PK but without FK c: list tables with PK but without IDX

5 For every database/schema, a: rank them according to number of NN (Not Null) have created B: For every tebles list fields with NN

6 For every database, list tables without PK