Directions This unit, you are provided with a small Microsoft Access database that contains data about a book seller with the following characteristics 1. The book seller keeps track of the ISBN, title, category("Science", "Art', etc.), number of copies in stock, price and the indication if the book is used or not, for all books they had 2. Names and unique AuthorlD codes of book's authors are also stored in the database in an Author table and the Wrote table makes the connection between authors and books. The field AuthorRank in the Wrote table indicates the rank of an author among all authors of the book. For example a book with three authors will give rank number 1 to the irst author, 2 to the second, and 3 to the third. Books with one author always will give a rank number of 1 to this author 3. Table Customer contains the name, address and a unique identifier for each customer 4. Customers may order books. Dates when the order was made and when it was delivered are stored in the Order table, together with the Customerld. The Order table is related by the feld OrderNo with the OrderLine table. The OrderLine table contains a record per each book title ordered. The field OrderRank indicates the rank of the Book within the Order. The pair of fields OrderNo and OrderRank are the primary key for the OrderLine table. A record in the OrderLine table also contains the ISBN of an ordered book, the quantity ordered and the percentage of discount over the original price that is given for this book. You must use the Access database and create queries that will answer the requests below. You may use Query by Example (QBE) or direct SQL to create the queries. Store them using the number of the question (Q1, Q2, etc.) Q7. Obtain the ranking of all categories of books by the total quantity that was ordered, from the most ordered to the least ordered. Q8. Obtain the total of all discounted prices of all books ordered by the Customer "Jerry Seinfeld" Remember that if the percentage of discount is 1, the total discounted price is 0.99 the original price. 9. Obtain the book titles, the last name of their first authors, and the sum of all copies of the book sold. Include only the titles with more than 5 copies ordered by customers in total. Sort the list in descending number of books sold. Q10. Obtain the ISBN, title and author last names of all books that were not ordered ever. Author Book ( Customer.(0rd (m orderine (wrote\ef Relationships\ AuthoriDFirstName InitialsLastName Click to Add Colley Hoffer Ramesh Topi Dyer Spiegel Lipschutz Schiller Monks Bronson Salvatore 10100 Susan 10101 Jeffrey 10102 Venkataraman 10103 Heikki 10104 Russell 10105 MurrayR 10106 Seymour 10107 John 10108 Joseph 10109 Richard 10110 Dominick 10111 George 10112 Richard 10113 Minor 10114 Frank 10115 Fred 10116 Christin 10117 Richard G 10118 Carsten 10119 David 10120 Stephen 10121 Robert 10122 Andrew 10123 Philip 10124 Joseph 10125 Ramez 10126 Shamkant B 10127 Ramon 10128 Paulin 10129 Michael Bronson Ayres Jr Kleiner Tansey Warncke Lauer Pentak Gordon Forge Adamski Elmasri Mata-Toledo Record: " ,of30-H KE No Filter Search Num Lock Author Book\Customer Ord \(E] OrderLine'l wrote Relationships - Category Click to A Fundamentals of Relational Database: Databases Mathematics Datbase Design, Application, Develop Databases General Topology Mathematics Mathematics Gardner's Art through the Ages Fundamentals of Database Systems Databases Record: 4 12 of 27ND No Filter Num Lock 2/ Author (Book| Customer Ord Ordertine (wrote(=-Relationships CustomerD CustomerNa- CustomerAddresS State Click to A Texas 5101 John Smith PO 2335 TX 78799 5102 Quincey Adam PO 4337 DC 20010 Washington DC 5103 Jay Leno 5104 Barry Manilow PO 3726 CA 94205 California 5105 Jerry Seinfeld PO 8788 NY 10047 New York 5106 Salem Municip PO 7WA 98008 5107 Clark Kent PO10101 NY 10007 New York 5108 Tom Sawyer PO 46213 MS 39532 Mississippi 5109 Alejandro Tole PO 85391 CA 94204 California 5110 Ming Zhao PO 45667 OR 97202 Oregorn PO 2675 CA 90210 California Washington Author(Book Customer Order Orderline( wrote (- Relationships\ OrderNoOrderDate OrderDelive CustomerID Click to Add 101 4/13/2016 4/20/2016 102 4/13/2016 4/19/2016 103 4/14/2016 4/23/2016 104 4/16/2016 4/20/2016 05 4/18/20164/22/2016 106 4/20/2016 07 4/22/2016 / 108 4/25/2016 5/1/2016 109 4/27/2016 5/2/2016 110 4/29/2016 5/7/2016 111 4/30/20165/6/2016 112 5/1/2016 5/7/2016 113 5/3/20165/15/2016 114 5/3/2016 5/10/2016 115 5/4/2016 5/10/2016 116 5/5/2016 5/12/2016 117 5/6/2016 5/13/2016 118 5/7/20165/20/2016 119 5/9/2016 5/19/2016 120 5/11/2016 5/18/2016 121 5/13/20165/21/2016 122 5/15/2016 5/20/2016 123 5/17/20165/23/2016 124 5/19/2016 5/27/2016 Record: 14-1 of 25 No Filter Search Author(Book"- Customer ord.. oederline wrote(cf Relationships Authorld ISBN AuthorRank- Click to Add 77 35 36 60 60 60 60 60