JavaDb creating table error

[Samanthi perera]

this is my first tsble

CREATE TABLE "DEPARTMENT" (
    "DEPT_ID" INTEGER not null primary key,
    "NAME" VARCHAR(30)
   
);

i have created this tasble on JavaDb

when i am going to creat the next table it gives error
this is the next table script

CREATE TABLE "Student" (
    "ID" INTEGER not null primary key,
    "NAME" VARCHAR(30),
    "DEPT_ID" INTEGER
FOREIGN KEY (DEPT_ID) REFERENCES DEPARTMENT(DEPT_ID)
);

here is the eror

Error code -1, SQL state 42X01: Syntax error: Encountered "FOREIGN" at line 5, column 1.
Line 1, column 1

Execution finished after 0 s, 1 error(s) occurred.

screenshot is here

http://4.bp.blogspot.com/_bpkZ2BsqXug/S21OLQkrVUI/AAAAAAAAAF0/i2rOxn4pHJA/s1600-h/db.gif

[Herman Schelti]

hi,

see http://www.w3schools.com/SQl/sql_foreignkey.asp

just add a "," after

DEPT_ID" INTEGER

1. CREATE TABLE "Student" (
2. "ID" INTEGER not null primary key,
3. "NAME" VARCHAR(30),
4. "DEPT_ID" INTEGER,
5. FOREIGN KEY (DEPT_ID) REFERENCES DEPARTMENT(DEPT_ID)
6. );

[Samanthi perera]

Now i have inserting data to table

http://1.bp.blogspot.com/_bpkZ2BsqXug/S217oetgpFI/AAAAAAAAAF8/bpl8RBPqwXw/s1600-h/db.bmp

http://2.bp.blogspot.com/_bpkZ2BsqXug/S219cnKYOiI/AAAAAAAAAGE/hKaAN_rq1LE/s1600-h/db2.GIF

what is this error?

[Herman Schelti]

Now i have inserting data to table

No, you are "nserting" ....