SQL Query.sql

CREATE TABLE AUTHENTICATION_SYSTEM(
	U_ID SERIAL PRIMARY KEY,
	A_NAME VARCHAR(30) NOT NULL,
	U_NAME VARCHAR(30),
	PASSWORD VARCHAR(20)
);

INSERT INTO AUTHENTICATION_SYSTEM (A_NAME, U_NAME, PASSWORD) 
VALUES ('STEIN','ST-1','12345'),
	   ('MERRY','ST-2','123456'),
       ('DAVID','ST-3','1234567'),
       ('ALLIS','ST-4','12345678'),
       ('ARAY','ST-5','123456789'),
       ('GAL GADOT','ST-6','123456780'),
       ('IMON AHMED','ST-7','1234567810');
       
       
CREATE TABLE ADMIN_PANEL(
	ID SERIAL PRIMARY KEY,
	U_ID INT NOT NULL,
	FIRST_NAME VARCHAR(30),
	LAST_NAME VARCHAR(30),
	FOREIGN KEY (U_ID) REFERENCES AUTHENTICATION_SYSTEM (U_ID)
);

INSERT INTO ADMIN_PANEL (U_ID,FIRST_NAME, LAST_NAME) 
VALUES (1,'STEIN','ORKAIN'),
	   (2,'MERRY','INN'),
       (3,'DAVID','ERKHAM'),
       (4,'ALLIS','SALVATION'),
       (5,'ARAY','ROITER'),
       (6,'GAL','GADOT'),
       (7,'IMON','AHMED');
       

CREATE TABLE USERS (
	USERS_ID SERIAL PRIMARY KEY,
	ID INT NOT NULL,
	USERS_NAME VARCHAR(30) NOT NULL,
	EMAIL VARCHAR(50) NOT NULL,
	USER_PASSWORD VARCHAR(30) NOT NULL,
	FOREIGN KEY (ID) REFERENCES ADMIN_PANEL (ID)
);

INSERT INTO USERS (ID,USERS_NAME, EMAIL,USER_PASSWORD) 
VALUES (1,'STEIN','junaed.uddin460@gmail.com','1234'),
	   (2,'MERRY','imon.boss460@gmail.com','12345'),
       (3,'DAVID','anika.uddin460@gmail.com','12346'),
       (4,'ALLIS','jahid.uddin460@gmail.com','12347'),
       (5,'ARAY','junaed.uddin460@gmail.com','12344'),
       (6,'GAL','junaina.uddin460@gmail.com','12342'),
       (7,'IMON','selena.uddin460@gmail.com','123469');
       
          
CREATE TABLE BOOKS (
	SI_NO SERIAL PRIMARY KEY,
	USERS_ID INT NOT NULL,
	ISBN VARCHAR(40),
	CATEGORY VARCHAR(30) NOT NULL,
	PRICE INTEGER,
	AUTHOR VARCHAR(20) NOT NULL,
	TITLE VARCHAR(30) NOT NULL,
	ISSUE_DATE DATE NOT NULL,
	RESERVATION_DATE DATE NOT NULL,
	RETURN_DATE DATE NOT NULL,
	FOREIGN KEY (USERS_ID) REFERENCES USERS (USERS_ID)
);

INSERT INTO BOOKS (USERS_ID,ISBN, CATEGORY,PRICE,AUTHOR,TITLE,ISSUE_DATE,RESERVATION_DATE,RETURN_DATE) 
VALUES  (1,'4212-2536-452139','STORY',1000,'HUMAYUN AHMED','MOYURAKKHI','2018-09-26','2018-08-15','2018-09-28'),
	    (2,'8912-2536-678139','SCIENCE FICTION',700,'M.MORIS','DEATHLY HALLOWS','2018-09-28','2018-09-28','2018