SQL DATA BASE METRIC REPORT
Database type: SQL - DB2Date: 03.05.2017
System: DB2DBS
DATABASE METRICS BY TABLES
Table Name Nr Lines Nr Fields Data Types Primary Keys Foreign Keys Nr Relations Nr Indexes Row Size Data Points Function Points Nr Deficiencies
LA09TF01 91 19 7 4 0 1 0 93 31 7 9
LA09TFL1 2469 22 7 4 0 1 1 161 36 7 7
LA09TFP1 556 8 3 4 0 1 1 50 22 7 3
LA09TG51 1974 163 4 1 0 1 1 732 171 15 5
LA09TGF1 292 51 16 3 0 1 1 378 63 10 12
LA09TGI0 246 9 6 0 0 1 1 95 15 7 9
LA09TFA1 65 8 7 5 0 1 0 76 22 7 6
LE01T301 103 33 7 0 0 1 0 139 37 7 16
LE01T361 706 2 2 0 0 1 1 32 8 7 5
LE01T381 245 4 4 0 0 1 1 17 10 7 5
LE01TI01 422 8 5 1 0 1 1 28 16 7 7
LE01TI02 175 80 14 3 0 1 1 604 92 10 33
LE01TI03 137 7 4 4 0 1 1 25 21 7 5
LE01TI04 141 59 12 4 0 1 1 249 73 10 15
LE01TI11 223 47 8 3 0 1 1 145 59 7 22
LE01TI12 128 32 5 4 0 1 1 78 46 7 31
LE01TI13 125 42 7 4 0 1 1 106 56 7 38
LE01TK01 128 14 10 0 0 1 1 118 20 7 6
LE05TQ11 78 8 7 2 0 1 0 87 16 7 6
LE08TH01 75 5 5 1 0 1 0 21 11 7 6
LE10TV11 187 108 20 4 0 1 0 1024 120 15 41
LE10TV21 257 2 2 1 0 1 3 52 14 7 4
LE10TV25 224 2 2 1 0 1 1 52 10 7 3
LE10TV31 98 22 13 3 0 1 1 136 34 7 7
LE10TV41 184 11 8 1 0 1 1 47 19 7 4
LE10TV51 144 7 7 5 0 1 1 35 23 7 5
LE10TVB1 392 18 12 3 0 1 1 92 30 7 11
LE10TVC1 171 6 5 5 0 1 1 29 22 7 6
LE10TVD1 89 8 5 2 0 1 1 48 18 7 6
LE10TVE1 191 72 23 5 0 1 1 794 88 10 27
LE10TVF1 177 6 6 2 0 1 1 32 16 7 4
LE10TVG1 124 10 7 7 0 1 1 49 30 7 9
LE10TVH1 168 16 10 3 0 1 1 85 28 7 11
LE10TVI1 229 14 8 5 0 1 1 62 30 7 10
LE10TVJ1 224 11 7 6 0 1 1 46 29 7 9
LE10TVL1 179 6 6 2 0 1 1 35 16 7 6
LE10TVM1 103 22 10 5 0 1 1 102 38 7 12
LE10TVN1 190 38 18 8 0 1 1 402 60 7 19
LE10TVU1 308 26 15 7 0 1 1 293 46 7 11
LE10TVW1 261 47 15 0 0 1 1 306 53 7 11
LE10TVX1 246 97 10 0 0 1 1 437 103 10 50
LEARTE11 72 3 2 1 0 1 0 20 9 7 5
LEARTE12 53 6 4 2 0 1 1 108 16 7 4
LEARTE51 81 5 5 0 0 1 1 4271 11 7 9
LEARTE61 93 10 8 1 0 1 1 837 18 7 9
LEDMTD01 99 30 6 0 0 1 0 113 34 7 16
LEMFT401 75 6 5 1 0 1 0 70 12 7 6
LEMFT402 55 4 4 2 0 1 1 53 14 7 3
LEMFT403 78 3 3 1 0 1 1 38 11 7 2
LEOAT211 95 22 11 3 0 1 0 154 32 7 14
LEPATAP1 129 48 15 0 0 1 0 291 52 7 13
LESETSE1 298 229 11 1 0 1 0 356 235 15 6
LESETSZ1 301 6 5 0 0 1 1 53 12 7 5
LESHTVZ1 89 17 9 4 0 1 0 114 29 7 8
LESTTLW1 75 7 7 0 0 1 0 9314 11 7 7
LESTTSL1 87 11 7 0 0 1 1 72 17 7 11
LESTTST1 94 5 4 3 0 1 1 62 17 7 4
LESTTST2 54 2 2 0 0 1 1 14 8 7 4
LESTTDW0 101 9 8 0 0 1 1 3300 15 7 9
LETXT511 71 2 2 1 0 1 0 22 8 7 5
LEUDT9A1 81 9 7 4 0 1 0 61 21 7 6
LEUDT9G2 149 17 4 0 0 1 1 288 23 7 7
DATABASE QUANTITY METRICS
Total Number of SQL Source Files15
Total Number of SQL Code Lines27726
Total Number of SQL Comment Lines8672
Total Number of SQL Procedure Statements2
Total Number of SQL Statement Types0
Total Number of SQL Access Operations30
Total Number of SQL Select Operations14
Total Number of SQL Insert Operations1
Total Number of SQL Update Operations0
Total Number of SQL Delete Operations0
Total Number of SQL Stored Procedures0
Total Number of SQL Procedure Blocks0
Total Number of SQL Procedure Conditions0
Total Number of SQL Procedure Loops0
Total Number of SQL Procedural Branches0
Total Number of SQL Data Declarations0
Total Number of SQL Set Data Assignments0
Total Number of SQL Output Operations0
Total Number of SQL Input Operations0
Total Number of Stored Procedure Points30
Total Number of SQL Tables136
Total Number of Data Attributes2691
Total Number of different Data Types984
Total Number of primary Keys264
Total Number of Foreign Keys0
Total Number of DB-Indexes131
Total Number of Relationships163
Total Number of Database Views14
Total Number of Database View Attributes0
Total Length of all SQL Rows135690
Total Number of Data-Points4073
Total Number of Function-Points997
Total Number of Deficiencies1206
Total Number of required Test Cases3249
DATABASE COMPLEXITY METRICS
Data Complexity0.743
Access Complexity0.188
Relational Complexity0.289
Structural Complexity0.105
Viewing Complexity0.120
Storage Complexity0.158
Average Database Complexity0.267
DATABASE QUALITY METRICS
Data Independence0.760
Data Accessability0.693
Data Flexibility0.201
Data Testability0.800
Data Conformity0.964
Storage Efficiency0.158
Average Database Quality0.596