code.txt

(creating a database named library)
CREATE DATABASE LIBRARY;

(chosing your database)
USE LIBRARY;

(creating a table named ALL_STUDENTS)
CREATE TABLE ALL_STUDENTS 
(Ad_No INT(5) PRIMARY KEY, 
Name VARCHAR(30) NOT NULL, 
Class VARCHAR(3) NOT NULL, 
Stream VARCHAR(10) NOT NULL, 
Section VARCHAR(2) NOT NULL, 
Phone_no VARCHAR(15),
Status VARCHAR(10), 
Book_Issued VARCHAR(5), 
No_of_Books INT);

(creating a table named DISABED_STUDENTS)
CREATE TABLE DISABED_STUDENTS 
(Ad_No INT(5) PRIMARY KEY, 
Name VARCHAR(30) NOT NULL, 
Class VARCHAR(3) NOT NULL, 
Stream VARCHAR(10) NOT NULL, 
Section VARCHAR(2) NOT NULL, 
Phone_no VARCHAR(15),
Status VARCHAR(10), 
Book_Issued VARCHAR(5), 
No_of_Books INT(11));



(creating a table named ALL_BOOKS)
CREATE TABLE ALL_BOOKS
(Code_No INT(5) PRIMARY KEY, 
Title VARCHAR(60) NOT NULL, 
Subject VARCHAR(50) NOT NULL, 
Author VARCHAR(50) , 
Edition VARCHAR(4) , 
Status VARCHAR(10) NOT NULL,
MRP INT(5) NOT NULL);

(creating a table named ISSUE_BOOKS)
CREATE TABLE ISSUE_BOOKS
(Code_No INT(5) PRIMARY KEY, 
Title VARCHAR(60) NOT NULL, 
Subject VARCHAR(50) NOT NULL, 
Author VARCHAR(50) , 
Edition VARCHAR(4) , 
Status VARCHAR(10) NOT NULL,
MRP INT(5) NOT NULL,
AD_NO INT(5));



(creating a table named DELETED_BOOKS)
CREATE TABLE DELETED_BOOKS
(Code_No INT(5) PRIMARY KEY, 
Title VARCHAR(60) NOT NULL, 
Subject VARCHAR(50) NOT NULL, 
Author VARCHAR(50) , 
Edition VARCHAR(4) , 
MRP INT(5) NOT NULL,
DeletedDate DATE,
Reason varchar(40));

(creating a table named SUBMIT_BOOKS)
CREATE TABLE SUBMIT_BOOKS
(Code_No INT(5) PRIMARY KEY, 
Title VARCHAR(60) NOT NULL, 
Subject VARCHAR(50) NOT NULL, 
Author VARCHAR(50) , 
Edition VARCHAR(4) , 
MRP INT(5) NOT NULL,
DateofIssue DATE,
DateofSubmission DATE,
Fine int(10));

(inserting values in all_students table)
INSERT INTO ALL_STUDENTS (Ad_No,Name, Class,Stream,Section,Phone_no,Status,No_of_Books)
VALUES (1001,”ROSHAN SHARMA”,”XI”,”SCIENCE”,”A1”,”9857521510”,”ENABLED”,0),
(1003, ”RAMESH MISHRA”,”XI”,”SCIENCE”,”A1”,”9812348130”,”ENABLED”,0),
(1005,”AARAV PATEL”,”XI”,”SCIENCE”,”A1”,”9860510555”,”ENABLED”,0),
(1007,”BISHAL PANDIT”,”XI”,”SCIENCE”,”A1”,”9855205204”,”ENABLED”,0),
(1009,”ARUSHI JOSHI”,”XI”,”SCIENCE”,”A1”,”9815008521”,”ENABLED”,0),
(1011,”SAYASHA SHARMA”,”XI”,”SCIENCE”,”A1”,”9829348112”,”ENABLED”,0),
(1013,”ARNAV TIWARI”,”XI”,”SCIENCE”,”A1”,”9825058105”,”ENABLED”,0),
(1015,”DIVA KUMARI”,”XI”,”SCIENCE”,”A1”,”9814530081”,”ENABLED”,0),
(1017,”DIPESH CHAUDHARY”,”XI”,”SCIENCE”,”A1”,”9814114600”,”ENABLED”,0),
(1019,”SIMRIKA AGRAWAL”,”XI”,”SCIENCE”,”A1”,”9842088754”,”ENABLED”,0),
(1021,”ERIKA JOSHI”,”XI”,”SCIENCE”,”A1”,”9817520051”,”ENABLED”,0),
(1023,”BHAIRAV SINGH”,”XI”,”SCIENCE”,”A1”,”9865582200”,”ENABLED”,0),
(1025,”MANISH BISTA”,”XI”,”SCIENCE”,”A1”,”9855240080”,”ENABLED”,0),
(1027,”TARUN KUMAR “,”XI”,”SCIENCE”,”A1”,”9814655871”,”ENABLED”,0),
(1029,”SHRISTI THAKUR”,”XI”,”SCIENCE”,”A1”,”9824789243”,”ENABLED”,0),
(1002,”SOURAYA PANDIT”,”XI”,”SCIENCE”,”A2”,”9824478100”,”ENABLED”,0),
(1004, ”ADITI SHARMA”,”XI”,”SCIENCE”,”A2”,”9852349720”,” ENABLED”,0),
(1006,”AVINAV KUMAR”,”XI”,”SCIENCE”,”A2”,”9844200530”,”ENABLED”,0),
(1008,”ADARSH VERMA”,”XI”,”SCIENCE”,”A2”,”9815056195”,”ENABLED”,0),
(1010,”AJAY SINGH”,”XI”,”SCIENCE”,”A2”,”9843084311”,”ENABLED”,0),
(1012,”AISHA JHA”,”XI”,”SCIENCE”,”A2”,”9860445451”,”ENABLED”,0),
(1014,”RITI PATEL”,”XI”,”SCIENCE”,”A2”,”9869205510”,”ENABLED”,0),
(1016,”PARAS SHAH”,”XI”,”SCIENCE”,”A2”,”9817304511”,”ENABLED”,0),
(1018,”DIPIKA JAIN”,”XI”,”SCIENCE”,”A2”,”9855056155”,”ENABLED”,0),
(1020,”MANI AGRAWAL”,”XI”,”SCIENCE”,”A2”,”9846684600”,”ENABLED”,0),
(1022,”MALINA SHAH”,”XI”,”SCIENCE”,”A2”,”9825524501”,”ENABLED”,0),
(1024,”JEENA ROY”,”XI”,”SCIENCE”,”A2”,”9844762006”,”ENABLED”,0),
(1026,”MANISHA JAIN”,”XI”,”SCIENCE”,”A2”,”9818421002”,”ENABLED”,0),
(1028,”RAMESH KUMAR “,”XI”,”SCIENCE”,”A2”,”9814578451”,”ENABLED”,0),
(1030,”SARANSH CHAUDHARY”,”XI”,”SCIENCE”,”A2”,”9824789243”,”ENABLED”,0),
(1051,”JATIN KUMAR”,”XI”,”COMMERCE”,”C”,”9816587180”,”ENABLED”,0),
(1052, ”AYASHA MISHRA”,” XI”,”COMMERCE”,”C”,”9867101225”,” ENABLED”,0),
(1053,”TANISHQ PATEL”,”XI”,”COMMERCE”,”C”,”9841105604”,”ENABLED”,0),
(1054,”MADAN VERMA”,”XI”,”COMMERCE”,”C”,”9822056615”,”ENABLED”,0),
(1055,”SHWETA SINGH”,”XI”,”COMMERCE”,”C”,”9855205631”,”ENABLED”,0),
(1056,”KANISH SHAH”,”XI”,”COMMERCE”,”C”,”98110135004”,”ENABLED”,0),
(1057,”RITESH AGARWAL”,”XI”,”COMMERCE”,”C”,”9866332841”,”ENABLED”,0),
(1058,”RIMA AGARWAL”,”XI”,”COMMERCE”,”C”,”9821005154”,”ENABLED”,0),
(1059,”DIVA SHARMA”,”XI”,”COMMERCE”,”C”,”98442112564”,”ENABLED”,0),
(1060,”SHINA PANDIT”,”XI”,”COMMERCE”,”C”,”9846684600”,”ENABLED”,0),
(1101,”NISHAN SHUKLA”,”XII”,”SCIENCE”,”A1”,”9825774055”,”ENABLED”,0),
(1103, ”SUSHANT ROY”,”XII”,”SCIENCE”,”A1”,”9844230265”,” ENABLED”,0),
(1105,”RIYA JAIN”,”XII”,”SCIENCE”,”A1”,”9852588126”,”ENABLED”,0),
(1107,”BISHESH JOSHI”,”XII”,”SCIENCE”,”A1”,”9814792221”,”ENABLED”,0),
(1109,”INDIRA AGARWAL”,”XII”,”SCIENCE”,”A1”,”9813781102”,”ENABLED”,0),
(1111,”ROMAN SHARMA”,”XII”,”SCIENCE”,”A1”,”9841056547”,”ENABLED”,0),
(1113,”DIWASH TIWARI”,”XII”,”SCIENCE”,”A1”,”9811468810”,”ENABLED”,0),
(1115,”GEETA CHAUDHARY”,”XII”,”SCIENCE”,”A1”,”9822541051”,”ENABLED”,0),
(1117,”DIPTI CHAUHAN”,”XII”,”SCIENCE”,”A1”,”9812245664”,”ENABLED”,0),
(1119,”SIMRAN SHAH”,”XII”,”SCIENCE”,”A1”,”9812358742”,”ENABLED”,0),
(1121,”JENNY DAS”,”XII”,”SCIENCE”,”A1”,”9821482335”,”ENABLED”,0),
(1123,”MEENA DAS”,”XII”,”SCIENCE”,”A1”,”9862246610”,”ENABLED”,0),
(1125,”PRAJWAL SINGH”,”XII”,”SCIENCE”,”A1”,”9852208841”,”ENABLED”,0),
(1127,”SANTOSH THAKUR “,”XII”,”SCIENCE”,”A1”,”9814365881”,”ENABLED”,0),
(1129,”JEENA ROY”,”XII”,”SCIENCE”,”A1”,”9844882043”,”ENABLED”,0),
(1102,”KRITIKA SHAH”,”XII”,”SCIENCE”,”A2”,”9815578505”,”ENABLED”,0),
(1104, ”PURNIKA JAIN”,”XII”,” SCIENCE”,”A2”,”9841128468”,” ENABLED”,0),
(1106,”ABHIMANYU CHAUHAN”,”XII”,”SCIENCE”,”A2”,”9824862450”,”ENABLED”,0),
(1108,”DINESH BISTA”,”XII”,”SCIENCE”,”A2”,”9841005601”,”ENABLED”,0),
(1110,”ANUGYA AGRAWAL”,”XII”,”SCIENCE”,”A2”,”9845515411”,”ENABLED”,0),
(1112,”YASH JHA”,”XII”,”SCIENCE”,”A2”,”9855710322”,”ENABLED”,0),
(1114,”PRANAV PATEL”,”XII”,”SCIENCE”,”A2”,”9822405510”,”ENABLED”,0),
(1116,”PRATIK SHAH”,”XII”,”SCIENCE”,”A2”,”9844131211”,”ENABLED”,0),
(1118,”TINA MISHRA”,”XII”,”SCIENCE”,”A2”,”9824895155”,”ENABLED”,0),
(1120,”MOTI SHARMA”,”XII”,”SCIENCE”,”A2”,”9860574600”,”ENABLED”,0),
(1122,”BINIV ROY”,”XII”,”SCIENCE”,”A2”,”9855145601”,”ENABLED”,0),
(1124,”JAYA KUMARI”,”XII”,”SCIENCE”,”A2”,”9824588006”,”ENABLED”,0),
(1126,”TRILOK ACHARYA”,”XII”,”SCIENCE”,”A2”,”9844511002”,”ENABLED”,0),
(1128,”MOHIT ACHARYA “,”XII”,”SCIENCE”,”A2”,”9860256451”,”ENABLED”,0),
(1130,”NEEWA CHAUDHARY”,”XII”,”SCIENCE”,”A2”,”981781243”,”ENABLED”,0),
(1151,”NAINA AGARWAL",”XII”,”COMMERCE”,”C”,”9822254101”,”ENABLED”,0),
(1152, ”SAMIR MAHESHWARI”,”XII”,”COMMERCE”,”C”,”9863550785”,” ENABLED”,0),
(1153,”DIYA KUMARI”,”XII”,”COMMERCE”,”C”,”9841210514”,”ENABLED”,0),
(1154,”KUNDAN VERMA”,”XII”,”COMMERCE”,”C”,”9814577615”,”ENABLED”,0),
(1155,”ASMITA SHAH”,”XII”,”COMMERCE”,”C”,”9841788231”,”ENABLED”,0),
(1156,”KABIRAJ GARG”,”XII”,”COMMERCE”,”C”,”9821485004”,”ENABLED”,0),
(1157,”ROJAN JHA”,”XII”,”COMMERCE”,”C”,”9860923301”,”ENABLED”,0),
(1158,”FATIMA QURESHI”,”XII”,”COMMERCE”,”C”,”9841905634”,”ENABLED”,0),
(1159,”JAYESH AGARWAL”,”XII”,”COMMERCE”,”C”,”9845595564”,”ENABLED”,0),
(1160,”SURAJ BANSAL”,”XII”,”COMMERCE”,”C”,”9811564001”,”ENABLED”,0);

(inserting data to table all_books)
INSERT INTO ALL_BOOKS (Code_No,Title,Subject,Author,Edition,Status,MRP)
VALUES (101,”GENERAL PHYSICS”,”PHYSICS”,”IRODOV”,”2015”,”AVAILIABLE”,2500),
(102,”SL ARORA”,”PHYSICS”,”ARORA G ”,”2019”,”AVAILABLE”,1455),
(103,”Comprehensive Part 1,2”,”chemistry”,”NULL”,”2019”,”AVAILABLE”,1505),
(104,”organic chemistry”,”chemistry ”,”N Awasti ”,”2014”,”AVAILABLE”,1655),
(105,”computer science ”,”C.S”,”PREETI ARORA”,”2018”,”AVAILABLE”,855),
(106,”RD SHARMA”,”mathematics”,”sharma G”,”2018”,”AVAILABLE”,1455),
(107,”LOVE OF PHYSICS”,”mathematics”,”WALTER LEWIN”,”2014”,”AVAILABLE”,4000),
(108,”modern ABC”,”CHEMISTRY”,”NULL”,”2018”,”AVAILABLE”,1555),
(109,”PROBLEMS IN PHYSICS”,”PHYSICS”,”A .A PINSKY”,”2017”,”AVAILABLE”,1655),
(110,”NEW PATTERN IIT JEE”,”MATHEMATICS”,”S.K GOYAL”,”2018”,”AVAILABLE”,1255),
(111,”INTEGRAL CALCULUS FOR IIT JEE”,”MATHEMATICS”,”A.K”,”2018”,”AVAILABLE”,1355),
(112,”NUMERICAL CHEMISTRY”,”CHEMISTRY”,”P BAHADUR”,”2018”,”AVAILABLE”,1855),
(113,”INORGANIC CHEMISTRY”,”CHEMISTRY”,”J.D LEE”,”2018”,”AVAILABLE”,2055),
(114,”PHYSICAL CHEMISTRY”,”CHEMISTRY”,”OP TANDON”,”2018”,”AVAILABLE”,1555),
(115,”FUNDAMENTAL PHYSICS”,”PHYSICS”,”RESNICK HALIDAY ”,”2018”,”AVAILABLE”,2555),
(116,”IIT JEE MATHEMATICS”,”MATHEMATICS”,”ML KHANNA ”,”2018”,”AVAILABLE”,2455),
(117,”NCERT VISTAS”,”ENGLISH”,”NULL”,”2018”,”AVAILABLE”,455),
(118,”NCERT FLAMINGO”,”ENGLISH”,”NULL”,”2018”,”AVAILABLE”,155),
(119,”NCERT CHEMISTRY PART 1 AND 2 ”,”CHEMISTRY”,”NULL”,”2018”,”AVAILABLE”,355),
(120,”NCERT PHYSICS”,”PHYSICS”,”NULL”,”2018”,”AVAILABLE”,455),
(121,”NCERT PE”,”P.E”,”NULL”,”2018”,”AVAILABLE”,655),
(122,”COMPREHENSIVE”,”ENGLISH ”,”NULL”,”2018”,”AVAILABLE”,1455),
(123,”BASICS OF MATHEMATICS”,”MATHEMATICS”,”RAGARWAL”,”2018”,”AVAILABLE”,655),
(124,”BASICS OF CHEMISTRY”,”CHEMISTRY”,”YASH .K ”,”2018”,”AVAILABLE”,3055),
(125,”ALL IN ONE VECTOR”,”PHYSICS”,”NULL”,”2018”,”AVAILABLE”,1455),
(126,”ARIHANT”,”MATHEMATICS”,”NULL”,”2018”,”AVAILABLE”,455),
(127,”ALL IN ONE MECHANICS”,”PHYSICS”,”AK RANDAN ”,”2018”,”AVAILABLE”,1455),
(128,”ALL IN ONE ORGANIC”,”CHEMISTRY”,”PANKAJ S”,”2018”,”AVAILABLE”,1455),
(129,”COMPLETE CS”,”CS”,”NULL”,”2018”,”AVAILABLE”,2655),
(130,”BASICS OF JAVA”,”CS”,”NULL”,”2018”,”AVAILABLE”,1455),
(131,”BASICS OF C++”,”CS”,”NULL”,”2018”,”AVAILABLE”,1555),
(132,”BASICS PYTHON”,”CS”,”NULL”,”2018”,”AVAILABLE”,1555),
(133,”UNDERSTANDING OF PHYSICS”,”PHYSICS”,”VIVEK .A”,”2018”,”AVAILABLE”,2555), (134,”OBJECTIVE PCM ”,”PCB”,”MAYA RAI”,”2018”,”AVAILABLE”,3055),
(135,”OBJECTIVE PCM”,”PCM”,”SAMIKSHYA RAI”,”2018”,”AVAILABLE”,1455),
(136,”ENTRANCE PATTERN”,”PHYSICS”,”RAJ L”,”2018”,”AVAILABLE”,1255),
(137,”SAT”,”PHYSICS”,”NULL”,”2018”,”AVAILABLE”,455),
(138,”BALAJI PCB”,”PCB”,”NULL”,”2018”,”AVAILABLE”,1455),
(139,”BALAJI PCM”,”PCB”,”NULL”,”2018”,”AVAILABLE”,15455),
(140,”PRADEEPS PCB”,”PCB”,”PRADEEP PANDEY”,”2018”,”AVAILABLE”,2555),
(141,”DOUBLE ENTRY BOOK KEEPING”,”ACCOUNTANCY”,”T.S. GREWALS”,”2014”,”AVAILABLE”,1400),
(142,”STATISTICS”,”ECONOIMICS”,”NCERT”,”2016”,”AVAILABLE”,1599),
(143,”ACCOUNTANCY CLASS-XI”,”ACCOUNTANCY”,”D.K. GOEL”,”2011”,”AVAILABLE”,1699),
(144,”PRADEEEP’S NEW COURSE CHEMISTRY XII(VOL 1 & 2”,”CHEMISTRY”,”S.C. KHETERPAL,S.N. DHAWAN,P.N.KAPIL”,”2012”,”AVAILABLE”,1999),
(145,”MODEM’S ABS OF CHEMISTRY CLASS -12(PART 1 & 2)”,”CHEMISTRY”,”S.P. JAUHAR”,”2015”,”AVAILABLE”,2199),
(146,”ACCOUNTANCY PART 1,2”,”ACCOUNTANCY”,”NCERT”,”2009”,”AVAILABLE”,1599),
(147,”ABS’s ACCOUNTANCY FINANCIAL ACCOUNTING INCLUDING GST”,”ACCOUNTANCY”,”DR.S.C. SHARMA”,”2010”,”AVAILABLE” ,1999),
(148,”BUSINESS STUDIES”,”BUSINESS STUDIES/ORGANISATION OF COMMERCE”,”POONAM GANDHI”,”2008”,”AVAILABLE”,2225),
(149,”BUSINESS STUDIES FOR CLASS XI”,”BUSINESS STUDIES/ORGANISATION OF COMMERCE”,”SANDEEP GARG”,”2007”,”AVAILABLE”,1699),
(150,”INTRODUCTORY MICROECONOMICS”,”ECONOMICS”,”T.R. JAIN AND V.K. OKHRI”,”2010”,”AVAILABLE”,1899),
(151,”MODEM APPRAOCH TO CHEMICAL CALCULATIONS”,”CHEMISTRY”,”R.C. MUKJERJEE”,”2015”,”AVAILABLE”,1899),
(152,”SC CHEMISTRY CLASS 12”,”CHEMISTRY”,”PURNIMA SHARMA”,”2009”,”AVAILABLE”,1599),
(153,”BUSINESS STUDIES FOR CLASS 12 PAPERBACK”,”BUSINESS STUDIES”,”SUBHASH DEY”,”2011”,”AVAILABLE”,592),
(154,”CASE STUDIES MENTOR IN BUSINESS STUDIES CLASS 12”,”BUSINESS STUDIES”,”ALKA DHAWAN”,”2011”,”AVAILABLE”,360),
(155,”ABD’s BULL’s EYE BUSINESS STUDIES CASE STUDIES CLASS 12”,”BUSINESS STUDIES”,”NEERU Sethi”,”2013”,”AVAILABLE”,501),
(156,”HEALTH AND PHYSICAL EDUCATION”,”PHYSICAL EDUCATION”,”DR. V.K. SHARMA”,”2014”,”AVAILABLE”,1099),
(157,”NCERT EXEMPLAR”,”MATHEMATICS”,”ANKESH KUMAR SINGH”,”2015”,”AVAILABLE”,1599),
(158,”COMPREHENSIVE MATHEMATICS(VOL.I & II)”,”MATHEMATICS”,”PARMANAND GUPTA”,”2010”,”AVAILABLE”,1200),
(159,”INFORMATION PRACTICES WITH PYTHON CLASS-12”,”INFORMATION PRACTICES”,”SUMITA ARORA”,”2015”,”AVAILABLE”,1099),
(160,”TOGETHER WITH INFORMATICS PRACTISES WITH SOLUTION(XII)”,”INFORMATION PRACTICES”,”SWATI RANA & HARSHIT GARG”,”2011”,”AVAILABLE”,1399),
(161,”GOLDEN FOR CHEMISRY”,”CHEMISTRY”,”DHANPAT ROY”,”2015”,”AVAILABLE”,1599),(162,”ASCHAND”,”PHYSICS”,”NULL”,”2014”,”AVAILABLE”,1600),
(163,”ASCHAND”,”CHEMISTRY”,”NULL”,”2014”,”AVAILABLE”,1500),
(164,”ASCHAND”,”MAHTHEMATICS”,”NULL”,”2013”,”AVAILABLE”,1700),
(165,”ASCHAND”,”BIOLOGY”,”NULL”,”2015”,”AVAILABLE”,1550),
(166,”BASICS OF PLANT ORGANISM”,”BIOLOGY”,”ASMITA KHADKA”,”2009”,”AVAILABLE”,1999),
(167,”BOTANY PART 1 & 2”,”BIOLOGY”,”NULL”,”2015”,”AVAILABLE”,2500),
(168,”ZOOLOGY PART 1 & 2”,”BIOLOGY”,”NULL”,”2011”,”AVAILABLE”,2600),
(169,”COMPACT STELLAR X-RAY SOURCES”,”PHYSICS”,”WALTER LEVIN”,”2006”,”AVAILABLE”,5600),
(170,”X- RAY BINARIES”,”PHYSICS AND ASTRONOMY”,”WALTER LEVIN”,”1995”,”AVAILABLE”,8999),
(171,”Illustrated” ,”PHYSICS”,”Stephen Hawking’s”,”1988”,”AVAILABLE”,2000),
(172,”Principleof quantum Mechanic”, ”physics”, “R. Shankar”, “2011”, “AVAILABLE”, 1500),
(173,”Basic physics”, ”physics”, “Karl F. Kuhn”, “2019”, “AVAILABLE”, 1000),
(174,”Fundamental of physics Entended”, ”physics”, “Jearl Walker”, “2015”, “AVAILABLE”, 1700),
(175,”The Feynman Lectures on physics”, ”physics”, “Richard Feynman”, “2011”, “AVAILABLE”, 1000),
(176,”The Elegant Universe”, ”physics”, “Brian Greene”, “2012”, “AVAILABLE”, 1500),
(177,”The Fabric of The Cosmos”, ”physics”, “Brian Greene”, “1998”, “AVAILABLE”, 2500),
(178,”Quantum Physics”, ”physics”, “Brian Greene”, “1989”, “AVAILABLE”, 1200),
(179,”Morden Classical Physics”, ”physics”, “KIP S. THORNE”, “1999”, “AVAILABLE”, 1600), (180,”Conceptual physics”, ”physics”, “Paul G. Hewitt”, “2012”, “AVAILABLE”, 1000),
(181,”Wuthering Height”, ”English”, “Emily Bronte”, “2016”, “AVAILABLE”, 600),
(182,”1984”, ”English”, “George Orwell”, “2015”, “AVAILABLE”, 900),
(183,”Harry Potter”, ”English”, “J. K Rowling”, “1990”, “AVAILABLE”, 1200),
(184,”Hart Of Darkness”, ”English”, “joseph Conrad”, “1986”, “AVAILABLE”, 890),
(185,”A Passage to India”, ”English”, “E.M Forest”, “1987”, “AVAILABLE”, 990),
(186,”To The Light House”, ”English”, “Virginia Woolf”, “1989”, “AVAILABLE”, 1000),
(187,”Invisible Man”, ”English”, “Ralph Ellison”, “1999”, “AVAILABLE”,1600),
(188,”Nostromo”, ”English”, “Joseph Conrad”, “1999”, “AVAILABLE”, 1200),
(189,”lord Jim”, ”English”, “Joseph Conrad”, “1987”, “AVAILABLE”, 1300),
(190,”An island tale”, ”English”, “Emily Bronte”, “1988”, “AVAILABLE”, 600),
(191,”Atins Physical chemistry”, ”Chemistry”, “Peter Atkins”, “1999”, “AVAILABLE”, 1200), 
(192,”The Disappearing spoon”, ”Chemistry”, “Sam Kean”, “2010”, “AVAILABLE”, 1500), 
(193,”Chemistry Of Dummies”, ”Chemistry”, “John T. Moore”, “1999”, “AVAILABLE”, 1200), 
(194,”Molecules”, ”Chemistry”, “Theodore Gray”, “1998”, “AVAILABLE”, 1991), 
(195,”Elements”, ”Chemistry”, ”Theodore Gray”, “1994”, “AVAILABLE”, 2000), 
(196,”Organic Klein ”, ”Chemistry”, “David Klein”, “1990”, “AVAILABLE”, 2200),
(197,”Basic Chemistry”, ”Chemistry”, “Karen Timberlake”, “1994”, “AVAILABLE”, 1200), 
(198,”NMR And Chemistry”, ”Chemistry”, “Brian E. Mann”, “2001”, “AVAILABLE”, 1500), 
(199,”H2O”, ”Chemistry”, “Philip Ball”, “1995”, “AVAILABLE”, 2200), 
(200,”Ap Chemistry”, ”Chemistry”, “Neil D Jespersen”, “2005”, “AVAILABLE”, 1900), 
(201,”The Man Who Counted”, ”Math”, “Malba Tahan”, “2005”, “AVAILABLE”, 2500), 
(202,”The Universal History”, ”Math”, “Georges Ifrah”, “2001”, “AVAILABLE”, 2000), 
(203,”Zero”, ”Math”, “Charles Seife”, “2003”, “AVAILABLE”, 2100), 
(204,”The History Of Pi”, ”Math”, “Petr Beckmann”, “2005”, “AVAILABLE”, 2500), 
(205,”The Triumph of Number”, ”Math”, “I B Cohen”, “2003”, “AVAILABLE”, 2400), 
(206,”Basic Mathematics”, ”Math”, “Serge Lange”, “2005”, “AVAILABLE”, 2500),
(207,”Geometry”, ”Math”, “Serge Lange”, “2005”, “AVAILABLE”, 2500), 
(208,”Complex Analysis”, ”Math”, “Serge Lange”, “2007”, “AVAILABLE”, 2500), 
(209,”Short Calculus”, ”Math”, “Serge Lange”, “2008”, “AVAILABLE”, 2500), 
(210,”linear Algebra”, ”Math”, “Serge Lange”, “2010”, “AVAILABLE”, 2500);