(Solved) : Database Used Paper Review Drop Table Paperreview Cascade Constraint Drop Table Paperautho Q30547030 . . . .

Database used:

— Paper Review

drop table paper_review cascade constraint;

drop table paper_author cascade constraint;

drop table paper cascade constraints;

drop table author cascade constraints;

drop table reviewer cascade constraints;

create table reviewer (

rid int, — reviewer id

rname varchar(50), — reviewer name

remail varchar(50),– reviewer email

raffiliation varchar(50),– reviewer affiliation

primary key (rid)

);

insert into reviewer values(1,’Alex Golden’,’golden@umbc.com’,’UMBC’);

insert into reviewer values(2,’Ann Stonebraker’,’ann@umd.edu’,’UMD’);

insert into reviewer values(3,’Karen Smith’,’karen@umb.com’,’UMB’);

insert into reviewer values(4,’Richard Wallas’,’richard@umbc.edu’,’UMBC’);

insert into reviewer values(5,’Ravi Krishnan’,’ravi@jhu.edu’,’JHU’);

create table author

(aid int, — author id

aname varchar(50), — author name

aemail varchar(50), — author email

aaffiliation varchar(50),– author affiliation

primary key(aid));

insert into author values(1,’Adam Smith’,’smith@umbc.edu’,’UMBC’);

insert into author values(2,’Nancy Chang’,’nanch@umd.edu’,’UMD’);

insert into author values(3,’Carrol Steinberg’,’carrol@umb.edu’,’UMB’);

insert into author values(4,’Daniel Kerry’,’daniel@jhu.edu’,’JHU’);

create table paper(

pid int,—