all the database queries:

create database CREATE DATABASE library;

create books table
CREATE TABLE books ( bid INT PRIMARY KEY, book_item VARCHAR(30) NOT NULL, a_name varchar(30),des VARCHAR(150) NOT NULL, price INT NOT NULL );

create user table
CREATE TABLE userRec (uid INT PRIMARY KEY auto_incremenet, name VARCHAR(30) NOT NULL, email VARCHAR(150) NOT NULL, pass VARCHAR(150) NOT NULL, contact INT NOT NULL);

insert data in the user table
INSERT INTO userRec VALUES(1,'Admin','[email protected]','12345',999909999); INSERT INTO userRec VALUES(2,'Uditi','[email protected]','qwerty',9726871261); INSERT INTO userRec VALUES(3,'Khushi','[email protected]','asdfg',9971183123);

create bill table
CREATE TABLE restaurant.bill( billid int primary key auto_increment, bill int, uid int, CONSTRAINT fk_product_1 foreign key (uid) references userRec(uid));