Scribd
Upload
23 views1 page

Project 1

Uploaded by

yoniman1352
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
23 views1 page

Project 1

Uploaded by

yoniman1352
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

sql CREATE TABLE BOOK ( Book_id INT PRIMARY KEY, Title VARCHAR(100) NOT NULL,

Publisher_Name VARCHAR(100), Pub_Year INT ); CREATE TABLE BOOK_AUTHORS


( Book_id INT, Author_Name VARCHAR(100), FOREIGN KEY (Book_id) REFERENCES
BOOK(Book_id) ); CREATE TABLE PUBLISHER ( Name VARCHAR(100) PRIMARY KEY,
Address VARCHAR(200), Phone VARCHAR(20) ); CREATE TABLE BOOK_COPIES ( Book_id
INT, Branch_id INT, No_of_Copies INT, PRIMARY KEY (Book_id, Branch_id),
FOREIGN KEY (Book_id) REFERENCES BOOK(Book_id), FOREIGN KEY (Branch_id)
REFERENCES LIBRARY_BRANCH(Branch_id) ); CREATE TABLE BOOK_LENDING ( Book_id
INT, Branch_id INT, Card_No INT, Date_Out DATE, Due_Date DATE, PRIMARY KEY
(Book_id, Branch_id, Card_No), FOREIGN KEY (Book_id) REFERENCES
BOOK(Book_id), FOREIGN KEY (Branch_id) REFERENCES
LIBRARY_BRANCH(Branch_id) ); CREATE TABLE LIBRARY_BRANCH ( Branch_id INT
PRIMARY KEY, Branch_Name VARCHAR(100) NOT NULL, Address VARCHAR(200) );

You might also like