Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i created library DataBase so insert values into this table * i want the query CREATE TABLE Book ( ISBN INT NOT NULL, B_Name VARCHAR
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) )
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started