hi i am trying to create 4 tables, each will have at least 4 field, table_4, table_5(one foreign key ref: table_4, table 6(composite primary key), table_7 will have 2 foreign key ref: table_5, table_6.

here is my queries. i have so far created first 3, but the fourth one is rejected saying RELATION MUST BE ON SAME NUMBER OF FIELDS AND SAME DATA TYPE, i really donno wht i am doing wrong....pls HELP!!!

heres my expressions....

CREATE TABLE Table_4
(
column_A INT,
column_B FLOAT,
column_C CHAR(10),
column_D STRING,
PRIMARY KEY (column_A)

);
CREATE TABLE Table_5
(
column_E STRING,
column_A INT,
column_G CHAR(5),
column_H INT,
PRIMARY KEY (column_E),
FOREIGN KEY (column_A) REFERENCES Table_4
);

CREATE TABLE Table_6
(
column_I STRING,
column_J CURRENCY,
column_K INT,
column_L DATE,
column_M CHAR(15),
PRIMARY KEY (column_I, column_L)
);


CREATE TABLE Table_7
(
column_N INT,
column_G CHAR(5),
column_M CHAR(15),
column_Q REAL,
PRIMARY KEY (column_N),
FOREIGN KEY(column_G) REFERENCES Table_5,
FOREIGN KEY (column_M) REFERENCES Table_6
)