...
Set the separator to be a comma. Ideally, text is in quotes.
DEMOGRAPHICS =>
...
patient
The STUDY_ID field is the key, so edit the type to set to primary key. However, it is in hex format. The type should be changed to VARCHAR with length 32. The default type is BLOB, but this can't be used as a primary key (see why).
DIAGNOSES =>
...
diagnosis
Set the STUDY_ID field to not allow nulls, and to type VARCHAR length 32:
...