Page 1 of 1
CREATE TABLE Publisher (PublD NUMBER(2), Name VARCHAR2(23), Contact VARCHAR2(15), Phone VARCHAR2(12), CONSTRAINT publish
Posted: Mon May 09, 2022 6:59 am
by answerhappygod
- Create Table Publisher Publd Number 2 Name Varchar2 23 Contact Varchar2 15 Phone Varchar2 12 Constraint Publish 1 (73.13 KiB) Viewed 29 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));