i created library DataBase

so insert values into this table

* i want the query

CREATE TABLE Book ( ISBN INT NOT NULL, B_Name VARCHAR (50) NOT NULL, B_author VARCHAR(20) NOT NULL, B_publisher VARCHAR(25), B_State VARCHAR(20) NOT NULL, lno INT NOT NULL, PRIMARY KEY (ISBN), FOREIGN KEY(Ino) REFERENCES LibraryItems(1_number) ) Table created. CREATE TABLE AudioBook( A_number INT NOT NULL, A_name VARCHAR (50) NOT NULL, ReaderName VARCHAR (50) NOT NULL, A_publisher VARCHAR(25), ISBN INT NOT NULL, PRIMARY KEY (A_number), FOREIGN KEY (ISBN) REFERENCES Book(ISBN) )

Question

i created library DataBase

so insert values into this table

* i want the query

image text in transcribed

CREATE TABLE Book ( ISBN INT NOT NULL, B_Name VARCHAR (50) NOT NULL, B_author VARCHAR(20) NOT NULL, B_publisher VARCHAR(25), B_State VARCHAR(20) NOT NULL, lno INT NOT NULL, PRIMARY KEY (ISBN), FOREIGN KEY(Ino) REFERENCES LibraryItems(1_number) ) Table created. CREATE TABLE AudioBook( A_number INT NOT NULL, A_name VARCHAR (50) NOT NULL, ReaderName VARCHAR (50) NOT NULL, A_publisher VARCHAR(25), ISBN INT NOT NULL, PRIMARY KEY (A_number), FOREIGN KEY (ISBN) REFERENCES Book(ISBN) )

Accepted Answer

The Answer is in the image, click to view ...

Question

i created library DataBase so insert values into this table * i want the query CREATE TABLE Book ( ISBN INT NOT NULL, B_Name VARCHAR

Step by Step Solution

Step: 1

Get Instant Access with AI-Powered Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Students also viewed these Databases questions

Question

Question

Question

Question

Question

Question

Question

Question

Question