CREATE TABLE Publisher (PublD NUMBER(2), Name VARCHAR2(23), Contact VARCHAR2(15), Phone VARCHAR2(12), CONSTRAINT publish

[answerhappygod]

Create Table Publisher Publd Number 2 Name Varchar2 23 Contact Varchar2 15 Phone Varchar2 12 Constraint Publish 1 (73.13 KiB) Viewed 27 times

CREATE TABLE Publisher (PublD NUMBER(2), Name VARCHAR2(23), Contact VARCHAR2(15), Phone VARCHAR2(12), CONSTRAINT publisher_pubid_pk PRIMARY KEY(pubid)); CREATE TABLE Books (ISBN VARCHAR2(10), Title VARCHAR2(30), PubDate DATE, PublD NUMBER (2), Cost NUMBER (5,2), Retail NUMBER (5,2), Discount NUMBER (4,2), Category VARCHAR2(12), CONSTRAINT books_isbn_pk PRIMARY KEY(isbn), CONSTRAINT books pubid_fk FOREIGN KEY (pubid) REFERENCES publisher (pubid));