create table Books(
book_id integer,
title varchar,
author varchar,
publication_date date,
price decimal,
primary key(book_id)
);

create table Customers(
customer_id integer,
name varchar,
email varchar,
address varchar,
phone_number varchar,
primary key(customer_id)
);

create table Orders(
order_id integer,
customer_id integer,
book_id integer,
order_date date,
quantity integer,
primary key(order_id)
--foreign key(customer_id,order_date)
);

--inserting data into Books table

insert into Books(book_id,title,author,publication_date,price) values(10,'S','naveen','1980-04-27',400.00);
insert into Books(book_id,title,author,publication_date,price) values(20,'C','harsha','1989-01-01',270.00);
insert into Books(book_id,title,author,publication_date,price) values(30,'O','aravind','1982-06-17',500.00);
insert into Books(book_id,title,author,publication_date,price) values(40,'P','nivas','1972-11-04',300.00);
insert into Books(book_id,title,author,publication_date,price) values(50,'E','tarun','1967-10-27',250.00);

--inserting data into Customers table

insert into Customers(customer_id,name,email,address,phone_number) values(101,'arun','[email protected]','Delhi',1000000001);
insert into Customers(customer_id,name,email,address,phone_number) values(102,'rohan','[email protected]','Mumbai',2000000002);
insert into Customers(customer_id,name,email,address,phone_number) values(103,'harry','[email protected]','Kolkata',3000000003);
insert into Customers(customer_id,name,email,address,phone_number) values(104,'noah','[email protected]','Chennai',4000000004);
insert into Customers(customer_id,name,email,address,phone_number) values(105,'nate','[email protected]','Banglore',5000000005);

--inserting data into Orders

insert into Orders(order_id,customer_id,book_id,order_date,quantity) values(1,101,10,'2000-06-27',2);
insert into Orders(order_id,customer_id,book_id,order_date,quantity) values(2,102,30,'2002-04-27',3);
insert into Orders(order_id,customer_id,book_id,order_date,quantity) values(3,103,40,'2000-03-02',4);
insert into Orders(order_id,customer_id,book_id,order_date,quantity) values(4,104,20,'1990-07-17',5);
insert into Orders(order_id,customer_id,book_id,order_date,quantity) values(5,105,50,'2001-05-30',6);