Question: I need help with my database. I keep receiving errors at line 11 in sqlplus and none of my tables are being created. ] create

I need help with my database. I keep receiving errors at line 11 in sqlplus and none of my tables are being created. ]
create table Books(
bookID number(10),
ISBN number(10),
title varchar(20),
Author CHAR(25),
publishyear number(4),
PRIMARY KEY (bookID),
);
create table Members(
memberID number(10),
lastname CHAR(20),
firstname CHAR(25),
address varchar(50),
phone_number number(20),
booklimit number(10),
PRIMARY KEY(memberID, lastname, firstname)
);
create table CurrentLoan(
memberID number,
bookID number,
loandate date,
duedate date,
PRIMARY KEY (memberID, bookID),
FOREIGN KEY (bookID)
);
create table History (
memberID number,
bookID number,
loandate date,
returndate date,
PRIMARY KEY (memberID, bookID, loandate),
FOREIGN KEY (bookID, memberID)
);
Book(bookID, ISBN, title, author, publish-year, category) Member(memberID, lastname, firstname, address, phone-number, limit) CurrentLoan(memberID, bookID, loan-date, due-date) History(memberlD, bookID, loan-date, return-date) Members can borrow books from the library. The number of books they can borrow is limited by the "limit" field of the Member relation (it may differ for different members). The category of a book includes fiction, non-fiction, children's and reference. The CurrentLoan table represents the information about books that Cli Rantly 4hecksxl out. When the Innk is reiunkxl to the library, the iocon1 will be rcliknrxl iitiin CurrentLoad relation, and will be inserted into History relation with the return-date. A library may have more than one copy of the same book, in which case each copy has its own bookID, but all copies share the same ISBN. remove rom
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
