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
adm_appl.[appl_application_date] uw_date.[date]
adm_appl.[appl_graduation_date] uw_date.[date]
adm_appl_program_evaluation.[evaluation_date] uw_date.[date]
adm_appl_program_history.[action_date] uw_date.[date]
adm_std_academic_attendance.[end_date] uw_date.[date]
adm_std_academic_attendance.[start_date] uw_date.[date]
adm_std_academic_course.[begin_date] uw_date.[date]
adm_std_academic_course.[end_date] uw_date.[date]
adm_std_academic_degree.[degree_date] uw_date.[date]
adm_std_employment.[end_date] uw_date.[date]
off_course.[course_id] cal_course.[course_id]
off_course_section_reserve.[reserve_start_date] uw_date.[date]
std_degree.[degree_conferral_date] uw_date.[date]
std_degree_honour.[honours_award_date] uw_date.[date]
std_program_history.[action_date] uw_date.[date]
std_service_indicator.[active_date] uw_date.[date]
std_term.[standing_action_date] uw_date.[date]
std_term.[withdraw_date] uw_date.[date]
std_term_course.[grade_submission_date] uw_date.[date]
std_term_plan_gpa.[gpa_date] uw_date.[date]
std_term_section.[add_date] uw_date.[date]
std_term_section.[drop_date] uw_date.[date]
std_term_subplan_gpa.[gpa_date] uw_date.[date]
uw_room.[location_code] uw_location.[location_code]

Tables without indexes

Table Rows
Anomaly not detected

Tables that contain a single column

Table Column
Anomaly not detected

Tables with incrementing column names, potentially indicating denormalization

Table
adm_appl_referee
std_address

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

Table
Anomaly not detected