How do you know it's wrong?

'Cause I am a wizard! Seriously, though, have a look at this snippet.

   All_Cancer int DEFAULT '0' NOT NULL,
   Lung_Cancer int DEFAULT '0' NOT NULL,
   Breast_Cancer int DEFAULT '0' NOT NULL,
   Cervical_Cancer int DEFAULT '0' NOT NULL,
   Colorectal_Cancer int DEFAULT '0' NOT NULL,
   Skin_Cancer int DEFAULT '0' NOT NULL,
[download]

Doesn't it scream "repeating columns" to you?

And what happens when somebody has some cancer not in this list? To me, these columns should be VALUES, while the column names should be "disease_code" and "disease_name". Typical symptom that the table is not even in first Normal Form.

Besides Fire your database designer is hardly helpful.

That's called a "sarcastic comment". Next time, I'll post a sign. ;-P