Create tables using SQL according to the given schema. You must create your database using exactly the same name for tables and attributes, using the given type.

Schema

Customer (cid, name, address);

Orders (oid, order_date, cid) foreign key (cid) references Customer(cid);

Order_book(oid, isbn, no_of_copy) foreign key (oid) references Orders(oid), foreign key(isbn) references Book (isbn);

Publisher (pid, name, address, phone);

Book (isbn, title, btype, price, pub_date, pid)

foreign key (pid) references Publisher (pid);

Author (aid, fname, lname);

Written_by(isbn, aid)

foreign key (isbn) references Book (isbn), foreign key (aid) references Author (aid);

Editor (eid, fname, lname);

Edited_by(eid, isbn)

foreign key (isbn) references Book (isbn), foreign key (eid) references Editor (eid);