Question: i created library DataBase so insert values into this table * i want the query CREATE TABLE Thesis ( T_number INT NOT NULL, T_Author VARCHAR
i created library DataBase
so insert values into this table
* i want the query

CREATE TABLE Thesis ( T_number INT NOT NULL, T_Author VARCHAR (20) NOT NULL, T_Publisher VARCHAR (25) NOT NULL, T_Loc VARCHAR (20) NOT NULL, T_Title VARCHAR(30) NOT NULL, T_desc VARCHAR(50) NOT NULL, lno INT NOT NULL, PRIMARY KEY (T_number), FOREIGN KEY (lno) REFERENCES LibraryItems(1_number) ) Table created. CREATE TABLE Indistinguishable ( Item_num INT NOT NULL, Iname VARCHAR (50) NOT NULL, I_Loc VARCHAR(20) NOT NULL, IState VARCHAR(20), lno INT NOT NULL, PRIMARY KEY (Item_num), FOREIGN KEY (lno) REFERENCES LibraryItems(1_number) )
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
