ADBMS
CREATE USER Students IDENTIFIED BY ADBMSDEFAULT TABLESPACE USERSQUOTA UNLIMITED ON USERS; GRANT CREATE TABLE, CREATE VIEW, CREATE SEQUENCE TO Students;drop table book;create table author(a_id number(10)primary key, a_name varchar2(20));create table book(b_id number(10),b_name varchar2(20), isbn varchar2(20),edition varchar2(20), c_id number(10),a_id number(10), primary key(b_id,edition) );create table category(c_id number(10)primary key, c_name varchar2(20));alter table book add constraint fk_category foreign key (c_id) …