i created my tables and I'm stuck at the last one,
here is the tables that been created correctly

```
CREATE TABLE Staff ( 
    Staff_ID INT NOT NULL PRIMARY KEY, 
    First_Name VARCHAR(50), 
    Last_Name VARCHAR(50), 
    Username VARCHAR(10), 
    Password VARCHAR(10), 
    Address VARCHAR(30) 
)

CREATE TABLE Category ( 
    Category_ID INT NOT NULL PRIMARY KEY, 
    Name VARCHAR(30) 
)

CREATE TABLE Author ( 
    Author_ID INT NOT NULL PRIMARY KEY, 
    First_Name VARCHAR(50), 
    Last_Name VARCHAR(50), 
    Birth_Place VARCHAR(30), 
    Birth_Date DATE
)

CREATE TABLE Publisher ( 
    Publisher_ID INT NOT NULL PRIMARY KEY, 
    Name VARCHAR(50) 
)

```

and this is the one I'm getting an error :

```
CREATE TABLE Book ( 
    Book_ID INT NOT NULL PRIMARY KEY, 
    Title VARCHAR(50), 
    Edition INT(30), 
    Year_Published INT(4), 
    FOREIGN KEY (Publisher_ID) REFERENCES Publisher(Publisher_ID), 
    FOREIGN KEY (Author_ID) REFERENCES Author(Author_ID), 
    FOREIGN KEY (Category_ID) REFERENCES Category(Category_ID) 
)

```

the error says:

> 
> "ORA-00907: missing right parenthesis"
> 
> 
>