mydb.sql

-- phpMyAdmin SQL Dump
-- version 4.8.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 18, 2019 at 06:05 PM
-- Server version: 10.1.33-MariaDB
-- PHP Version: 7.2.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `mydb`
--

-- --------------------------------------------------------

--
-- Table structure for table `cart`
--

CREATE TABLE `cart` (
  `Customer` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `Product` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `Quantity` int(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cart`
--

INSERT INTO `cart` (`Customer`, `Product`, `Quantity`) VALUES
('suyashgulati', 'ENT-12', 1),
('suyash', 'NEW-4', 5),
('suyashgulati', 'ENT-1', 3),
('suyash', 'BIO-3', 5),
('suyashgulati', 'CHILD-1', 6),
('suyashgulati', 'NEW-1', 1),
('nimisha', 'NEW-2', 1),
('nimisha', 'ENT-7', 1),
('suyash', 'ENT-12', 1),
('suyashgulati', 'ENT-1222', 1),
('suyash', 'ENT-1', 1),
('himanshumadan1059@gmail.com', 'ACA-5', 0);

-- --------------------------------------------------------

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `PID` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `Title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `Author` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `MRP` float NOT NULL,
  `Price` float NOT NULL,
  `Discount` int(11) DEFAULT NULL,
  `Available` int(11) NOT NULL,
  `Publisher` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Edition` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Category` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Description` text COLLATE utf8_unicode_ci,
  `Language` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `page` int(5) DEFAULT NULL,
  `weight` int(4) DEFAULT '500'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`PID`, `Title`, `Author`, `MRP`, `Price`, `Discount`, `Available`, `Publisher`, `Edition`, `Category`, `Description`, `Language`, `page`, `weight`) VALUES
('ENT-1', 'The Indian Economy : For UPSC And State Civil Services Preliminary And Main Examinations', 'Sanjiv Verma', 235, 148, 37, 5, 'Unique Pubishers', '2', 'Entrance Exam', 'Sanjiv Verma’s The Indian Economy : For UPSC and State Civil Services Preliminary and Main Examinations 2nd Edition is a comprehensive book for UPSC aspirants. The book comprises of multiple chapters which give you a better understanding of various topics. This book is essential for candidates applying for UPSC and other competitive exams.About Sanjiv VermaSanjiv Verma is an Indian author. He has penned down the book  The Indian Economy : For UPSC and State Civil Services Preliminary and Main Examinations 2nd Edition. # Part A: Domestic Economy1. Output of an Economy2. Towards Inclusive Growth (Growth and Development)3. Sustainable Development and Green GDP4. Poverty and Social Sector5. Food Security 6. Agriculture Sector 7. Land Reforms - Another Perspective8. Salient Features - New India9. Industrial Sector and Liberalization10. Infrastructure Development11. Investment Models12. Integrated Energy Policy (2031–32)13. Government Finances14. Bridging Deficits Money and Government Borrowings15. Banking16. Inflation17. Capital Market18. Planning in IndiaPart B: External Sector - Looking Outwards Towards Globalization and Beyond19. Looking Outward - Towards Globalization20. Inward and Outward - Looking Economies Globalization21. Going Forward - India and Globalization22. Export-Led Growth Strategy - SEZs23. Foreign Trade Policy (2009-2014)24. Balance of Payments of Economies (BOP) 25. Trade Reforms and Foreign Exchange Management Act (FEMA) 199926. Foreign Investment in India 27. Multilateral Financial Institutions28. External Debt of India29. Exchange Rate Determination30. Foreign Exchange Reserves31. Regional Trading Blocs Part C: Global Economy and Outlook Post-crisis and Beyond32. India and the Global Economy33. Global Economy - A Transition34. Global Integration35. Lessons from Crises in Open Economies 36. Global Financial Meltdown37. Global Crisis - Government Interventions38. Overview of Recent Crises Since 200839. Global Consensus - Going Forward40. Way Going Forward - Addressing Structural Issues 41. Global Unresolved Issues42. Post-Crisis - Future of Globalization43. World Trade Organization (WTO) - Issues and IndiaPart D: Indian Economy Revisited Outlook and Challenges44. Two Decades of Economic Reforms - India45. Indian Economy - Outlook and Challenges # Sanjiv Verma is an Indian author. He has penned down the book  The Indian Economy : For UPSC and State Civil Services Preliminary and Main Examinations 2nd Edition. # Part A: Domestic Economy1. Output of an Economy2. Towards Inclusive Growth (Growth and Development)3. Sustainable Development and Green GDP4. Poverty and Social Sector5. Food Security 6. Agriculture Sector 7. Land Reforms - Another Perspective8. Salient Features - New India9. Industrial Sector and Liberalization10. Infrastructure Development11. Investment Models12. Integrated Energy Policy (2031–32)13. Government Finances14. Bridging Deficits Money and Government Borrowings15. Banking16. Inflation17. Capital Market18. Planning in India # Part B: External Sector - Looking Outwards Towards Globalization and Beyond19. Looking Outward - Towards Globalization20. Inward and Outward - Looking Economies Globalization21. Going Forward - India and Globalization22. Export-Led Growth Strategy - SEZs23. Foreign Trade Policy (2009-2014)24. Balance of Payments of Economies (BOP) 25. Trade Reforms and Foreign Exchange Management Act (FEMA) 199926. Foreign Investment in India 27. Multilateral Financial Institutions28. External Debt of India29. Exchange Rate Determination30. Foreign Exchange Reserves31. Regional Trading Blocs # Part C: Global Economy and Outlook Post-crisis and Beyond32. India and the Global Economy33. Global Economy - A Transition34. Global Integration35. Lessons from Crises in Open Economies 36. Global Financial Meltdown37. Global Crisis - Government Interventions38. Overview of Recent Crises Since 200839. Global Consensus - Going Forward40. Way Going Forward - Addressing Structural Issues 41. Global Unresolved Issues42. Post-Crisis - Future of Globalization43. World Trade Organization (WTO) - Issues and India # Part D: Indian Economy Revisited Outlook and Challenges44. Two Decades of Economic Reforms - India45. Indian Economy - Outlook and Challenges', 'Others', 256, 500),
('ENT-2', 'General Knowledge 2017', 'Manohar Pandey', 120, 68, 43, 15, 'Arihant Publication', '9', 'Entrance Exam', 'In-depth Knowledge About The Varied Sections Covered Under The Subject Of General Knowledge Is Mandatory For The Candidates Aspiring To Appear For Various Competitive And Recruitment Examinations Like SSC, Bank Clerk & PO, Railway Recruitment, Etcas The Same Is Asked In Almost Each And Every Recruitment Examination.\nGeneral Knowledge 2017 Provides A Comprehensive Study Of All The Sections That Are Covered Under The Subject Of General Knowledge. The Book Has Been Divided Into 6 Sections ', 'English', 320, 500),
('ENT-3', 'Kiran', 'Kiran Prakashan,Pratiyogita Kiran & KICX', 475, 332, 30, 10, 'Kiran Prakashan', '2', 'Entrance Exam', '', 'English', 936, 500),
('ENT-4', 'Previous YearsSolved Papers & 10 Practice Sets CMC (Vellore & Ludhiana) Entrance Exam', 'Arihant Experts', 400, 300, 25, 15, 'Arihant Publication', '4', 'Entrance Exam', 'The Christian Medical College Entrance Exam is conducted by CMC Vellore Association and CMC, Ludhiana Society respectively for admission toChristian Medical College (CMC) Vellore and Ludhiana. The CMC Entrance Examinationserves as a qualifying examination for admission to undergraduate medicalcourses such as MBBS, BDS and B.Sc Nursing in CMC Vellore and CMC Ludhiana.This book has been designed for the aspirants aiming to get admission in CMCVellore and Ludhiana.\r\nThe present book contains both previous years', 'English', 590, 500),
('ENT-5', 'IIM Indore IPM Full Length Test Series (Fully Solved)', 'North Academics; Nishit Sinha', 740, 599, 19, 2, 'North Academics', '1', 'Entrance Exam', 'IIM Inodre IPM Full Lenth Test Series. 7 Full Length Mock Test Papers\r\n\r\n\r\nIncludes Qualifying Marks and Strategies\r\n\r\n\r\nIncludes Concept Notes and Explanations\r\n\r\n\r\nOMR Sheets provided\r\n\r\nAbout The Author\r\n\r\nFounder-director of dueNorth. Passout of IIM Lucknow, author of bestselling CAT books with Pearson publications, 10+ years of teaching experience (5 years at Delhi), Worked as the Academics Head of two national test-prep companies', 'English', 272, 560),
('ENT-6', 'Marketing Management', 'Kevin Lane Keller Philip Kotler', 899, 802, 11, 15, 'Pearson', '15', 'Entrance Exam', 'Marketing Management\r\nBy Kevin Lane Keller Philip Kotler\r\nEdition 15\r\nPublication Year 2016\r\nPublisher Name Pearson', 'others', 568, 500),
('ENT-7', 'The Mega Yearbook 2016 - Current Affairs & General Knowledge For Competitive Exams', 'Disha Experts', 350, 175, 50, 13, 'Disha Publication', '1', 'Entrance Exam', 'In the age of technology, we are swimming in an ocean of information digital information, printed information but who to trust and who will serve the quality. Disha s The MEGA Year Book 2016 is heralded as one of the most authoritative and comprehensive compendiums of high-quality reference materials on all subjects Current Affairs, Panorama, Geography, History, Polity, Economy, Finance, General Science, Environment, Art & Culture, Sports, Healthcare, Education & Career, English Language and many more. The MEGA Year Book 2016 has been designed to cater to aspirants of various competitive exams like Civil services, Banks, Railways, UPSC and PSC exams and Quiz Competition across the country. It equally serves teachers, researchers, media persons, planners, avid readers and laymen. The book is equally useful for school students who want to increase their knowledge/ awareness.\r\nThe book has a very vast coverage and covers everything and anything related to current affairs general knowledge. The book can be divided into 2 broad parts: Part A - Current Affairs; Part B - General Knowledge\r\nCurrent Affairs contains Latest Articles, India Timelines, World Timelines, Top 500 People, Events, Ideas and Issues, Emerging Trends, INDIA - SWOT, Cause & Effects, Unanswered Questions, Coming Up 2016 etc.\r\nGeneral Knowledge contains India Panorama, World Panorama, Most Famous People of All Time, Geography, History, Polity, Economy, Business, General Science, Ecology and Environment, Art & Culture, Sports, Healthcare, Communication, News & Media, Education & Career, IT & Computers, English Language, General Aptitude, Technology, FUN ZONE, etc.\r\nSingle Book Multiple Features:\r\nThe India - SWOT Analysis - covers the social, political & economic aspects.\r\nFun Zone - which covers Scramble, Brain Teasers, Maths Fun, Crosswords, Mail Cartoon, Twitter Tweets, Amazing Facts etc.\r\nTimeline 2015 - covering the timeline of important dates from Jan-Dec 2015 of India and the World.\r\nTop 500 - covering the Top 500 People, Events, Ideas and Issues that raised their head in 2015.\r\nIndian Panorama - which captures every essence of all the states along with various superlatives. World Panorama - which captures every essence of all the countries along with various superlatives. \r\nSectional Mindmaps - which presents the structure of each of the sections in a graphical pattern.\r\nMost Famous People of All Time - of India/ world.\r\nEnglish Language - captures the basic definitions and rules of Grammar, Parts of Speech, etc. along. with day-to-day useful Idioms, phrases, words, foreign words and confusing words.\r\nAptitude - highlighting the various things we should work on to build our aptitude.\r\n25+ Analytical Articles - capturing the hottest of the issues of 2015.\r\nComing Up 2016 - capturing the events to come and what to expect in 2016.', 'others', 848, 500),
('ENT-8', 'Indian Polity (Civil Services Mains; Csat; Civil Services General)', 'M Laxmikanth', 425, 595, 29, 10, 'McGraw Hill Education', '4', 'Entrance Exam', 'We want you to Stay Ahead  why the best of Study Material for your Civil Service Examination is here!!\r\n\r\nBuy excellent study material for Indian Polity to achieve those desired goals for your Civil Services Mains; CSAT; Civil Services General and for similar examinations too. We Wish You Good luck!!', 'others', 696, 500),
('ENT-9', 'Guide To RRB Non Technical Recruitment Exam', 'Disha Experts', 300, 150, 50, 8, 'Disha Publication', '1', 'Entrance Exam', 'Guide to RRB Non Technical Recruitment Exam is an ultimate attempt to provide exposure to the students for the upcoming Non-technical exam.\n The book has 4 sections: General Intelligence & Reasoning, General Awareness, General Science and Arithmetic.\n Each section is further divided into chapters which contains theory explaining the concepts involved followed by MCQ exercises.\n The detailed solutions to all the questions are provided at the end of each chapter.\n The General Science section provides material for Physics, Chemistry and Biology.\n There is a special chapter created on Railways in the general awareness section.\n The book covers 100% syllabus as prescribed in the notification of the RRB exam.', 'English', 336, 500),
('ENT-10', 'General Studies Paper 1', 'J K Chopra', 1499, 913, 39, 9, 'Unique Publisher', '37', 'Entrance Exam', '\"History of India \r\n\r\n    (A) ANCIENT INDIA\r\n1.  India and Its Ancient Culture\r\n2.  Pre-Historic Period\r\n3.  Indus Valley Civilizations (2500-1800 BC)\r\n4.  Vedic Age\r\n5.  Emergence of Mahajanapadas\r\n6.  Age of Religious Movements:\r\nJainism, Buddhism and Other Sects\r\n7.  The Mauryas (321 BC', 'English', 453, 500),
('ENT-11', 'Mechanical Engineering', 'R S KHURMI, J K GUPTA', 625, 434, 31, 19, 'S Chand & Company Ltd', '7', 'Entrance Exam', 'For the students of U.P.S.C. (Engg services); IAS (Engg. group); B.Sc Engg; Diploma and other competitive courses.\r\n	More than one thousand Objective Type Questions from various examining bodies have been added. The solutions to Important Objective type Questions have been added at the end of this treatise. It includes Multiple Choice questions, true and false questions, fill in the blank and matching type questions.#\r\nEngineering Mechanics\r\nStrength of Materials\r\nHydraulics and Fluid Mechanics\r\nHydraulic Machines\r\nThermodynamics\r\nSteam Boilers and Engines\r\nSteam Nozzles and Turbines\r\nI.C. Engines and Nuclear Power Plants\r\nCompressors, Gas Dynamics and Gas Turbines \r\nHeat Transfer, Refrigeration and Air Conditioning\r\nTheory of Machines\r\nMachine Design \r\nEngineering Materials \r\nWorkshop Technology\r\nProduction Engineering\r\nIndustrial Engineering and Production Management\r\nAutomobile Engineering\r\nIndex', 'others', 853, 500),
('ENT-12', 'ESE-2016 : Mechanical Engineering Conventional Solved Paper 2', 'MADE EASY Team', 350, 217, 38, 89, 'MADE EASY Publications', '5', 'Entrance Exam', 'This edition of ESE Mechanical Engineering Conventional book is arranged as per the requirements of the latest syllabi of ESE. Every chapter in the book is logically divided into various sections, while ensuring that the contents in the book are self-sufficient and require no cross-referencing. All conventional questions along with their solutions are given in each chapter. The book offers a unique problem-solving technique, which guides students towards stepwise solving of problems. Efforts have been made to avoid any kind of misconception and complexity in understanding the solutions of the problems. Overall, the whole content of the book furnishes the students with the right knowledge and paves a confident path for the aspirants to accomplish success in ESE.', 'others', 272, 500),
('LIT-1', 'Chetan Bhagat Collection', 'Chetan Bhagat', 1408, 915, 35, 87, 'Rupa Publication', '1', 'Literature and Fiction', 'Authored By Chetan Bhagat\r\nEdition 1 \r\nPublication Year 2011\r\nPublisher Name Rupa Publication\r\nWeight 500 gm\r\nLanguages English', 'English', 7890, 500),
('LIT-2', 'Ashwin Sanghi Boxset (Set Of 3 Books)', 'Ashwin Sanghi', 699, 599, 20, 67, 'Westland Publisher', '1', 'Literature and Fiction', 'This Boxset Include These Titles 1.) The Rozabal Line The Rozabal Line is the debut novel of Ashwin Sanghi. The author has taken up the creative liberty of using various religious facts in order to whip up an epic fictional thriller. Sanghi speculates that Jesus Christ survived the crucifixion and spent his missing years in India and that the men searching for Jesus were Buddhist Monks who were searching for the reincarnation of the Dalai Lama. He mentions that the lost tribes of Israel may have settled in Kashmir. The author also introduces St. Thomas as one of Jesuss closest friends and Mary Magdalene as a woman from the ancient Mauryan Empire headed by Ashoka. The book further features terrorist attacks that share some parallels with the 2008 Mumbai attacks. Sanghis hypothesis goes on to establish that Jesuss descendants are todays Kashmiri Islamists. The author draws some similar lines between the fate of a group of terrorists and that of Jesus and his 12 apostles. The book traces the roots of various religions and states that all their origins are closely knit. ', 'English', 1020, 500),
('LIT-3', 'Tintin : Complete Adventures Of Tintin', 'Herge', 7999, 5839, 27, 48, 'Egmont Childrens Books', '1', 'Literature and Fiction', 'The author lets you join the most iconic character in comics as he embarks on extraordinary adventures and solves thrilling mysteries! From the Land of the Soviets to America, from outer space to the depths of the ocean, there are over 1,500 pages of delight in eight volumes of classic Tintin stories. The ultimate gift for any Tintin fan. The Adventures of Tintin continue to charm more than 80 years after they first found their way into publication. Since then an estimated 230 million copies have been sold, proving that comic books have the same power to entertain children and adults in the 21st century as they did in the early 20th.', 'English', 1618, 500),
('LIT-4', 'Fifty Shades Trilogy (Set of 3 Books)', 'E. L. James', 1399, 909, 35, 78, 'Cornerstone', '1', 'Literature and Fiction', 'Authored ByE.L. James\r\nLanguage English\r\nEdition 1\r\nPublication Year 2012 June\r\nPublisher Name Cornerstone\r\nNo. Of Pages 1296\r\nWeight 45 gm\r\nBinding Paperback\r\nLanguages English', 'English', 1296, 45),
('LIT-5', 'Code Red', 'Shantanu Dhar', 195, 135, 31, 23, 'Om Books International', '1', 'Literature and Fiction', 'Code Red is a complex horrorcum- psychological thriller that takes place across the UK, the US and the rainforest. A truly international thriller, it takes the reader on a dizzying ride across a story that is multilayered and asks several thought-provoking questions.\r\n\r\nAbout Shantanu Dhar\r\n\r\nShantanu Dhar earned a Bachelor s in English Literature from the University of Pune, Nashik, and a post-graduate degree in Human Resource Development from Pittsburgh State University, Kansas, US. Currently employed with a major Inconglomerate, he writes regularly for business magazines on human behaviour at the workplace. He has been deeply inspired by Greek tragedies and Gothic novels in his fiction writing. Shantanu lives in Greater Noida with his wife and two children.', 'English', 250, 500),
('LIT-6', 'Love . . . Not for Sale!', 'Anurag Garg', 175, 123, 30, 27, 'Ebury Press', '1', 'Literature and Fiction', 'Love can happen anywhere, with anyone. Kabir Thapar is the spoilt son of a rich capitalist in Mumbai. His mothers sudden death scars him for life, leaving him at loggerheads with his father who finds himself a new wife in no time. As Kabir embarks on a downward spiral of alcohol and drugs, he, on one ill-fated day, finds himself embroiled in a hit-andrun case. Making a quick escape, Kabir ends up in a red-light area, where he meets Sehar, a sex worker. As he falls head over heels for her, he must own up to the one emotion he has been running away from all his life love. From the bestselling author of A Half-baked Story comes a story that perfectly weaves together the explosive passion between Kabir and Sehar, the contradictions of modern India and the inevitable tragedy that befalls its lovers.', 'English', 456, 500),
('LIT-7', 'Ten Love Stories : An IndiBlogger Selection', 'Various', 250, 160, 36, 34, 'Harper Collins', '1', 'Literature and Fiction', 'A brief fling between ex-flames ends up all in a jumble. A Chinese dentist who swears by his crocs strikes up a rare friendship with a quiet photographer. On a cold winter\'s day, amidst the romantic grandeur of old Delhi, something is brewing between two strangers brought together by their parents. This IndiBlogger-HarperCollins collaboration is a collection of the ten best love stories selected by some of contemporary India\'s finest writers and editors from a list of over 500 entries. These stories are a window to how a new generation of young men and women negotiate matters of love and life in the age of Whatsapp and Facebook. The peppy-dynamic prose within these pages radiates a youthful vitality that perfectly captures its unabashedly urban and modish characters.', 'English', 184, 500),
('LIT-8', 'Two Years Eight Months And Twentyeight Nights: A Novel', 'Salman Rushdie', 599, 412, 31, 56, 'Hamish Hamilton', '1', 'Literature and Fiction', 'Review\r\n\r\nAdvance praise for Two Years Eight Months and Twenty-Eight Nights\r\n\r\n\r\n\r\nIn his latest novel, [Salman] Rushdie invents his own cultural narrative one that blends elements of One Thousand and One Nights, Homeric epics, and sci-fi and action/adventure comic books. . . . Referencing Henry James, Mel Brooks, Mickey Mouse, Gracian, Bravo TV, and Aristotle, among others, Rushdie provides readers with an intellectual treasure chest cleverly disguised as a comic pop-culture apocalyptic caprice. Publishers Weekly (starred review)', 'others', 304, 500),
('LIT-9', 'The Girl in the Spider\'s Web', 'David Lagercrantz', 599, 405, 32, 12, 'Quercus', '1', 'Literature and Fiction', 'She is the girl with the dragon tattoo. Lisbeth Salander. An uncompromising misfit whose burning sense of injustice and talent for investigation will never respect boundaries of state or status. He is a campaigning journalist. Mikael Blomkvist. A lone wolf whose integrity and championing of the truth bring him time and again to the brink of unemployment - and prosecution. The call comes in late at night: a superhacker has gained access to critical, top secret U.S. intelligence. Blomkvist knows only one person who could crack the best security systems in the world. This case has all the hallmarks of Salander. She is accused of acting without reason, taking risks just because she can, but though they have lost touch, Blomkvist knows Lisbeth better than that. There must be something deeper at the heart of this - maybe even the scoop that Millennium magazine so desperately needs for its survival. A tangled web of truth that someone is prepared to kill to protect . .', 'English', 540, 500),
('LIT-10', 'You\'re Trending In My Dreams', 'Sudeep Nagarkar', 175, 123, 30, 15, 'Random House India', '1', 'Literature and Fiction', 'Four friends . . . four lives . . . one decision\r\nFour college students, who couldn’t be more different from each other, move into a flat in Mumbai. While Varun is sloppy but lovable, Ahana is gutsy and reckless; Malvika is the group’s selfie queen and Garima is the most reserved in the group. Yet, all four get along like a house on fire. Although each of them is battling personal demons, their commitment to the bond of friendship they have built over time holds them together. Things, however, take a turbulent turn when one of the four finds herself caught in a mess. Will they stick together or fall apart? You’re Trending in My Dreams is a true story that will reaffirm your faith in the magic of love and friendship.', 'English', 216, 500),
('LIT-11', 'Tell Me A Story', 'Ravinder Singh', 175, 123, 30, 23, 'Metro Reads', '1', 'Literature and Fiction', 'There is always a story that changed your life…\r\nAnd that is the time when life happened for you!\r\nTell Me a Story is collection of heartwarming stories about events and incidents that have affected or changed the lives of the writers in ways that they cannot forget. Happy or sad, inspiring or shocking, these are stories of moments that have left an indelible mark on their lives. Stories, that they would love to share.\r\n\r\nSelected and edited by Ravinder Singh, Tell Me a Story is about moments that make life worth living. It is the second such anthology, after the highly successful Love Stories that Touched My Heart.', 'English', 240, 500),
('LIT-12', 'Go Set A Watchman', 'Harper Lee', 799, 399, 50, 12, 'Random House', '1', 'Literature and Fiction', 'Go Set a Watchman is set during the mid-1950s and features many of the characters from To Kill a Mockingbird some twenty years later. Scout (Jean Louise Finch) has returned to Maycomb from New York to visit her father Atticus. She is forced to grapple with issues both personal and political as she tries to understand both her father s attitude toward society, and her own feelings about the place where she was born and spent her childhood. An instant classic.', 'English', 320, 500),
('BIO-1', 'Wings Of Fire: An Autobiography', 'Arun Tiwari,Abul Kalam', 325, 170, 48, 11, 'Universities Press', '1', 'Biographies and Auto Biographies', 'Authored By Arun Tiwari,Abul Kalam\r\nEdition 1\r\nPublication Year 2015\r\nPublisher Name Universities Press\r\nNo. Of Pages 180\r\nWeight299 gm\r\nBinding Others\r\nLanguages Others', 'others', 180, 299),
('BIO-2', 'The Z Factor : My Journey As The Wrong Man At The Right Time', 'Subhash Chandra, Pranjal Sharma', 699, 454, 35, 16, 'Harper Collins', '1', 'Biographies and Auto Biographies', 'The pioneer who gate-crashed his way to the top\r\n\r\nSubhash Chandra, the promoter of Essel/ Zee Group, is an unlikely mogul. Hailing from a small town in Haryana, where his family ran grain mills, Chandra has been a perennial outsider, repeatedly aiming high and breaking into businesses where he was considered an interloper. \r\nStarting work as a teen to pay off family debts, Chandra had to rely on bluff, gumption and sheer hard toil to turn things around. A little bit of luck and political patronage saw him make a fortune in rice exports to the erstwhile USSR. \r\nAlways a risk-taker, Chandra then had the vision of getting into broadcasting early, even as established media players failed to see its potential. His Zee TV, India’s first private Indian TV channel, changed the rules of the game and tickled the fancy of a public starved of entertainment. \r\nSeveral gutsy initiatives followed, though not all of them were successful. Chandra’s attempts to launch satellite telephony and a cricket league came a cropper. But the man continues to reinvent himself; he is now also focusing on infrastructure and smart cities. \r\nThis is an unusually candid memoir of a truly desi self-made businessman who came to Delhi at age twenty with seventeen rupees in his pocket. Today, he has a net worth of $6.3 billion and annual group revenues of about $3 billion. \r\n\r\nAbout The Author : \r\n\r\nSubhash Chandra is the promoter of Essel/Zee Group of companies, which is a major player in the fields of media and entertainment, packaging, technology, infrastructure and education. \r\nPranjal Sharma has been in print, digital and TV media for twenty-five years. He has led teams at India Today Group and CNBC Network 18, and was founding executive editor of Bloomberg TV in India. He currently writes for Businessworld and hosts a show for Zee Business.', 'English', 300, 500),
('BIO-3', 'Standing Guard: A Year In Opposition', 'P Chidambaram', 500, 395, 21, 12, 'Rupa Publications', '1', 'Biographies and Auto Biographies', 'Authored by P. Chidambaram, one of India s bestknown politicians, Standing Guard offers a keen economic and political analysis of India@2015 the tumult of the 2015 Bihar election, the debates surrounding the Land Acquisition Amendment ordinances and the Goods and Services Tax (GST) Bill, and the alarming rise of intolerance. In this rare collection of essays, Chidambaram refuses to shy away from any subject, no matter how contentious. With characteristic candour he examines issues as varied as the true mandate of the Reserve Bank of India, the implications of the Union Budgets, the successes and failures of the United Progressive Alliance governments, and the formidable challenges that lie ahead of the Modi regime. Equally, the author presents a compass for the future underscoring the need for humility while administering a complex nation and for accommodating Opposition voices for the greater common good. In presenting, at once, a critique and a constructive road map, this book plays out the true meaning of a vibrant democracy a system of governance in which the Opposition stands guard and remains as responsible as the government of the day. Standing Guard is evidence why P. Chidambaram is considered not just an accomplished economist and administrator, but also a statesman of the finest calibre.', 'English', 226, 500),
('BIO-4', 'The Turbulent Years: 1980 1996', 'Pranab Mukherjee', 595, 393, 34, 12, 'Rupa Publication', '1', 'Biographies and Auto Biographies', 'A sharp insider s account of the many political and economic decisions that shaped the future of modern India\r\n\r\nThe Turbulent Years opens in the 1980s. Sanjay Gandhi is dead under unexpected, tragic circumstances; not many years later, Indira Gandhi is assassinated; Rajiv Gandhi, the reluctant politician , abruptly becomes India s Prime Minister. \r\nPranab Mukherjee was witness to (and, sometimes, a participant in) the momentous events of the 1980s and the 1990s, a period that was indisputably the most turbulent in India s post Independence history. An insider, he sheds new light on every major political occurrence of the time from Rajiv Gandhi s ascendance as India s Prime Minister to the emergence of P.V. Narasimha Rao as a leader of the nation; from Operation Blue Star to the Babri Masjid fiasco. \r\nEqually, Mukherjee is candid about each of the professional crises that marked this period of his career the rumours that he wanted to elbow aside Rajiv Gandhi for the top post; the possible reasons for his ouster from Rajiv s Cabinet and, later, the party; and the allegation that he aided and abetted the Left by not imposing President s rule in West Bengal and Tripura in the late 1980s. ', 'English', 243, 500),
('BIO-5', 'Cracking The Code : My Journey To Bollywood', 'Ayushmann Khurrana; Tahira Kashyap', 195, 137, 30, 15, 'Rupa Publications India', '1', 'Biographies and Auto Biographies', 'Ayushmann\'s journey is a wholesome and insightful account of the trials and tribulations involved in trying to get a break in Mumbai\'s entertainment industry. \'Ayushmann\'s account of the dreaded yet inevitable pre-stardom struggle is as real and insightful as it gets! His experiences will make you cry and make you laugh.', 'English', 158, 500),
('BIO-6', 'I Am Malala : The Girl Who Stood Up For Education And Was Shot By The Taliban', 'Malala Yousafzai,Christina Lamb', 399, 200, 50, 12, 'Hachette', '1', 'Biographies and Auto Biographies', '*Winner of the 2014 Nobel Peace Prize*In 2009 Malala Yousafzai began writing a blog on BBC Urdu about life in the Swat Valley as the Taliban gained control, at times banning girls from attending school. When her identity was discovered, Malala began to appear in both Pakistani and international media, advocating the freedom to pursue education for all. In October 2012, gunmen boarded Malala\'s school bus and shot her in the face, a bullet passing through her head and into her shoulder. Remarkably, Malala survived the shooting.At a very young age, Malala Yousafzai has become a worldwide symbol of courage and hope. Her shooting has sparked a wave of solidarity across Pakistan, not to mention globally, for the right to education, freedom from terror and female emancipation. # # In 2009 Malala Yousafzai began writing a blog on BBC Urdu about life in the Swat Valley as the Taliban gained control, at times banning girls from attending school. When her identity was discovered, Malala began to appear in both Pakistani and international media, advocating the freedom to pursue education for all. In October 2012, gunmen boarded Malala\'s school bus and shot her in the face, a bullet passing through her head and into her shoulder. Remarkably, Malala survived the shooting. # # At a very young age, Malala Yousafzai has become a worldwide symbol of courage and hope. Her shooting has sparked a wave of solidarity across Pakistan, not to mention globally, for the right to education, freedom from terror and female emancipation.', 'English', 320, 500),
('BIO-7', 'Being Salman', 'Jasim Khan', 599, 418, 30, 11, 'Penguin Books', '1', 'Biographies and Auto Biographies', 'Salman Khan turns fifty on 27 December 2015. Having made his film debut in 1988, he has found his place in the hearts of millions, with blockbuster movies ranging from Maine Pyar Kiya and Hum Aapke Hain Koun to the more recent Dabangg, Ek Tha Tiger, Kick and Bajrangi Bhaijaan to his credit. He is also well known for his magnanimity, including his work with the non-profit charitable organization, Being Human, which he runs.\r\n\r\n\r\n\r\nSalman?s stint with controversies has been as long as his career. His personal life has often made headlines, as have his involvements in the blackbuck poaching case and the hit-and-run case. He has a reputation for getting hot under the collar and abusive when riled. These attributes have earned him the dubious title of the \'bad boy of Bollywood\'. Which is the real Salman Khan? Why is he the way he is? This book delves into Salman?s family lineage and his personal history to reveal interesting vignettes and unknown facts about the enigmatic and immensely popular superstar and will help his many fans understand what \'Being Salman\' is all about.', 'English', 304, 500),
('BIO-8', 'M.K. Gandhi An Autobiography', 'M K Gandhi', 140, 98, 30, 13, 'GBD BOOKS', '1', 'Biographies and Auto Biographies', 'The Story of My Experiments with Truth is the Autobiography of Mohandas Karamchand Gandhi, covering his life from early childhook through to 1920. It was initiated at the insistence of Swami Anand and other close coworkers of Gandhi, for him to explain the background of his public campaigns. In 1999, the book was designated as one of the \"100 Most Important Spiritual Books of the 20th Century\" by Harper Collins publishers.\r\n\r\nGandhiji wrote in his Autobiography that the three most important modern influences in his life were Leo Tolstoys The Kingdom of God is within you, John Ruskins unto this last and the peot Shrimad Rajchandra (Raychandbhai). In the last chapter, he notes, \"My life from this point onward has been so public that there is hardly anything about it that people do not know...\" \r\n\r\nThe only English translation of The Story of My Experiments with Truth was done by Gandhis friend and assistant Mahadev Desai.', 'English', 450, 500),
('BIO-9', 'Steve Jobs', 'Walter Isaacson', 1000, 899, 10, 1, 'Little, Brown Book Group', '1', 'Biographies and Auto Biographies', 'Based on more than forty interviews with Steve Jobs conducted over two years - as well as interviews with more than a hundred family members, friends, adversaries, competitors, and colleagues - this is the acclaimed, internationally bestselling biography of the ultimate icon of inventiveness. Walter Isaacson tells the story of the rollercoaster life and searingly intense personality of creative entrepreneur whose passion for perfection and ferocious drive revolutionized six industries: personal computers, animated movies, music, phones, tablet computing, and digital publishing. Although Jobs cooperated with this book, he asked for no control over what was written, nor even the right to read it before it was published. He put nothing off limits. He encouraged the people he knew to speak honestly. And Jobs speaks candidly, sometimes brutally so, about the people he worked with and competed against. His friends, foes, and colleagues provide an unvarnished view of the passions, perfectionism, obsessions, artistry, devilry, and compulsion for control that shaped his approach to business and the innovative products that resulted.', 'English', 592, 500),
('BIO-10', 'The Substance And The Shadow:An Autobiography Dilip Kumar', 'Dilip Kumar', 699, 599, 20, 4, 'Hay House', '1', 'Biographies and Auto Biographies', 'Dilip Kumar The Substance and the Shadow An Autobiography is the long awaited life story of the legendary veteran Indian actor. This autobiography is a genuine, earnest and fascinating narrative straight from the actors heart and mind that discloses for the first time several unknown aspects of the life and times of Dilip Kumar one of the greatest Bollywood actors of all time, and also stands out as an icon of a secular India. Dilip Kumar was born as Yousuf Khan. He started as a shy rookie in Hindi cinema in the early 1940s and there was no looking back. He went on to reach the zenith of stardom within a short period of time. He delivered mesmerizing performances in one hit movie after another, in a row! His almost sixdecadelong career as an actor was based only on his original ability, unwavering willpower, sheer hard work and diehard optimistic attitude. In this book, Dilip Kumar tells us his journey right from his birth, his days as an aspiring actor, his ascent to the pinnacle of success and the rest, to the present day. He frankly narrates his relationships with different variety of people. His interactions were not only restricted to his family, friends and the film world but also with businessmen and politicians. Dilip Kumar sets the record straight about how he got married to Saira Banu, one of the then Bollywood beauties. He feels that a lot of what was written about him so far is mostly misinterpreted, and so he narrates, in graphic detail, about his romantic relationship and marriage, which pretty much reads like a fairy tale! He fondly remembers the event that changed his life forever his meeting with Devika Rani, the boss of the famous Bombay Talkies, and being offered an acting job. His first film was Jwar Bhata (1944). He explains how he had to learn the whole kit and caboodle from scratch and how he had to cultivate his own individual dramatics and panache that would set him apart from his contemporaries. He soon scaled great heights with movies like Jugnu, Shaheed, Mela andaz, Deedar, Daag and Devdas. In most of his movies he played the tragedian with such a matchless intensity that his mind was undesirably affected. He had to consult a British psychiatrist, who counselled him to shift to play comedy. The consequence was his remarkable performances in the hilarious, laugh riots like Azaad and Kohinoor, apart from an amusing depiction as a resolute Tongdriver in Naya Daur. He then took a fiveyear break and later began his second innings with Kranti in 1981, post which he acted in successions of hits such as Vidhaata, Karma, Saudagar, Mashaal, Shakti, and Qila.', 'English', 450, 500),
('BIO-11', 'Shantaram', 'Gregory David Roberts', 599, 389, 35, 32, 'Little, Brown Book Group', '1', 'Biographies and Auto Biographies', '', 'English', 944, 640),
('BIO-12', 'Courage And Conviction : An Autobiography', 'Kunal Verma, VKSingh', 595, 387, 30, 11, 'Aleph Book Company', '1', 'Biographies and Auto Biographies', 'Summary\r\n\r\nThe book is his about his journey in the Indian Army and his distinguished career, which saw him on the front lines of combat in the Indo-Pak War of 1971. The readers get a good insight and some untold stories of his experiences in the war. He was also a part of the Peace Keeping Force sent to Sri Lanka. General V. K. Singh has always been blatantly honest about his views and in the book he writes about instances when he had to take a firm stand on many issues, from deployment of the army against the Maoists to procurement of arms.\r\n\r\nV. K. Singh was trained at the National Defence Academy and the Indian Military Academy. He has served in some of the most crucial and important regions of the country. He recalls his early days in the Army when he was appointed as the company commander on the LOC in Poonch, to his later of days when he was commanding and leading the most elite regiments in Jammu and Kashmir and the vast eastern Command. He also writes about his experiences in military operations like the Blue Star movement and Brasstacks and Trident. His life story is truly inspirational and makes an amazing read. He has been very direct, compelling and sometimes a little controversial in this book and has never been afraid to stand by his convictions.', 'English', 396, 500),
('ACA-1', 'Getting A Coding Job For Dummies', 'Nikhil Abraham', 299, 289, 3, 1, 'Wiley', '1', 'Academic and Professional', 'Nikhil Abraham helped millions of people prepare for the coding job market in his past role at Codecademy. That site set 25 million users on the road to gaining the skills to taking part in the explosion of coding jobs. He also helped launch ReSkillUSA, a Codecademy extension that aids people in gaining the skills to start a coding career. Nik now focuses on corporate coding training and seminars. He is author of Coding For Dummies.\r\n\r\nAbout The Author\r\n\r\nYour friendly guide to getting a job in coding \r\nGetting a Coding Job For Dummies explains how a coder works in (or out of) an organization, the key skills any job requires, the basics of the technologies a coding pro will encounter, and how to find formal or informal ways to build your skills. Plus, it paints a picture of the world a coder lives in, outlines how to build a resume to land a coding job, and so much more.\r\n\r\nCoding is one of the most in-demand skills in today\'s job market, yet there seems to be an ongoing deficit of candidates qualified to take these jobs. Getting a Coding Job For Dummies provides a road map for students, post-grads, career switchers, and anyone else interested in starting a career in coding. Inside this friendly guide, you\'ll find the steps needed to learn the hard and soft skills of coding and the world of programming at large. Along the way, you\'ll set a clear career path based on your goals and discover the resources that can best help you build your coding skills to make you a suitable job candidate.\r\nCovers the breadth of job opportunities as a coder\r\nIncludes tips on educational resources for coders and ways to build a positive reputation\r\nShows you how to research potential employers and impress interviewers\r\nOffers access to online video, articles, and sample resume templates\r\n\r\nIf you\'re interested in pursuing a job in coding, but don\'t know the best way to get there, Getting a Coding Job For Dummies is your compass!', 'English', 296, 500),
('ACA-2', 'What Next? A Complete Course & Career Guide After Class 12 In Delhi NCR', 'Times Group Experts', 149, 118, 24, 3, 'Times Group Books', '1', 'Academic and Professional', 'Everybody looks forward to enjoying college life after passing school. However, selecting the right career option is one of the most difficult decisions for a student. Almost all of us go through this dilemma after passing class 12th exams. While some are aware of the courses available and the right approach to go for it to reach their career goals, while others are clueless about the courses or the colleges to take admission in.Today, there are lot many options for class XII pass outs, in which they can pursue their graduation. However, there are no safe careers as such. One will do well in life if they follow their interest. The course one selects for graduation is the stepping stone towards building his/her career, so whatever course one chooses, it must be in accordance to his/her passion. Also, the course one chooses must assure a good scope for career options. Select a field that has chances of growth in the future. Countercheck all the details about the course and its significance in the industry. It happens often that we are misled by the opinions of others and take wrong decisions, so make sure you do not fall prey to any kind of pre-conceived assumptions. College will get over in three years but the course will stay forever. Its also better to get a general undergraduate degree than go for a programme that restricts future options, if ones unsure where ones heart lies. If a student has an interest in more than one course, they should choose the one that has a broader scope. The possibility of doing post-graduation in that subject is then higher, since fewer seats are available at the postgraduate level. Students should always take admission in the first college if he/she gets an opportunity to do so. With every list, the options would increase and with it the liberty to switch colleges and get admission in ones preferred college. When it comes to choosing between a course and a college, the emphasis should be firmly on the first. It doesnt make much of a difference which college a student gets an undergraduate degree from but the course will matter.It is important that students choose a suitable stream in class 12 to ensure that they are able to join a career of their choice after passing the 12th exams. Those with a humanities or arts background can qualify for a variety of creative courses. While choosing a professional or an academic course, students must be sure about their career plans. Courses in fashion design, mass communication, advertising hotel management, performing arts, travel and tourism are some options which offer lucrative career opportunities. Also, foreign language courses are on a high demand.There are a lot of career options for those with a commerce stream. Apart from chartered accountancy, which happens to be the foremost career goal for students, company secretary, BBM, BBA, etc., are some of the courses opted by students at graduation level.There are hundreds of career options for students with science stream. One of the major advantages as to why students take up science is that they can switch to humanities or even commerce later on.Further, outside the ambit of schools and colleges, students can also take up courses in fashion technology, jewellery design, aviation, video jockey, etc. It is important to get into a career of ones choice to enjoy work.This book has information for students who have passed the senior secondary examination (Class XII) or an equivalent examination and wishes to seek admission to various undergraduate courses. Details of courses offered, minimum eligibility conditions and admission procedure are outlined in the book. Effort has been made to summarize all vital information for the convenience of the students.', 'English', 168, 500),
('ACA-3', 'Iit Foundation For Class-X Science', 'GKP', 425, 298, 30, 12, 'G.K Publication', '1', 'Academic and Professional', '', 'English', 456, 500),
('ACA-4', 'Research Analytics', 'Ajay Kumar Chauhan', 489, 426, 13, 11, 'Dreamtech Press', '1', 'Academic and Professional', 'This book is specially designed to explain the basic fundamentals of analytics required for research projects. The book is extremely helpful for students who want to make their career in the area of analytics and data science. It not only covers the basic concepts of statistics required for data analytics but also explains advance topics of analytics such as structural equation modeling and panel data analytics in detail. The book also guides research students who need to conduct data analysis in their research projects.', 'English', 348, 500),
('ACA-5', 'Get a Grip on Grammar', 'Scholastic Experts', 250, 188, 25, 2, 'Scholastic', '1', 'Academic and Professional', 'Here s a book which, through different kinds of exercises, will help students get a surer grip on the English language.', 'English', 430, 500),
('ACA-6', 'Practical Business Analytics Using Sas-A Hands-On Guide', 'Kadre', 799, 711, 11, 31, 'Apress', '1', 'Academic and Professional', '', 'Others', 451, 500),
('ACA-7', 'Engineering Physics 1st Edition', 'Sujeet Chaturvedi, Brijesh Kumar Pandey', 525, 386, 26, 41, 'Cl', '1', 'Academic and Professional', 'Engineering Physics covers all topics taught to the first-year undergraduate students of all engineering disciplines offered by various Indian universities. This book is written in a precise, systematic, and easy-to-understand language. The structure of each chapter redefines the parameters of conceptual learning through solved examples, numerical and theoretical questions, multiple choice questions, and fill in the blanks. Conceptual arguments lead to the mathematical formulae providing a coherent mix of physics and mathematics.\r\n\r\nKey Features\r\n\r\nCovers syllabic of almost all Technological Universities in India\r\n\r\nIncludes fundamentals of engineering materials and new engineering materials\r\n\r\nProvides several numerical problems asked in the examinations of different technological universities as solved examples\r\n\r\nIncludes formulae and highlights for the chapter at a glance\r\n\r\nFigures and diagrams illustrate the complex phenomena in the simplest manner\r\n\r\nIncludes numerous solved examples for better understanding of the fundamental concept of physics', 'English', 892, 500),
('ACA-8', 'Chemistry For JEE Main And Advanced 2016 (Combo Set Of 3 Books)', 'Sudarsan Guha, M S Chouhan, Wiley Editorial Team', 2157, 1850, 14, 3, 'Wiley', '1', 'Academic and Professional', 'This is a combo of three books J D Lee Concise Inorganic Chemistry for JEE Main & Advanced 2016, Solomons & Fryhle?s Organic Chemistry for JEE Main & Advanced 2016 and Wiley Physical Chemistry for JEE Main & Advanced 2016. This book is an adaptation of the classic book Concise Inorganic Chemistry by J.D. Lee (fifth edition) which is widely used by students preparing for JEE. This adapted version provides a more concise treatment of the subject as per JEE syllabus requirements but does not compromise on essentials. This adapted version of one of the world?s most successful and popular books combines the Solomons and Fryhle approach to Organic Chemistry with JEE (Main & Advanced) requirements and is now a part of Wiley?s Maestro Series. The book is aimed at the three problem areas of Organic Chemistry - problem-solving, visualization of structures and understanding of mechanisms. The book is rich in conceptual strength and enriched with problem-solving tools and assessment that makes it a one-stop solution for JEE (Main & Advanced) aspirants. It provides a sound foundation in fundamentals of chemistry upon which theoretical models are constructed. It captures the fundamentals of the subject in a simple and logical framework of factual knowledge.', 'English', 1299, 500);
INSERT INTO `products` (`PID`, `Title`, `Author`, `MRP`, `Price`, `Discount`, `Available`, `Publisher`, `Edition`, `Category`, `Description`, `Language`, `page`, `weight`) VALUES
('ACA-9', 'Mechanics Of Materials', 'Timothy A. Philpot', 649, 532, 18, 12, 'Wiley', '1', 'Academic and Professional', 'It presents the theory and practice of mechanics of materials in a straight-forward, plain-speaking, student-friendly manner that addresses the learning styles of today\'s students without sacrificing rigor or depth in the presentation of topics. Unique to this book is the integration of MecMovies. This award-winning instructional software package created by the author provides extensive hands-on practice and feedback to students as they become familiar with a wide variety of concepts and applications, from stress and strain to bending, torsion, transverse shear and combined loads. \r\n\r\nStress \r\nStrain \r\nMechanical Properties of Materials \r\nDesign Concepts \r\nAxial Deformation \r\nTorsion \r\nEquilibrium of Beams \r\nBending \r\nShear Stress in Beams \r\nBeam Deflections \r\nStatically Indeterminate Beams \r\nStress Transformations \r\nStrain Transformations \r\nThin-Walled Pressure Vessels \r\nCombined Loads \r\nColumns \r\nEnergy Methods ', 'English', 896, 500),
('ACA-10', 'Python For Data Science For Dummies', 'John Paul Mueller;Luca Massaron', 599, 589, 2, 13, 'Wiley', '1', 'Academic and Professional', 'This book is designed for beginners to data analysis and covers the basics of Python data analysis programming and statistics. It covers the Python fundamentals that are necessary to data analysis, including objects, functions, modules and libraries. The libraries that are integral to data science are explored and explained, including NumPy, SciPy, BeautifulSoup, Pandas and MatPlobLib. \r\n\r\nTable of Contents\r\n\r\nIntroduction \r\nAbout This Book \r\nFoolish Assumptions \r\nIcons Used in This Book \r\nBeyond the Book \r\nWhere to Go from Here ', 'English', 440, 500),
('ACA-11', 'Data Science And Big Data Analytics', 'Emc Education Services', 1999, 1779, 11, 12, 'Wiley India', '1', 'Academic and Professional', 'Data Science & Big Data Analytics educates readers about what Big Data is and how to extract value from it. The book covers methods and technologies required to analyze structured and unstructured datasets, as more individuals and organizations build out their capabilities to analyze Big Data and draw insights from it. Additional focus areas include machine learning, data visualization and presentation skills. The book provides practical foundation level training that enables immediate and effective participation in big data and other analytics projects. It provides grounding in basic and advanced analytic methods and an introduction to big data analytics technology and tools, including MapReduce and Hadoop.', 'English', 432, 500),
('ACA-12', 'Professional AngularJS', 'Valeri Karpov, Diego Netto', 599, 533, 11, 11, 'Wiley India', '1', 'Academic and Professional', 'AngularJS was recently called the \"Super-heroic JavaScript MVW Framework\" by The Code Project. It\'s an open source client side framework maintained by Google that greatly simplifies frontend development, making it easy and fun to write complex web apps. The online documentation and existing books on the subject lack simple explanations of some of the more advanced concepts, and how they work together. As a result, many developers get used to the basic concepts of AngularJS fairly quickly, but struggle when it comes to building more complex (real world) applications. ', 'English', 396, 500),
('CHILD-1', '365 Bedtime Stories', 'OM books', 450, 284, 37, 12, 'Om Books International', '1', 'Children and Teens', '', 'English', 220, 500),
('CHILD-2', '365 Stories For Girls', 'Om Books', 450, 284, 37, 12, 'Om Books International', '1', 'Children and Teens', '', 'English', 236, 500),
('CHILD-3', 'Chacha Chaudhary Set of 5 Digests', 'Cartoonist Pran', 559, 549, 2, 19, 'Diamond Comic', '1', 'Children and Teens', 'Chacha Chaudhary Gift Pack a collection of Digest Comics in English.', 'English', 340, 500),
('CHILD-4', '365 Tales Of Indian Mythology', 'Om Books International', 450, 284, 37, 11, 'Om Books International', '1', 'Children and Teens', '', 'English', 220, 500),
('CHILD-5', '365 Panchatantra Stories', 'Om Books', 450, 284, 37, 12, 'Om Books International', '1', 'Children and Teens', '', 'English', 220, 500),
('CHILD-6', 'Diary of a Wimpy Kid: Rodrick Rules', 'Jeff Kinney', 299, 194, 34, 12, 'Penguin Books', '1', 'Children and Teens', '', 'English', 224, 500),
('CHILD-7', 'The Adventures Of Stoob : A Difficult Stage', 'Rupa Books', 195, 144, 26, 4, 'Rupa Publication', '1', 'Children and Teens', 'Stoob is headed for an amazing global stardom incident but sinister forces lurk as always between him and ultimate glory.Stoob is in class six and his days of childhood are over. He has discovered his inner star and is all set to take Hollywood by storm-but first he has to audition for a part in the school play based on the hit childrens TV series Teen Rama Adventurezzz. Unfortunately the channel executive a villainous suit casts him as a table. Fortunately there are wheels within wheels and he ends up playing the Rakshas Hero.Super shenanigans occur onstage and off as Stoob finds both his acting and romantic career under siege. Will he be able to save the play from a terrible fate? Will Ishani Radhika Yash and Sid keep their heads and play their parts to perfection? Will momo-sir and the beauteous Ms. Devraj come to the rescue or will Stoob be branded as a future criminal for all time? And what message does Wolverfluff the dog hold for Stoob?Find out as Stoob undertakes a scheme of literally epic proportions in his second hilarious adventure.About the AuthorSamit Basu is a writer of books films and graphic novels. His first novel the Simoqin prophecies (2003) was the first book in the bestselling gameworld trilogy and marked the beginning of Indian English fantasy writing he has also written the international award-winning superhero novel turbulence and the recently published graphic novel Local Monsters. Forthcoming from Red Turtle are books in the adventures of stoob series and the next book in the morningstar agency series.', 'English', 195, 500),
('CHILD-8', 'The Kingdom of Fantasy (Book - 1)', 'Geronimo Stilton', 599, 357, 35, 4, 'Scholastic Inc', '1', 'Children and Teens', '', 'English', 314, 612),
('CHILD-9', '365 Stories For Boys', 'Om Books', 450, 284, 37, 9, 'Om Books International', '1', 'Children and Teens', '', 'English', 540, 500),
('CHILD-10', '365 Wonders Of The World', 'Om Books', 450, 284, 37, 4, 'Om Books International', '1', 'Children and Teens', '', 'English', 236, 500),
('CHILD-11', '365 Animal Tales', 'Om Books', 450, 284, 37, 6, 'Om Books International', '1', 'Children and Teens', '', 'English', 220, 500),
('CHILD-12', 'GERONIMO STILTON #49 THE WAY OF THE SAMURAI', 'Geronimo Stilton', 295, 188, 36, 4, 'Scholastic Paperbacks', '1', 'Children and Teens', '', 'English', 106, 500),
('REG-1', 'Madhusala', 'Harivansh Rai Bachchan', 100, 65, 35, 12, 'Neha Publishers & Distributors', '6', 'Regional Books', '', 'Hindi', 77, 100),
('REG-2', 'Ayurvediya Garbha Sanskar', 'Balaji Tambe', 670, 463, 4, 8, 'Sakal Publications', '1', 'Regional Books', 'This Marathi book provides details of prenatal and post natal care for the pregnant woman and her child, based on Ayurvedic systems and practices. Summary Of The Book Ancient Indian practices prescribed a holistic care for the mother-to-be, to ensure her health and the health of her unborn child. Emphasis was placed on taking care of the pregnant woman in all aspects that included her physical, mental, psychological, and spiritual health. The environment surrounding the pregnant woman, the experiences she goes through, her own actions and attitudes, her physical and mental conditions, the words she hears, the music she listens to, everything is considered to have an impact on the embryo. In fact, this book starts with preparations before conception. It gives instructions and therapies that, if followed, help the woman achieve a perfect balance in her body and mind, to help her conceive, and then give birth to a healthy child. The book contains instructions for everything from reading materials, to subjects to be discussed, music and mantras that should be heard by the woman, her food and nutrition needs, and every other aspect that needs care. This book helps the couple right from the stage of planning and preparing for conceiving a child, to the care to be taken throughout the pregnancy, and the care to be met out after child birth. The ancient practices of Ayurveda describe a complete system of therapies for ensuring the mother s health and the child s health, personality, and intellect. This book contains details of Ayurvedic concepts and medicines for pregnancy, diet, and Yoga before, during, and after pregnancy. It enlists the daily practices that can enhance the overall health of the child in the womb, the importance of music, the choice of music during pregnancy, and natural diet and therapies that can help the woman get back in shape after child birth. The book details therapies and practices for complete child care and care for the mother. This book is a trusted text based on ancient medical practices. This Marathi Edition was published in 2007 and has sold over a hundred thousand copies. About Balaji Tambe Dr. Balaji Tambe is one of the world s foremost experts in Ayurvedic medicine, and Yoga and Music therapies. His book, Ayurvedic Garbh Sanskar was originally published in Marathi. It has also been published in English. This book contains extensive information on therapies and practices to be followed before, during, and after pregnancy. Dr. Tambe has been a pioneer in the field of Ayurvedic medicine and Yoga. He is the Founder of the Atmasantulana Village, established in 1982. It has since become one of the largest Ayurvedic healing centers. His Vedic Community Health Concept was selected by the EXPO 2000 in Hanover, Germany, as the ideal health vision for the new millennium.', 'Marathi', 224, 500),
('REG-3', 'Ikshvaku Ke Vanshaj', 'Amish Tripathi', 295, 207, 30, 9, 'Westland', '1', 'Regional Books', '3400 Esapurva, Bharat Aalgaon mein Ayodhya kamjor ho chuki thi. Ek Bhayankar yudh apna kar vasool raha tha. Nuksan bahut gehra tha. Lanka ka rakshash Raja Ravan parajeet rajyon par apna shashan lagu naki karta tha.Balki wah waha ke vapyar ko niyantrit karta tha.Samjrajya se sara Dhan chus lena uski neeti thi.Jisse SaptaSindhu ki praja nirdhanta,avsaad aur duracharan mein ghir gayi.Unhe kisi aisi neta ki jarurat thi,jo unhe daldal se bahar nikal sake.Neta unme se hi koi hona chahiye tha.Koi aisa jise wo jante ho.Ek santapt aur nishkasit Rajkumar.Ek Rajkumar jo is antraal ko bhar sake.Ek Rajkumar jo RAM kehlayein.Wah apne desh se pyar karte hai.Bhale hi uski vaasi unhe Pratadit kare.Wah nyay ke liye akele khade hai.unke Bhai(LAXMAN) unki patni(SEETA) aur wah khud iss Andhakar ke shamashaq Dhrudh hai.Kya RAM uss Lanchan se upar uth payenge,Jo dusro ne unn par lagaye the?Kya SEETA ke prati unka Pyar,Sangharsho mein unhe thaam lega?Kya wah uss Rakshash ka khatma Kar payenge,jisne unka bachpan tabah kiya?Kya wah Vishnu ki Neeti Par khara utrenge?AMISH ki nayi SERIES Z RAMCHANDRA SHRUNKHALA Ke sath ek aur Aithisahik Safar ki shurwat karte hain.', 'English', 376, 500),
('REG-4', 'Chanakya Mantra', 'Ashvin Sanghi', 195, 137, 30, 6, 'Westland Publisher', '1', 'Regional Books', '', 'Hindi', 502, 500),
('REG-5', 'The Secret Of The Nagas', 'Amish Tripathi', 225, 146, 35, 9, 'Westland Publisher', '1', 'Regional Books', 'Today He is a God.4000 years ago He was just a man.The hunt is on. The sinister Naga warrior has killed his friend Brahaspati and now stalks his wife Sati. Shiva the Tibetan immigrant who is the prophesied destroyer of evil will not rest till he finds his demonic adversary. His vengeance and the path to evil will lead him to the door of the Nagas the serpent people. Of that he is certain.The evidence of the malevolent rise of evil is everywhere. A kingdom is dying as it is held to ransom for a miracle drug. A crown prince is murdered. The Vasudevs – Shiva’s philosopher guides – betray his unquestioning faith as they take the aid of the dark side. Even the perfect empire Meluha is riddled with a terrible secret in Maika the city of births. Unknown to Shiva a master puppeteer is playing a grand game.In a journey that will take him across the length and breadth of ancient India Shiva searches for the truth in a land of deadly mysteries – only to find that nothing is what it seems.Fierce battles will be fought. Surprising alliances will be forged. Unbelievable secrets will be revealed in this second book of the Shiva Trilogy the sequel to the #1 national bestseller The Immortals of Meluha.About The AuthorAmish Tripathi is a 36-year-old IIM (Kolkata) educated boring banker turned happy author. The success of his debut book The Immortals of Meluha (Book 1 of the Shiva Trilogy) encouraged him to give up a fourteen year old career in financial services to focus on writing. He is passionate about history mythology and philosophy. He believes there is beauty and meaning in all world cultures and religions. The Secret of the Nagas is the second book of the Shiva Trilogy.Amish lives in Mumbai with his wife Preeti and son Neel. He is presently working on the third book of the Shiva Trilogy The Oath of the Vayuputras. # The hunt is on. The sinister Naga warrior has killed his friend Brahaspati and now stalks his wife Sati. Shiva the Tibetan immigrant who is the prophesied destroyer of evil will not rest till he finds his demonic adversary. His vengeance and the path to evil will lead him to the door of the Nagas the serpent people. Of that he is certain. # The evidence of the malevolent rise of evil is everywhere. A kingdom is dying as it is held to ransom for a miracle drug. A crown prince is murdered. The Vasudevs – Shiva’s philosopher guides – betray his unquestioning faith as they take the aid of the dark side. Even the perfect empire Meluha is riddled with a terrible secret in Maika the city of births. Unknown to Shiva a master puppeteer is playing a grand game. # In a journey that will take him across the length and breadth of ancient India Shiva searches for the truth in a land of deadly mysteries – only to find that nothing is what it seems. # Fierce battles will be fought. Surprising alliances will be forged. Unbelievable secrets will be revealed in this second book of the Shiva Trilogy the sequel to the #1 national bestseller The Immortals of Meluha. # About The AuthorAmish Tripathi is a 36-year-old IIM (Kolkata) educated boring banker turned happy author. The success of his debut book The Immortals of Meluha (Book 1 of the Shiva Trilogy) encouraged him to give up a fourteen year old career in financial services to focus on writing. He is passionate about history mythology and philosophy. He believes there is beauty and meaning in all world cultures and religions. The Secret of the Nagas is the second book of the Shiva Trilogy. # Amish lives in Mumbai with his wife Preeti and son Neel. He is presently working on the third book of the Shiva Trilogy The Oath of the Vayuputras.', 'Hindi', 422, 500),
('REG-6', 'Vayuputrom Ki Shapath : Shiva Rachna Traya 3 (Hindi)', 'Amish Tripathi', 295, 191, 35, 7, 'Westland Publisher', '2', 'Regional Books', '', 'Hindi', 540, 500),
('REG-7', 'Chooa Aasmaan', 'Arun Tiwari', 125, 84, 33, 6, 'Manjul Publishing House', '2', 'Regional Books', 'Wings Of Fire - An Autobiography is the autobiography of the scientist and former President of India, Dr. A. P. J. Abdul Kalam. The book begins with describing his early years, and culminates with his role in the nuclear missile test that led him to be known as theMissile Man of India. The main content of the book is divided into four sections. The first is Orientation, the second is Creation, the third is Propitiation, and the fourth, Contemplation. Each section covers a stage in the life of Dr. Kalam. Orientation covers his early years. It begins with his birth into a middle class Tamil family in Rameshwaram and covers his schooling and graduation. It ends with his 6-month training program at NASA. The section Creation traces a period of 17 years, from 1963 to 1980. It show his transformation into a scientist of high repute. This section covers the time he spent at various NASA facilities in The US, including the Langley Research Center. Propitiation covers the period from 1981 to 1991, and traces the development of the nuclear missiles. Contemplation covers the period after this. The book has 24 photographs associated with the life of Dr. Kalam. Wings Of Fire - An Autobiography has been translated into various regional languages, including Tamil, Malayalam, Kannada, and Marathi. It has also been translated into Chinese.\r\n\r\nA. P. J. Abdul Kalam is a scientist who is renown for his association with the Pokhran II nuclear tests. Other books by Dr. Kalam Include India 2020: A Vision for the New Millennium and You Are Unique. Dr. Kalam played an important role in the organizational, political, and technical phases of the development of the nuclear missiles. He served as the President of India from 2002 to 2007. He has received several awards including the Padma Bhushan, Padma Vibhushan, and Bharat Ratna from the government of India.', 'Hindi', 125, 200),
('REG-8', 'Half Girlfriend', 'Chetan Bhagat', 176, 116, 34, 5, 'Rupa Publication', '1', 'Regional Books', 'Once upon a time, there was a Bihari boy called Madhav. He fell in love with a girl from Delhi called Riya. Madhav didn t speak English well. Riya did. Madhav wanted a relationship. Riya didn t. Riya just wanted friendship. Madhav didn t. Riya suggested a compromise. She agreed to be his half girlfriend. m\r\n\r\nFrom the author of the blockbuster novels Five Point Someone, One Night @ the Call Center, The 3 Mistakes of My Life, 2 States and Revolution 2020 comes a simple and beautiful love story that will touch your heart and inspire you to chase your dreams.', 'Hindi', 290, 500),
('REG-9', 'Bharat Ki Rajvyavastha', 'M Laxmikanth', 490, 314, 36, 6, 'McGraw Hill Education', '4', 'Regional Books', 'M LaxmikanthÂ’s Bharat Ki Rajvyavastha is a comprehensive book and novel in Hindi for candidates preparing for the Civil Services Exams. The book comprises chapters on public administration and Indian polity. In addition the book also has a plethora of information about the various policies of the Indian government and their implementation. The book is written in a concise and lucid manner and provides a broad range of information on Indian polity. This book is essential for candidates applying for the civil services exam and it can also be used by academicians educators researchers and students to enhance their knowledge of the subject.\n\nAbout M Laxmikanth\n\nM Laxmikanth is an Indian author who has authored many books on Indian government and politics such as Public Administration Indian Polity Governance in India for UPSC Civil Services Preliminary Examination (Paper - I) etc.', 'Hindi', 784, 500),
('REG-10', 'Meluha Ke Mrityunjay (Marathi)', 'Amish', 295, 215, 27, 6, 'Westland Publisher', '4', 'Regional Books', '', 'Marathi', 488, 500),
('BUS-4', 'Indian Economy', 'Ashwani Mahajan;K P M Sundharam;Ruddar Dutt', 699, 670, 4, 10, 'S.Chand Publisher', '70', 'Business and Management', 'Datt & Sundharam Indian Economy gives a complete and holistic picture of the economic condition of India.Summary Of The BookThe Indian Economy is extremely complex. With its different classes and types of people, defining one economic policy for the entire country becomes extremely difficult. Datt & Sundharam Indian Economy provides a keen insight into all aspects of the complex nature of the Indian Economy.The book is divided into five parts. The first part focuses on the nature of the Indian Economy and the second about Planning and Economic Development. The third section talks about Agriculture in the National Economy including discussions on Land Reform and Rural Credit, and the fourth focuses on Indian Industries including Large Scale and Small Scale Industries. The fifth section talks about the Tertiary Sector of the Indian Economy.The Indian Economy moves at an extremely fast pace. This requires books on the Indian Economy to constantly update their content. The revised edition of Datt & Sundharam Indian Economy contains contains a new chapter on the Twelfth Five Year Plan (2012-17). The old chapters have also been extensively revised. The book also has a few new sections added, and includes the Union Budget 2010-11, the Trade negotiations Update, and Estimates of the 4th All India Census of MSMEs, to name a few.Datt & Sundharam Indian Economy talks about all the aspects and problems of the Indian Economy. It talks about how this large economy functions and how its different aspects are managed. It also talks about interactions between the various industries within the country and interactions of the Indian Economy with other countries. The book has taken its statistical data from non-government, and government reports, and journals.About The AuthorsAshwani Mahajan is currently an Associate Professor of Economics at DAV PG College, the University of Delhi.His books include Agricultural Economics, Environmental Economics and Teaching of Economics.He has published a number of papers and participated in a number of academic conferences.Gaurav Dutt is an Associate Professor and Deputy Director at Monash University Australia.His other published book is Bargaining Power, Wages and Employment: An Analysis of Agricultural Labor Markets in India.He has many years of varied experiences in the field of Economics. He has published many papers in acclaimed international journals such as the World Bank Economic Review, Economic and Political Weekly and Journal of Development Studies. # PART I-STRUCTURE OF THE INDIAN ECONOMYIndia as a Developing EconomyIndian Economy on the Eve of IndependenceNational Income of IndiaHuman Resources and Economic Development Human Development in IndiaOccupational Structure and Economic DevelopmentNatural Resources, Economic Development and Environmental DegradationInfrastructure in the Indian EconomySocial Infrastructure and Social SectorPART II-PLANNING AND ECONOMIC DEVELOPMENTObjectives and Strategy of Economic Planning in IndiaIndustrial Policy and Indian PlanningPublic Sector and Indian PlanningDisinvestment of Public EnterprisesRedefining the Role of the StatePrivatisation and Economic ReformsGlobalization and its Impact on IndiaPlanning Experience in IndiaTenth Five Year Plan (2002-07)Eleventh Five Year Plan and Inclusive GrowthAn Approach to the Twelfth Five Year Plan (2012-17)The Problem of Capital FormationForeign Capital, Foreign Aid and Economic DevelopmentPoverty and the Planning Process in IndiaThe Parallel Economy in IndiaUnemployment in IndiaInequality and Economic Power in IndiaPrices, Price Policy and Economic GrowthBalanced Regional DevelopmentPART III-AGRICULTURE IN THE NATIONAL ECONOMYIndian Agriculture under the Five Year Plans : The Green RevolutionFood Security in IndiaIrrigation and Other Agricultural InputsLand ReformsSize of Farms and Productive EfficiencyOrganisation of Rural Credit in IndiaAgricultural Marketing and WarehousingAgricultural LabourPART IV-INDIAN INDUSTRIESIndustrial Pattern and the PlansSome Large-Scale IndustriesInformation Technology (IT) IndustrySmall-Scale EnterprisesLabour Problems and Labour PolicyUnorganised Sector and Informalisation of the Indian EconomySecond National Commission on LabourPART V-THE TERTIARY SECTOR IN THE INDIAN ECONOMYThe Foreign Trade of IndiaIndia\'s Balance of PaymentsSpecial Economic ZonesGATT, WTO and India\'s Foreign TradeIndian Currency SystemIndian Financial System : Commercial Banking SystemIndian Financial System II: Money and Capital Markets in IndiaThe Reserve Bank of India and Monetary Management Indian Public FinanceFinancial Relations Between the Centre and the States Thirteenth Finance Commission (2010-15)Government Subsidies in IndiaAbbreviations # The Indian Economy is extremely complex. With its different classes and types of people, defining one economic policy for the entire country becomes extremely difficult. Datt & Sundharam Indian Economy provides a keen insight into all aspects of the complex nature of the Indian Economy. # The book is divided into five parts. The first part focuses on the nature of the Indian Economy and the second about Planning and Economic Development. The third section talks about Agriculture in the National Economy including discussions on Land Reform and Rural Credit, and the fourth focuses on Indian Industries including Large Scale and Small Scale Industries. The fifth section talks about the Tertiary Sector of the Indian Economy. # The Indian Economy moves at an extremely fast pace. This requires books on the Indian Economy to constantly update their content. The revised edition of Datt & Sundharam Indian Economy contains contains a new chapter on the Twelfth Five Year Plan (2012-17). The old chapters have also been extensively revised. The book also has a few new sections added, and includes the Union Budget 2010-11, the Trade negotiations Update, and Estimates of the 4th All India Census of MSMEs, to name a few. # Datt & Sundharam Indian Economy talks about all the aspects and problems of the Indian Economy. It talks about how this large economy functions and how its different aspects are managed. It also talks about interactions between the various industries within the country and interactions of the Indian Economy with other countries. The book has taken its statistical data from non-government, and government reports, and journals. # About The Authors # Ashwani Mahajan is currently an Associate Professor of Economics at DAV PG College, the University of Delhi. # His books include Agricultural Economics, Environmental Economics and Teaching of Economics. # He has published a number of papers and participated in a number of academic conferences. # Gaurav Dutt is an Associate Professor and Deputy Director at Monash University Australia. # His other published book is Bargaining Power, Wages and Employment: An Analysis of Agricultural Labor Markets in India. # He has many years of varied experiences in the field of Economics. He has published many papers in acclaimed international journals such as the World Bank Economic Review, Economic and Political Weekly and Journal of Development Studies. # PART I-STRUCTURE OF THE INDIAN ECONOMY # PART II-PLANNING AND ECONOMIC DEVELOPMENT # PART III-AGRICULTURE IN THE NATIONAL ECONOMY # PART IV-INDIAN INDUSTRIES # PART V-THE TERTIARY SECTOR IN THE INDIAN ECONOMY', 'English', 1068, 500),
('REG-11', 'Asura: Tale Of The Vanquished', 'Anand Neelakantan', 250, 168, 33, 4, 'Manjul', '3', 'Regional Books', 'In this bestseller, Neelakantan tries to break the age old tradition where history is always narrated by the victors. Asura - Tale Of The Vanquished dares to narrate the tale of the Asura people. Blending mythology, religion and history, the book narrates the tale from Ravana and Bhadra\'s perspective.The book talks about how the Asura community is more liberal than the orthodox Deva clan, which was highly biased. It also attacks the evil practices of the Brahmin caste. From the tale of Mahabali, Vamana and Sitas Agni-Pareeksha, to Jatayus meeting with Ravana, the author reveals the many human emotions behind these stories and logically presents a new perspective for the readers.How wrong was Ravana to challenge the mighty gods for his daughter\'s sake? Was he evil for deciding to lead life in his own terms? Was he wrong for freeing the people from the caste-cased Deva reign? The author takes the readers on an enthralling journey and poses many such complex questions.Bhadra is a creative character who gives voice to the common man, who is lost amidst the villains and heroes. The author has been appreciated for his eye for detail, which gives life to his work. The right blend of good language and interesting twists keeps the book engaging. Published in 2012, the book has topped many bestseller lists including the 2012 Crossword and the bestseller list of CNN IBN.', 'Telugu', 464, 500),
('REG-12', 'Revolution 2020', 'Chetan Bhagat', 225, 149, 34, 5, 'Rupa Publications', '3', 'Regional Books', '', 'Hindi', 356, 500),
('BUS-2', 'PROJECTS', 'Chandra Prasanna', 625, 500, 20, 4, 'McGraw Hill Education', '8', 'Business and Management', NULL, 'English', 744, 500),
('BUS-3', 'Advanced Bank Management For CAIIB', 'India Institute Of Banking & Finance Experts', 520, 438, 16, 18, 'India Institute Of Banking & Finance', '1', 'Business and Management', NULL, 'Others', 488, 500),
('BUS-1', 'Project Management : The Managerial Process', 'Clifford F. Gray, Erik W. Larson,Gawtam V. Desai', 725, 595, 18, 5, 'McGraw Hill Education', '6', 'Business and Management', NULL, 'English', 961, 500),
('BUS-5', 'Fundamentals Of Business Economics', 'BS Publications;BSP Books Experts', 995, 896, 10, 14, 'BS Publications;BSP Books', '2', 'Business and Management', NULL, 'English', 295, 500),
('BUS-6', 'Quality Assurance And Quality Management', 'Anjaneyulu Y', 450, 428, 5, 17, 'PharmaMed Press;BSP Books', '2', 'Business and Management', NULL, 'English', 362, 500),
('BUS-7', 'Next Generation Librarianship Strategies For Change Management', 'Ramaiah L. S.', 495, 470, 5, 12, 'BS Publications;BSP Books', '2', 'Business and Management', NULL, 'English', 355, 500),
('BUS-8', 'Consumer Behaviour', 'Schiffman', 675, 496, 27, 12, 'Pearson', '10', 'Business and Management', 'Consumer Behavior is the text that set the standard for consumer behavior study. The book explores how the examination and application of consumer behavior is central to the planning, development, and implementation of marketing strategies. The tenth edition captures the impact of new media on consumer behavior and focuses on the marketers ability to learn more about customers purchases in order to implement a strategy with greater precision. In this edition, Professor Ramesh Kumar has added extensive cases, discussions, and examples relevant to Indian consumers and markets, creating a global perspective and making this pioneering textbook even more interesting to Indian students.\r\n\r\nSalient Features\r\n\r\nEnd-of-chapter cases�Case studies appear at the end of every chapter. These show students the real-life application of the concepts just covered so that they can understand how real companies use consumer behavior to create marketing strategies.\r\n\r\nCoverage of new media�Consumers today are increasingly impacted by the growing influence of new media. The tenth edition addresses this influence by providing students with new and extensive coverage of the use of new media in creating more effective targeting strategies.\r\n\r\nFocus on global coverage�Discussions and examples appear throughout the text, demonstrating the importance of cultural differences in both domestic and multinational marketing.\r\n\r\nDetailed coverage of Indian markets�Since consumer behavior is often culture-specific, the peculiarities of Indian culture and values that affect marketing strategies, as well as the nature of Indian markets, have been discussed in depth. Marketing strategies of many Indian brands over the decades have been discussed as examples and cases.#Part I: Introduction\r\n\r\nConsumer Behavior: Meeting Changes and Challenges\r\n\r\nThe Consumer Research Process\r\n\r\nMarket Segmentation and Strategic Targeting\r\n\r\nPart II: The Consumer as an Individual\r\n\r\nConsumer Motivation\r\n\r\nPersonality and Consumer Behavior\r\n\r\nConsumer Perception\r\n\r\nConsumer Learning\r\n\r\nConsumer Attitude Formation and Change\r\n\r\nCommunication and Consumer Behavior\r\n\r\nPart III: Consumers in their Social and Cultural Settings\r\n\r\nThe Family and Social Class\r\n\r\nInfluence of Culture on Consumer Behavior\r\n\r\nCross-Cultural Consumer Behavior: An International Perspective\r\n\r\nPart IV: The Consumers Decision-Making Process and Ethical Dimensions\r\n\r\nConsumers and the Diffusion of Innovations\r\n\r\nConsumer Decision Making and Beyond\r\n\r\nMarketing Ethics and Social Responsibility#top', 'English', 552, 500),
('BUS-9', 'Business Research Methods 8th Edition', 'William G. Zikmund', 650, 520, 20, 24, 'South Western', '8', 'Business and Management', 'A good manager needs to have insight into the previous happenings as well as the present situation in a business so as to be able to identify the underlying trends to develop short-term and long-term business strategies. These trends could relate to managing employeesucators Associationucators. He served on the editorial review boards of the Journal of Marketing Educationucation Reviewitor for the Journal of Business Research.\r\n\r\nJon C. Carr Jon is Assistant Professor in the Department of Management at TCU where he teaches courses in the area of New Ventures and Organizational Behavior. He previously taught at the University of Southern Mississippi. He has published articles in journals such as Entrepreneurship Theory & Practiceited books published by leading publishers. At IIM Kozhikodeitor of a few international academic publications.\r\n\r\nMitch Griffin Mitch is an Associate Professor of Management at Bradley University. Mitch has previous teaching experience at Southern Illinois University, the University of Minnesota, and Louisiana State University. His current teaching interests include Principles of Marketing, Pricing and Product Strategies, Sales Management, Marketing Research, and Advanced Marketing Research. In recognition of his teaching, Dr. Griffin received the Foster College of Business Administration 1994 Midwest Grain Products Inc. Outstanding Teaching Award. His research has appeared in the Journal of Consumer Research, Journal of Retailing, Journal of the Academy of Marketing.Science, Journal of Business Research, Journal of Consumer Affairs, Journal of Satisfaction, Dissatisfaction and Complaining Behavior, Journal of Nonprofit and Public Sector Marketing, and Advances in Consumer Research.\r\n', 'English', 772, 500),
('BUS-10', 'Stay Hungry Stay Foolish', 'Rashmi Bansal', 200, 150, 25, 12, 'Think Ink Media Inc', '1', 'Business and Management', 'Rashesh Shah did it.\r\n\r\nSanjeev Bikhchandani did it\r\n\r\nShantanu Prakash did it.\'Stay Hungry Stay Foolish\' is the story of 25 such IIM Ahmedabad graduates who chose the rough road of entrepreneurship. They are diverse in age in outlook and the industries they made a mark in. But they have one thing in common: they believed I the power of their dreams. This book seeks to inspire young graduates to look beyond placements and salaries. To believe in their dreams. ', 'English', 540, 500),
('BUS-11', 'Fundamentals Of Business Economics', 'BS Publications;BSP Books Experts', 995, 896, 10, 7, 'BS Publications;BSP Books', '1', 'Business and Management', NULL, 'English', 295, 500),
('BUS-12', 'Human Resource Management : Text and Cases 7th Edition', 'K. Aswathappa', 525, 443, 16, 12, 'McGraw Hill Education (India) Pvt Ltd', '7', 'Business and Management', 'K. Aswathappas Human Resource Management : Text and Cases 7th Edition is apt for MBA students. The book is divided into multiple section� so as to give you a better understanding of the subject. The books covers MBA syllabus for students who are specialising in human resources.\r\n\r\nAbout K. Aswathappa\r\n\r\nK. Aswathappa is an Indian author. He has penned down several books on relevant topics like human resources and international business. Management Concept, Practice and Cases 1st Edition, International Business 5th Edition and Organisational Behaviour are some of the books Aswathappa has authored.#Section 1\r\n1. Understanding the Nature and Scope of Human Resource Management\r\n2. Context of Human Resource Management\r\n3. Integrating HR Strategy with Business Strategy\r\n\r\nSection 2\r\n4. Human Resource Planning\r\n5. Analysis of Work, Designing Jobs and Job Evaluation\r\n6. Recruiting Talent\r\n7. Selecting Right Talent\r\n\r\nSection 3\r\n8. Training and Development, Career Management and Talent Management\r\n9. Appraising and Managing Performance\r\n10. Employee Engagement and Empowerment\r\n\r\nSection 4\r\n11. Compensation Management\r\n12. Incentives and Performance-based Pay\r\n13. Managing Employee Benefits and Services\r\n14. Compensating Top Brass\r\n\r\nSection 5\r\n15. Organisational Culture\r\n16. A Safe and Healthy Environment\r\n17. Managing Betterment Wor��Employee Welfare\r\n18. Managing Separations and Right Sizing', 'English', 912, 500),
('NEW-1', 'Like a Love Song', 'Nikita Singh', 175, 113, 35, 12, 'Harper Collins', '1', 'New', 'Love is a many-flavoured thing: it can go from vanilla to rainbow sprinkles in the blink of an eye.\r\n\r\nFour years ago, Maahi’s heart was broken into so many pieces that it looked like she might never put it back together again. Yet time has healed her wounds, and she has found her true calling – and even a dash or romance. But when the past comes knocking on her door, threatening to shatter a life she has carefully rebuilt, her world is turned upside-down. What will Maahi do when she is torn between her head and her heart?\r\n\r\nEmotionally charged and vivid, Like a Love Song is about the sort of love that consumes and sears you … and the healing powers of true passion.', 'English', 280, 500),
('NEW-2', 'General Knowledge 2017', 'Manohar Pandey', 129, 68, 43, 6, 'Arihant Publications', '9', 'new', 'In-depth Knowledge About The Varied Sections Covered Under The Subject Of General Knowledge Is Mandatory For The Candidates Aspiring To Appear For Various Competitive And Recruitment Examinations Like SSC, Bank Clerk & PO, Railway Recruitment, Etcas The Same Is Asked In Almost Each And Every Recruitment Examination.\r\nGeneral Knowledge 2017 Provides A Comprehensive Study Of All The Sections That Are Covered Under The Subject Of General Knowledge. The Book Has Been Divided Into 6 Sections – Indian History, Geography, Indian Polity, Indian Economy, General Science And General Knowledge Each Containing Theoretical Content. Figures, Graphics And Tables Have Been Given Along With The Theory Wherever Required. Important Notes & Tables Are Provided Under The Highlighted Box For The Revision Of Important Points. The ‘Current Affairs’ Section In The Beginning Of The Book Containscoverage Of Latest News & Events That Happened In The Recent Year. History Section Covers Ancient India, Medieval India, Modern India,Art & Culture And World History, Whereas The Geography Section Covers World Geography, Indian Geography And Environment & Ecology.The Indian Economy Section Covers Indian Economy, Broad Sectors Of Indian Economy, National Income Of India, Planning Of India, India’S New Economic Policy, Macro-Economic Problems In India, Agriculture, Industry, Indian Financial System, Insurance, Demography And Glossary Whereas The Indian Polity Section Covers Constitution Of India, Preamble, Union & Its Territory, Citizenship, Fundamental Rights, Prime Minister, President, Etc. The General Science Section Covers Basics Of Computer Apart From Physics, Chemistry And Biology.The General Knowledge Section Covers First In World, Superlatives World, Geographical Epithets, UNESCO World Heritage Sites In India, United Nations, Principle Languages Of India, Indian Defence, Space Programme Of India, National Awards, Etc. This Book Will Prove To Be Highly Successful For SSC, Railway, Bank (PO & Clerk), Army, Airforce, Navy And Various Other Competitive And Recruitment Examinations.', 'English', 320, 500),
('NEW-3', 'Indian Family Business Mantras', 'Peter Leach ; Tatwamasi Dixit', 595, 400, 33, 15, 'Rupa Publications', '1', 'new', 'Indian Family Business Mantras presents a comprehensive manifesto for family-owned businesses. In this book, a well-known family business expert and a partner at Deloitte UK, Peter Leach and Tatwamasi Dixit, an internationally renowned Vedic scholar and one of India s foremost family business consultants, focus on the ways and means to help family businesses manage growth, change and transitions. Richly illustrating each of their arguments with real-life examples as well as anecdotes from Indian epics, scriptures and history, the authors present compelling instances of family business those which flourished and those that floundered.\r\nWith interviews and analyses of some of the top Indian business families, including the Murugappa Group, Ambuja Group, Haldiram Group, GMR Group and Thermax Group, the book offers ways and means to help both small and large family businesses achieve prosperity and longevity. Other case studies include Biocon, Reliance, Ranbaxy, Godrej, Max India, Future Group, TVS Group, Tata Group and HCL Technologies. Along with addressing issues as varied as governance systems, professionalism, intergenerational integration, generational transition and family business conflicts, the authors make a vital point: in the absence of foresight,', 'English', 280, 500),
('NEW-4', 'Kiran s SSC Mathematics Chapterwise Solved Papers 1999 To Till Date 7100+ Objective Questions English', 'Kiran Prakashan;Pratiyogita Kiran ; KICX', 435, 289, 34, 22, 'Kiran Prakashan', '2', 'new', 'Kiran s SSC Mathematics Chapterwise Solved Papers 1999 To Till Date English\r\n\r\nContents\r\n\r\nNumber System\r\n\r\nLCM & HCF\r\n\r\nSimplification\r\n\r\nPower : Indices & Surds\r\n\r\nAverage\r\n\r\nRatio & Proportion\r\n\r\nPercentage\r\n\r\nProfit & Loss\r\n\r\nDiscount\r\n\r\nSimple Interest\r\n\r\nCompound Interest\r\n\r\nTime & Distance\r\n\r\nBoat & Stream\r\n\r\nSequence & Series\r\n\r\nAlgebra\r\n\r\nTrigonometry\r\n\r\nGeometry\r\n\r\nMensuration\r\n\r\nStatistics & Data Interpretation\r\n\r\nMiscellaneous.', 'English', 1000, 500),
('HEA-1', 'SAVOUR MUMBAI: A Culinary Journey Through India\'s Melting Pot', 'Vikas Khanna', 895, 671, 25, 4, 'Westland Publisher', '1', 'Health and Cooking', 'Vikas Khanna?s culinary journey started in Amritsar but the city of Mumbai has also played an important role in his evolution as an arbiter of dining taste. This book is his tribute to Mumbai which lays on the table a smorgasbord of delicious food options: Maharashtrian Parsi Gujarati Konkan street food and so much more. Food that is as multi-flavoured as the city itself. In the year that Khanna lived in the city working at The Leela Kempinski he explored and experienced all these cuisines. As he says it was a period that would benefit him in the kitchen in the years to come. In Savour Mumbai he visits some of his favourite restaurants and eateries selects their signature dishes helpfully modifying and adapting their recipes into a form that will be a boon to the home cook.', 'English', 332, 500),
('HEA-2', 'Cake & Bakes', 'Sanjeev Kapoor', 350, 280, 20, 12, 'Popular Prakashan', '1', 'Health and Cooking', 'Cakes and Bakes is a recipe book written by Sanjeev Kapoor. It is a book that teaches the reader to enhance their baking skills with the Indias leading master chef as their guide. Sanjeev Kapoor adorns the bakers cap in this book to de-mystify the art of baking. The recipes provided in this book are mentioned with stepwise instructions that make it easier for the reader. This book teaches how to bake various cakes such as Sacher Torte and Black Forest Gateau. The chef teaches how to prepare delicious desserts such as baked Alaska and Tiramisu. Other mouth-watering recipes covered here mushroom quiche, spring onion tarts, baked lemon cheesecake, mississippi mud pie. One can also learn to bake crunchy cookies such as jammie bodgers, chocolate chip cookies, nankhatais, and walnut coffee biscuits. Moreover, one can learn to bake scrumptious teatime treats such as cheese balls along with various rolls and breads through this book. The master chef has provided numerous informative tips and techniques, thereby giving an insight into the art of baking.\r\n\r\nSanjeev Kapoor is one of the most celebrated chefs and entrepreneurs of India. Some of his famous cookbooks include Chicken Recipes, Vegetarian Breakfast, Street Foods, Snack and Starters, and Salads. He was born in Haryana and grew up in Delhi, India. He got his diploma in hotel management from the Institute of Hotel Management (IHM) Pusa. Today, he is a chef extraordinaire, an author of numerous best-selling cookbooks, a TV show host, and a restaurant consultant. He has several culinary awards to his credit.', 'English', 148, 500),
('HEA-3', 'Vicky Goes Veg', 'Vicky Ratnani', 799, 519, 35, 6, 'Collins', '1', 'Health and Cooking', 'Siced with handy tips and reflections on various recipes from the man himself, Vicky Ratnani, this book is green and fresh. The recipes here are not the boring ones we know. They hail from all over the world but have an Indian twist : braised plaintain with Thai spices, hing-roasted pumpkin, vegetable Shepherds pie and so on. Vickys recipes are written clearly and made even more mouth-watering with a delicious series of photographs on the side. Filled with tips and trivia about herbs, recipes and that special ingredient, this book will have you rushing to the kitchen and add spark to your vegetarian cooking.About AuthorVicky Ratnani is a chef, TV host and food connoisseur. He hosts a popular TV cookery show by the same name on NDTV Goodtimes,and is the corporate chef at Aurus, a findining restaurant in Mumbai.', 'English', 122, 200),
('HEA-4', 'Masterchef India: Cookbook', 'Vikas Khanna', 1999, 1499, 25, 10, 'Bloomsbury', '1', 'Health and Cooking', NULL, 'Others', 1900, 500),
('HEA-5', 'Pure Vegetarian Cookbook', 'Prema Srinivasan', 695, 670, 4, 12, 'Westland Publisher', '1', 'Health and Cooking', 'The key to the best vegetarian food of the Tamil world is homestyle cooking. Prema Srinivasan leads us to that world with her Pure Vegetarian Cookbook, a guide which will have cooks and foodies perking up their ears and cleansing their palates in anticipation. \r\n\r\nIf you thought rasams, sambhars and idlis summed up the cuisine of the area, Srinivasan points you to the countless variations on such dishes and others. The more than hundred recipes in this book offer up ways, influenced by region, community, or simply, the seasons, to put the best platters on the table. They showcase the wide variety and infi nite inventiveness of the Tamil kitchen. Lesserknown dishes, featuring specific types of grains, and an awesome array of chutneys and pickles, are also lovingly included. \r\n\r\nEach section is accompanied by anecdotal explanations of the history and culture around the recipe, and by beautifully illustrated plates showing the ingredients, the utensils, the presentation, and of course, the food itself, each in relation to the rest. This book is a muchneeded addition to the library of any discerning gourmet, or anyone with an interest in the food and culture of Tamil India. \r\n\r\nAbout the Author\r\n\r\nPrema Srinivasan was brought up in a traditional South Indian family. From an early age, she learned to appreciate culinary heritage. Later on, she de veloped an interest in the origins of food. As she learned to cook, she developed her variations of a healthy vegetarian diet, balanced according to Ayurvedic principles. Recognizing that food cul tures are in a dynamic process of evolution, Srini vasan took a keen interest in incorporating some of the transregional and international influences that are compatible with the traditional core of South Indian vegetarian cuisine in our cosmopolitan age.', 'English', 328, 400),
('HEA-6', 'Big Book of Treats; The', 'Pooja , Dhingra', 699, 454, 35, 11, 'Penguin Books', '1', 'Health and Cooking', 'The Big Book Of Treats is the ultimate guide to baking for home bakers and mothers who love to bake for their little ones. The Big Book Of Treats will give the readers a chance to meet Pooja Dhingra, a cupcake addict and a professional baker. This book is her gift to home bakers, which teaches everything from making cupcakes and cookies to making delicious brownies and amazing birthday cakes. The patissier provides some great recipes for the home bakers to make all sorts of baked goodies in their kitchen.\r\n\r\nAbout Pooja Dhingra\r\n\r\nPooja Dhingra is the founder and owner of the famous Frenchstyle patisserie, Le15 and Studio Fifteen Culinary Centre in Mumbai. She graduated from Le Cordon Bleu in Paris. Pooja has featured in several in several fashion and lifestyle magazines not just for her baking, but also as a dynamic businesswoman and entrepreneur.', 'English', 440, 500),
('HEA-7', '101 Vegetarian Recipes', 'Nita Mehta', 395, 288, 27, 12, 'Snab Publishers', '1', 'Health and Cooking', NULL, 'English', 132, 500),
('HEA-8', 'Cookbook Festivals Of India', 'Nita Mehta', 795, 636, 20, 11, 'SNAB PUBLISHERS', '1', 'Health and Cooking', NULL, 'Others', 136, 500),
('HEA-9', 'Cooking With Love: Vegetarian Recipes From My Mother\'s Kitchen', 'Sanjeev Kapoor', 295, 242, 18, 12, 'Popular Prakashan', '1', 'Health and Cooking', NULL, 'English', 429, 500),
('HEA-10', 'Growing Children', 'Nita Mehta', 175, 162, 7, 18, 'Snab Publishers', '1', 'Health and Cooking', NULL, 'English', 650, 500);
INSERT INTO `products` (`PID`, `Title`, `Author`, `MRP`, `Price`, `Discount`, `Available`, `Publisher`, `Edition`, `Category`, `Description`, `Language`, `page`, `weight`) VALUES
('HEA-11', 'Cooking Italian Food in India', 'Roberta Angelone', 495, 371, 25, 11, 'Westland Publisher', '1', 'Health and Cooking', 'Chef Roberta has lived in India for seventeen years, working in restaurants in Manali where she quickly became the stuff of legend amongst travellers to the region. The Italian food that she serves is light and healthy and what make her dishes so special are the use of local ingredients and her understanding of the Indian palate, which she so successfully combines with her own culinary upbringing in Naples, where spice and fresh ingredients play a huge role. Now, in Cooking Italian Food in India, Roberta has put together the recipes that make her restaurant such a success. The book combines a range of appetisers, soups, sauces, main dishes and desserts. It also includes her tips on how to use herbs, choosing the right pasta for a sauce and the best wine to pair with your dish. A fabulous, easy-to-follow guide to making Italian food in India.', 'English', 154, 100),
('HEA-12', '101 Recipes For Children Vegetarian', 'Nita Mehta', 595, 476, 20, 10, 'Snab', '1', 'Health and Cooking', NULL, 'English', 450, 500),
('LIT-13', 'She Broke Up I Didnt! I Just Kissed Someone Else!', 'Durjoy Datta', 175, 113, 35, 8, 'Penguin Books', '1', 'Literature & Fiction', NULL, 'English', 248, 500),
('LIT-14', 'When Only Love Remains', 'Durjoy Datta', 175, 113, 35, 7, 'Metro Reads', '1', 'Literature & Fiction', NULL, 'English', 288, 500),
('LIT-15', 'Till the Last Breath', 'Durjoy Datta', 175, 113, 35, 8, 'Penguin Books', '1', 'Literature & Fiction', NULL, 'English', 256, 500),
('LIT-16', 'Our Impossible Love', 'Durjoy Datta', 175, 123, 30, 8, 'Metro Reads', '1', 'Literature & Fiction', 'Life teaches us what love truly is And love gives definition to life \r\nAisha, a bit of a late bloomer, has to figure out what it means to be a woman and to be desired. Danish feels time is running out for him and he s going to end up as a nobody, as opposed to his overachieving, determined younger brother.\r\nLife takes a strange turn when Danish, the confused idiot, is appointed as the student counsellor to Aisha. Between the two of them they have to figure out love, life, friendship most of all, themselves. And it s not proving to be . . . easy\'\r\nOur Impossible Love presents Life the way it is and Love the way it should be', 'English', 256, 500),
('LIT-17', 'One Night @ The Call Centre', 'Chetan Bhagat', 176, 114, 35, 8, 'Rupa Publications', '1', 'Literature & Fiction', 'One Night at the Call Centre is a witty, romantic and humorous story of six call center employees by India s bestselling author, Chetan Bhagat. \r\n\r\nOne Night at the Call Center is set in one night in a call center in Gurgaon. The call center employees provide technical assistance to American consumers and help them run their lives smoothly. The six friends Shyam, Priyanka, Esha, Vroom, Radhika, and Military Uncle somehow try to make it through the shift as tonight was no ordinary night. It is Thanksgiving in America and the phone lines are going crazy! Then one call, from a very special caller changes everything. This phone call is from God! One Night at the Call Center will make for an engaging and riveting read and is a must have for all Chetan Bhagat fans.', 'English', 257, 500),
('LIT-18', 'Five Point Someone : What Not To Do At Iit', 'Chetan Bhagat', 176, 116, 35, 10, 'Rupa Publication', '2', 'Literature & Fiction', NULL, 'English', 267, 500),
('LIT-19', 'Revolution 2020: Love Corruption Ambition', 'Chetan Bhagat', 176, 132, 25, 12, 'Rupa Publications', '2', 'Literature & Fiction', 'A tale of dreams, ambitions and unrequited love, Revolution 2020: Love. Ambition. Corruption. explores the lives of three friends from Varanasi, while also painting a stark picture of the country\'s corrupt political landscape', 'English', 296, 500),
('LIT-20', 'The Lost Symbol', 'Dan Brown', 499, 275, 35, 13, 'Transworld', '2', 'Literature & Fiction', 'The Capitol Building, Washington DC: Harvard symbologist Robert Langdon believes he is here to give a lecture. He is wrong. Within minutes of his arrival, a shocking object is discovered. It is a gruesome invitation into an ancient world of hidden wisdom.When Langdon\'s mentor, Peter Solomon - prominent mason and philanthropist - is kidnapped, Langdon realizes that his only hope of saving his friend\'s life is to accept this mysterious summons.It is to take him on a breathless chase through Washington\'s dark history. All that was familiar is changed into a shadowy, mythical world in which Masonic secrets and never-before-seen revelations seem to be leading him to a single impossible and inconceivable truth... # # When Langdon\'s mentor, Peter Solomon - prominent mason and philanthropist - is kidnapped, Langdon realizes that his only hope of saving his friend\'s life is to accept this mysterious summons. # # It is to take him on a breathless chase through Washington\'s dark history. All that was familiar is changed into a shadowy, mythical world in which Masonic secrets and never-before-seen revelations seem to be leading him to a single impossible and inconceivable truth...', 'English', 672, 500),
('LIT-21', 'Lol- An Eclectic Tale Of Love', 'Dan Brown', 300, 240, 20, 9, 'Notion Press', '1', 'Literature & Fiction', 'Description :\r\n\r\nAt times, fortune plays havoc with people’s life expectedly or unexpectedly. Rahul, a painter by birth takes up his father\'s business after completing middle school. In the midst of it, he is forced to leave the house after unveiling the mystery behind his birth. He goes to many places in search of his parents. Finds love with Pragathi, an extremely talented girl, hailing from a middle class family. \r\n\r\nRahul has loved Pragathi for years by now and is waiting for a chance to marry her somehow. With graduations approaching, Rahul has one more decision to make: Pragathi or Parents. It\'s gonna be a hectic reconciliation between the two.But, her dad tries to ignite their love accounting for his status. Will he succeed in roping Pragathi to his side? \r\n\r\nABOUT THE AUTHOR\r\n\r\nRahul Srinivasan was born on 27th of February to his parents S. Vengatesan and S. Geetha in the city of Chennai. Though he\'s from India, he loves to read foreign works and other literature right from childhood. Getting motivated by the writings of Shakespeare and Dan Brown, he decided to write a novel in his own style, and his own way of viewing things which makes him stand unique. He is currently pursuing his college degree in Meenakshi Sundararajan Engineering College, Chennai. \r\n\r\nAs a part of hobby, he writes many short stories and poems in addition to his first novel. He loves to be a role player during short skits and drama. So, in this novel, he takes up the main character named Rahul, and he narrates the entire story in first person which makes the storyline quite impressive, and adds a little bit of suspense.', 'English', 245, 500),
('LIT-22', 'Can Love Happen Twice?', 'Ravinder Singh', 175, 113, 35, 11, 'Penguin Books', '1', 'Literature & Fiction', NULL, 'English', 224, 500),
('LIT-23', 'Tell Me A Story', 'Ravinder Singh', 175, 123, 30, 9, 'Metro Reads', '1', 'Literature & Fiction', 'There is always a story that changed your life…\r\nAnd that is the time when life happened for you!\r\nTell Me a Story is collection of heartwarming stories about events and incidents that have affected or changed the lives of the writers in ways that they cannot forget. Happy or sad, inspiring or shocking, these are stories of moments that have left an indelible mark on their lives. Stories, that they would love to share.\r\n\r\nSelected and edited by Ravinder Singh, Tell Me a Story is about moments that make life worth living. It is the second such anthology, after the highly successful Love Stories that Touched My Heart.', 'English', 240, 500),
('LIT-24', 'Your Dreams Are Mine Now', 'Ravinder Singh', 175, 123, 30, 7, 'Penguin Books', '1', 'Literature & Fiction', 'They are complete opposites!\r\nShe\'s a small-town girl who takes admission in Delhi University (DU). An idealist, studies are her first priority. He\'s a Delhi guy, seriously into youth politics in DU. He fights to make his way. Student union elections are his first priority. But then opposites attract as well! A scandal on campus brings them together, they begin to walk the same path and somewhere along, fall in love… But their fight against evil comes at a heavy price, which becomes the ultimate test of their lives. Against the backdrop of dominant campus politics, Your Dreams Are Mine Now is an innocent love story that will tug at your heartstrings.', 'English', 272, 381),
('LIT-25', 'Jeffrey Archer - Kane And Abel', 'Jeffrey Archer', 339, 319, 20, 9, 'Pan MacMillan', '1', 'Literature & Fiction', NULL, 'English', 678, 500),
('LIT-26', 'Jeffrey Archer - A Prisoner Of Birth Pb GBP 7.99', 'Jeffrey Archer', 399, 316, 21, 12, 'Panmacmillan', '1', 'Literature & Fiction', NULL, 'English', 560, 500),
('LIT-27', 'Love Curse Of The Rumbaughs', 'Jeffrey Archer', 155, 141, 9, 1, 'Pan Macmillan U.K', '1', 'Literature & Fiction', 'I expect you might think the story I am about to tell you is untrue or perversely gothic in some unhealthy way . . .\' Everyone loves their mother. but what happens when you love her so much you can\'t bear to let her go ever? That\'s the sign of the Love Curse. And Ivy\'s got it . . . bad.', 'English', 248, 200),
('LIT-28', 'Sins Of The Father', 'Jeffrey Archer', 399, 315, 21, 11, 'Macmillan', '1', 'Literature & Fiction', 'The Clifton Chronicles continues with The Sins of the Father, a novel by Jeffrey Archer. Harry Clifton, who calls himself Tom Bradshaw, is arrested and accused of murdering his brother. He is sent to jail and told that he must plead guilty if he is to have a chance at survival. However, his decisions and the decisions of his family may yet test the strength of their bonds and their loyalties. Discover the stories of Hugo Barrington, Emma Barrington, Maisie Clifton, Giles Barrington, and Harry Clifton as the world crumbles under the effects of the Second World War.About Jeffrey ArcherJeffrey Archer is an English writer and former politician. He is known for writing Kane and Abel, Best Kept Secret and Only Time Will Tell.', 'English', 400, 500),
('OTH-1', 'Salman Rushdie\'S Cities', 'Salman Rushdie', 9324, 8476, 9, 11, 'Continuum International Publishing Group', '1', 'others', 'Employing Salman Rushdie as a guide to a historicized contemporary, this study offers an interdisciplinary exploration of the plurality of cities along his transnational trajectory. It engages with the geographically identifiable Bombay, Karachi, Islamabad, London or New York; the phantasmal, politically coded, Jahilia or Mildendo, the inspirational yet flawed urban precedents of Fatehpur Sikri or Renaissance Florence and the ways these cities generate, interact with and transform each other. In contrast with those urban studies which remain in place, this book offers a new understanding of cities wider and constantly shifting interconnections with other cities and places in an unstable, unevenly globalized and dangerously or provocatively local world. The book situates Rushdies cities in relation to developments in Bombay, Karachi, Islamabad and London writing and focuses on novels which shuttle between cities. Parashkevova attends to cities cultural and historical contexts, to many of Rushdies numerous literary, cinematic and artistic influences and to diverse events, processes and paradigms earthquakes, translations, seductions that politically re-position cities and citizens on the contemporary urban map.', 'English', 256, 500),
('ACA-13', 'Salman Rushdie???s Midnight???s Children', 'Salman Rushdie', 200, 150, 25, 14, 'Atlantic', '2', 'Academic & Professional', 'Salman Rushdie\'s Midnight\'s Children, ever since its publication in 1980, has been considered an ingenious piece of literary art and a trend setter in the field of Indian fiction in English. The stupendous success of this novel broke all previous records and Rushdie was hailed as one who engendered a whole new generation of fiction writers that embraced magical realism as a mode for the depiction of history. The variant mode of the portrayal of historical reality that Rushdie adopts in Midnight\'s Children is characteristically his own and his fantasizing of facts in this novel inspired a host of other writers to offer, in their respective works, their own blends of fact and fiction.', 'English', 600, 500),
('LIT-29', 'Salman Rushdie : New Critical Insights ( Vol. 1 )', 'Salman Rushdie', 750, 653, 13, 14, 'Atlantic', '1', 'Literature & Fiction', 'Rushdie has put behind him the political and religious controversy that surrounded him in the aftermath of the appearance of The Satanic Verses. These two volumes endeavour to continue the literary-critical study of his works by bringing together some of the best critical essays written in the post-?Verses controversy? period. The essays present an honest assessment of Rushdie?s works by creatively engaging with the issues each of them raises.About Author:Rajeshwar Mittapalli is Associate Professor of English at Kakatiya University, Warangal, Andhra Pradesh, India. His published works of criticism include The Novels of Wole Soyinka and Indian Women Novelists and Psychoanalysis. So far he has edited 20 anthologies of literary essays. They include Post-modernism and English Literature, Indian Fiction in English, Studies in Indian Writing in English, Volume 1 & 2, Post-Independence Indian English Fiction, Commonwealth Fiction: Twenty-first Century Readings, Modern American Literature, V.S. Naipaul: Fiction and Travel Writing, Modern Criticism and IT Revolution, Globalization and the Teaching of English.Dr. Mittapalli is currently the editor of The Atlantic Literary Review published from New Delhi. He is also the ex-officio editor of Kakatiya Journal of English Studies, an official publication of the Department of English, Kakatiya University, Warangal.He has published 32 articles on Indian, African and American fiction and ELT in such reputed journals as New Quest, ARTSresearch, Indian Literature, The Journal of Indian Writing in English, Commonwealth Quarterly, The Commonwealth Review and Revaluations.Joel Kuortti is Acting Professor of English at the University of Tampere, Finland. He has published three works on Rushdie: The Salman Rushdie Bibliography (1997), Place of the Sacred (1997), and Fictions to Live In (1998). Currently he is working on Indian English literature and has compiled an extensive bibliography of Indian women?s writing in English.', 'English', 248, 500),
('LIT-30', 'Torn', 'J K Rowling', 399, 296, 26, 31, 'Pan Macmillan', '1', 'Literature & Fiction', 'Acknowledging that she was different from everyone else wasn\'t difficult for Wendy Everly she\'d always felt like an outsider. But a new world and new family is a hard for any girl to accept easily. Leaving behind the mysterious country of her birth, she is determined to fit back into normal life. But the world she\'s left behind won\'t let her go that easily. Kidnapped and imprisoned by her true family\'s enemies, Wendy soon learns that the lines between good and evil aren\'t as defined as she thought. And those things she\'d taken for granted may have been lies all along. With the help of the dangerously attractive Loki, she escapes back to the safety of F rening only to be confronted by a new threat. It\'s time to make a choice can she put aside her personal feelings for the sake of her country? Torn between duty and love she must make a choice that could destroy her one chance at true happiness.Generated an excitement not felt in the industry since Stephenie Meyer or perhaps even J. K. Rowling\' New York Times,A fast paced romance addictive\' Guardian on Switched , \'Drew me in and kept me hooked...cracking pace\' Sunday Express on Switched', 'English', 356, 500),
('LIT-31', 'Harry Potter and the Half-Blood Prince', 'J K Rowling', 699, 454, 35, 32, 'Bloomsbury', '1', 'Literature & Fiction', NULL, 'English', 420, 500),
('LIT-32', 'Career Of Evil : A Cormoran Strike Novel', 'J K Rowling', 699, 365, 35, 23, 'Little, Brown Book Group', '1', 'Literature & Fiction', 'The third book in the highly acclaimed crime fiction series by J. K. Rowling, writing under the pseudonym Robert Galbraith. When a mysterious package is delivered to Robin Ellacott, she is horrified to discover that it contains a woman\'s severed leg. Her boss, private detective Cormoran Strike, is less surprised but no less alarmed. There are four people from his past who he thinks could be responsible - and Strike knows that any one of them is capable of sustained and unspeakable brutality. With the police focusing on the one suspect Strike is increasingly sure is not the perpetrator, he and Robin take matters into their own hands and delve into the dark and twisted worlds of the other three men. But as more horrendous acts occur, time is running out for the two of them... A fiendishly clever mystery with unexpected twists around every corner, Career of Evil is also a gripping story of a man and a woman at a crossroads in their personal and professional lives. You will not be able to put this book down.\r\n\r\nAbout the Author\r\n\r\nRobert Galbraith is a pseudonym for J. K. Rowling, bestselling author of the Harry Potter series and The Casual Vacancy. Career of Evil is the third book in the highly acclaimed Cormoran Strike crime fiction series. The Cuckoos Calling was published in 2013 and The Silkworm in 2014. Robert Galbraiths Cormoran Strike novels will be adapted for a major new television series for BBC One, produced by Bront Film and Television. Robert Galbraith / J. K. Rowling will not be available for interview or events.', 'English', 512, 500),
('LIT-33', 'Harry Potter And The Goblet Of Fire', 'J k Rowling', 699, 510, 27, 13, 'Bloomsbury', '1', 'Literature & Fiction', NULL, 'English', 427, 500),
('ACA-14', 'Life Mantras', 'Subrata Roy', 200, 158, 21, 11, 'Books', '1', 'Academic & Professional', NULL, 'Hindi', 260, 500),
('ACA-15', 'Life Mantras', 'Subrata Roy', 200, 160, 21, 14, 'Books', '1', 'Academic & Professional', '\"After having gone through the book, you will definitely and convincingly realise that to achieve\r\n\r\npeace, true happiness, contentment, satisfaction and also to attain continuous progress in life\r\n\r\nin terms of material gains, respect and love, you need not depend on anybody in this world. It\r\n\r\nall depends on you. It is all in your hands.\" Saharasri Subrata Roy Sahara\r\n\r\n\"Nobody does anything for anyone. All do for themselves either for more and more material gains\r\n\r\nor to save and escape from any kind of material losses or from mental-emotional dissatisfaction or for\r\n\r\ngetting more and more mental-emotional satisfaction. Therefore, no one sacrifices for anyone. When\r\n\r\nno one does anything for anyone, there is no justification in expecting any returns.\"\r\n\r\nThe author goes on to explain that to make life truly beautiful, one also needs to understand the basic\r\n\r\ntruths with which we are born or the basic instincts inherent in us all. So for a positive outcome one\r\n\r\nhas to learn the psychological or the emotional aspects of life, in other words, the realities of life or the\r\n\r\nentire philosophy of life. As you get immersed in the potent energy of these \'Life Mantras\', you will\r\n\r\nslowly find a change, a sense of fulfillment, a self-motivation coming in you. You will thus be led to\r\n\r\nthe ultimate realization that the journey of life is indeed a truly blissful and an enlightening experience. \r\n\r\nAbout The Author\r\n\r\nSubrata Roy Sahara (born 1948) popularly known as \'Saharasri\', is one of the most successful,\r\n\r\nbold, vociferous and talked-about figures of corporate India. When he laid the foundation of Sahara\r\n\r\nIndia Pariwar in 1978 with a capital of `2,000 (about $32) and three workers, who would have\r\n\r\nimagined his company\'s meteoric rise to a worth of `1,80,000 crore (about $27 billion) within\r\n\r\na span of thirty-seven years!\r\n\r\nA teacher, guide and a proud guardian to his over 1.2 million fellow workers, he ascribes his\r\n\r\nsuccess to his philosophy of \'Collective Materialism\' which means continuous collective growth\r\n\r\nfor collective sharing and caring.\r\n\r\nRenowned institutions like Harvard School of Business, USA; the Indian Institutes of Technology;\r\n\r\nthe Indian Institutes of Management; and Banaras Hindu University have invited him to address\r\n\r\ntheir faculty and students, besides which, a host of awards have been bestowed on him that include\r\n\r\nthe \'Indian Business Icon of the Year\' at the Powerbrands Hall of Fame Awards in London; the\r\n\r\nDoctor of Business (honoris causa) by the University of East London; and the highest honorary\r\n\r\ndegree, \'D. Litt.\' by the Lalit Narayan Mithila University, Bihar for his contributions in various fields.', 'English', 298, 500);

-- --------------------------------------------------------

--
-- Table structure for table `userinfo`
--

CREATE TABLE `userinfo` (
  `firstname` varchar(30) NOT NULL,
  `lastname` varchar(30) NOT NULL,
  `email` varchar(50) NOT NULL,
  `password` varchar(20) NOT NULL,
  `age` int(3) NOT NULL,
  `pnumber` varchar(10) NOT NULL,
  `address` varchar(80) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userinfo`
--

INSERT INTO `userinfo` (`firstname`, `lastname`, `email`, `password`, `age`, `pnumber`, `address`) VALUES
('himanshu', 'madan ', 'himanshumadan1059@gmail.com', '111111111111111', 19, '1111111111', 'delhi');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cart`
--
ALTER TABLE `cart`
  ADD PRIMARY KEY (`Customer`,`Product`),
  ADD KEY `Product` (`Product`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`PID`);

--
-- Indexes for table `userinfo`
--
ALTER TABLE `userinfo`
  ADD PRIMARY KEY (`email`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;