SQL

To help the mystery bookstore, create the table BOOKINFO with the attributes: ID, title, ISBN, publisher ID and copyright year. The ID will be the primary key and have four characters. The title and ISBN will have thirty and ten characters respectively. The publisher's ID will be a foreign key pointing to the ID of PUBINFO. The copyright year will be an integer. Select one: A. CREATE TBLE BOOKINEO ( ID CHAR (4) PRIMARY KEY, title, ISBN VARCHAR (30), PUBID CHAR(4), CYEARR NUPBER, FOREIGN KEY (PUbID) REFERENCES PUBINFO(ID) i; B. CREATE TABLE ROCKTNFO ( ID CHR(4) LRIMARY KEY, title VARCHAR (30), TSBN VARCHAR {10}, PUbID CHAR (4), CYEARR NUMBER, FORETGN KFY (PUbTD) i C CrEAte reference table BOOKINFO ID CHR(4) PRIMARY KEY, t.it.le VARCHAR (30), ISBN VARCHAR (10), pubID CHAR (4), CYERR NUPBER, FOREIGN KEY (PUBID) POINIING TO PUBINFO(LD) Ji D. CREAte table bOokinfo ( ID CHAR (4), title VARCHAR(30) PRIMARY KEY, ISBN VARCHAR (10), pubID CHAR (4), CYEAR NUMBER, FOREIGN KEY (pubID) REFERENCES PUBINFO(ID) ) E. CREATE table bOOKINFO ID CHAR (4) PRIMARY KEY, title VARCHAR (30), ISBN VARCHAR (10), pubID CHAR (4), CYEAR NUMBER, FOREIGN KEY (pubID) REFERENCES PUBINFO(ID) )