Anomalies


Things that might not be 'quite right' about your database and schema

Columns whose name and type imply a relationship to another table's primary key

Child Column Implied Parent Column
enrollment_appointment.[person_id] person.[person_id]

Tables without indexes

Tables that contain a single column

Table Column
email_type name
enrollment_status name
exam_language name
exam_level name

Tables with incrementing column names, potentially indicating denormalization

Table
Anomaly not detected

Columns whose default value is the word 'NULL' or 'null'

Table
Anomaly not detected