Create tables using SQL according to the given schema. You must your database using exactly the same
Question:
Create tables using SQL according to the given schema. You must 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);
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last