数据库帮我创建个表结构

Question

图书表：BOOK (BOOK_ID NUMBER(10),SORT_ID VARCHAR2(10),BOOK_NAME VARCHAR2(50),WRITER VARCHAR2(10),OUTPUT VARCHAR2(50),PRICE NUMBER(3));读者表CREATE TABLE READER (READER_ID NUMBER(3),COMPANY VARCHAR2(10),NAME VARCHAR2(10),SEX VARCHAR2(2),GRADE VARCHAR2(10),ADDR VARCHAR2(50));创建BORROW:（借阅表）CREATE TABLE BORROW (READER_ID NUMBER(3),BOOK_ID NUMBER(10),BORROW_DATE DATE);     三张表  谢谢

Answer 1

图书表：
CREATE TABLE BOOK (
BOOK_ID NUMBER(10) PRIMARY KEY,
SORT_ID VARCHAR2(10),
BOOK_NAME VARCHAR2(50),
WRITER VARCHAR2(10),
OUTPUT VARCHAR2(50),
PRICE NUMBER(3));
读者表:
CREATE TABLE READER (
READER_ID NUMBER(3) PRIMARY KEY,
COMPANY VARCHAR2(10),
NAME VARCHAR2(10),SEX VARCHAR2(2),
GRADE VARCHAR2(10),
ADDR VARCHAR2(50));
借阅表:
CREATE TABLE BORROW (
READER_ID NUMBER(3) PRIMARY KEY,
BOOK_ID NUMBER(10) PRIMARY KEY,
BORROW_DATE DATE,
CONSTRAINT ID_FK1 FOREIGN KEY(BOOK_ID )REFERENCES BOOK(BOOK_ID )
CONSTRAINT ID_FK2 FOREIGN KEY(READER_ID )REFERENCES READER(READER_ID )
);