SQL CODE # 2

Create Table Book(
Book_Id int not null,
Book_Name Varchar(20),
Author_Name Varchar(20),
Edition Varchar(20),
Publisher Varchar(20),
User_id Varchar(20),
Issue_date Varchar(20)
Primary Key(Book_id,User_id))

Alter table book
Add Return_date Varchar(20);
insert into Book values
(001,'Database','Ahsan Raza','2020','Abc','S0012','2016');
select * from Book;
select USER_ID from Book
where Book_Name='Operating System';

Create table user_id(
USER_Id Varchar(20) not null,
Name varchar(20),
Dept Varchar(20),
program Varchar(20)
Primary key(User_id)
Foreign key(User_id)references User_id(User_id));

insert into user_id values('s011','ali','c.s','mscs');

select * from user_id;


select book.Book_Id, user_id.USER_Id
from Book,user_id
where book.User_id=user_id.user_id;