DROP TABLE AUTHORS cascade constraints;

DROP TABLE BOOK$\_$ITEMS cascade constraints;

DROP TABLE BOOKS cascade constraints;

DROP TABLE BORROWING cascade constraints;

DROP TABLE CUSTOMERS cascade constraints;

DROP TABLE WRITING cascade constraints;

CREATE TABLE AUTHORS

$($ AUTHOR$\_$ID NUMBER$(10,0),$

LAST$\_$NAME VARCHAR$2(30$ CHAR$),$

FIRST$\_$NAME VARCHAR$2(20$ CHAR$),$

BIRTH$\_$DATE DATE

$)$ ;

CREATE TABLE BOOK$\_$ITEMS

$($ BOOK$\_$ITEM$\_$ID VARCHAR$2(20$ CHAR$),$

BOOK$\_$ID NUMBER$(10,0),$

THEORETICAL$\_$VALUE NUMBER$(10,2)$

$)$ ;

CREATE TABLE BOOKS

$($ BOOK$\_$ID NUMBER$(10,0),$

TITLE VARCHAR$2(200$ CHAR$),$

ISBN VARCHAR$2(13$ CHAR$),$

PUBLISHER VARCHAR$2(200$ CHAR$),$

PUBLISHING$\_$DATE DATE,

PRICE NUMBER$(8,0),$

TOPIC VARCHAR$2(30$ CHAR$),$

NUMBER$\_$OF$\_$PAGES NUMBER$(4,0)$

$)$ ;

CREATE TABLE BORROWING

$($ CUSTOMER$\_$ID VARCHAR$2(20$ CHAR$),$

BOOK$\_$ITEM$\_$ID VARCHAR$2(20$ CHAR$),$

BORROWING$\_$DATE DATE,

BORROWING$\_$PERIOD$\_$IN$\_$DAYS NUMBER$(3,0)$ DEFAULT $30,$

BRING$\_$BACK$\_$DATE DATE,

LATE$\_$FEE NUMBER$(6,0)$

$)$ ;

CREATE TABLE CUSTOMERS

$($ LIBRARY$\_$CARD$\_$NUMBER VARCHAR$2(20$ CHAR$),$

LAST$\_$NAME VARCHAR$2(30$ CHAR$),$

FIRST$\_$NAME VARCHAR$2(20$ CHAR$),$

BIRTH$\_$DATE DATE,

GENDER CHAR$(1$ CHAR$),$

ADDRESS VARCHAR$2(200$ CHAR$),$

ENROLLMENT$\_$DATE DATE,

MEMBERSHIP$\_$FEE NUMBER$(5,0),$

CATEGORY VARCHAR$2(20$ CHAR$)$

$)$ ;

CREATE TABLE WRITING

$($ AUTHOR$\_$ID NUMBER$(10,0),$

BOOK$\_$ID NUMBER$(10,0),$

ROYALTY NUMBER

$)$ ;

Insert into AUTHORS $($AUTHOR$\_$ID$,$LAST$\_$NAME,FIRST$\_$NAME,BIRTH$\_$DATE$)$ values $(\text{'}2005182601\text{'},$'Christie','Agatha',to$\_$date$(\text{'}1890-09-15\text{'},\text{'}$YYYY$-$Mm$-$DD$\text{'}))$;

Insert into AUTHORS $($AUTHOR$\_$ID$,$LAST$\_$NAME,FIRST$\_$NAME,BIRTH$\_$DATE$)$ values $(\text{'}2005182602\text{'},$'Banner',$\text{'}$A$.$ J$.\text{'},$to$\_$date$(\text{'}1966-05-21\text{'},\text{'}$YYYY$-$Mm$-$DD$\text{'}))$;

Insert into AU