please help asap

Case: The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT) library of e-books. FACT is a collection of current technology e-books for use by faculty and students. Agreements with the publishers allow patrons to electronically check out a book, which gives them exclusive access to the book online through the FACT website, but only one patron at a time can have access to a book. A book must have at least one author but can have many. An author must have written at least one book to be included in the system but may have written many. A book may have never been checked out but can be checked out many times by the same patron or different patrons over time. Because all faculty and staff in the department are given accounts at the online library, a patron may have never checked out a book or they may have checked out many books over time. To simplify determining which patron currently has a given book checked out, a redundant relationship between BOOK and PATRON is maintained. The ERD for this system is shown in Figure P7.56 and should be used to answer the next several problems. FIGURE PZ:56 THE CHO7 FACT ERD CHECKOUT PK Chesk Num PATRON PK Pat ID FK1 Book_Num FK2 Pat_ID Pat_FName Check Out Date Check Due Date Pat_Type Check_in_Date PatLName BOOK Book Num PK AUTHOR PK Au 10 Book Title Book Year Book Cost Book Subject FK1 Pat D Au_FName Au LName Au BirthYear WRITES PK,FK1 Book Num PK.FK2 AU ID 185 218 SELECT * FROM AUTHOR AL_ID AU_FNAME AU_LNAME AU_BIRTHYEAR Benson Reeves 1900 2 Rachel Beatney 1983 3 229 Carmine Salvador NULL 4 251 Hugo Brut 1972 5 262 Xia Chiang NULL 6 273 Reba Durante 1969 7 284 Trina Tankers 1961 8 383 Near Walsh 1980 9 394 Robert Lake 1982 10 438 Perry Pearson 1986 11 400 Connie Paulsen 1983 12 550 Rachel MGA NULL 13 581 Manish Aggarwal 1984 14 592 Lawrence Sheel 1976 15 603 Julia Palca 1958 5230 7995 SELECT * FROM BOOK BOOK NUM BOOK TITLE BOOK_YEAR BOOK COST BOOK SUBJECT PAT_ID 1 5235 Beginner's Guide to JAVA 2014 5995 Program NULL 2 Database in the Doud 2014 Cloud NULL 3 5237 Mastering the database environment 2015 89 95 Database NULL 1 Conceptual Program 2015 5095 Program 1220 5 5230 Jee in Mobile Apps 2015 49.95 Programang NULL . 5240 OS Programming 2015 7995 Programming 1212 7 5241 JAVA Fest Steps 2015 4995 Programming NULL 5242 Cin Middleware Deployment 2015 59.95 Mware 1228 9 5243 DATABASES in Theory 2015 12995 Database NULL 105244 Cloud based Mobile Applications 2015 6095 Cloud NULL 11 5245 The Golden Road to Platform independence 119.95 Middleware NULL 12 5246 Capture the Cloud 2010 6995 Cloud 1172 13 5247 Shining Through the Cloud Sun Programming 2016 10095 Programming NULL 14 5240 What You Always wanted to Know About Database, 2016 49.95 Database NULL 155240 Starlight Applications 2016 0095 Cloud 1207 16 5950 Reengineering the Middle The 2018 8095 Middleware NULL 175251 Thoughts on Revitalizing Ruby 2016 Programming NULL 18 5252 Beyond the Database Vel 2016 600S Database 1220 1995 Virtual Programming for Vrtus Environments 2016 2995 Programming NULL 205254 Coding Style for Maintenance 2017 40.95 Programming NULL 2016 5095 SELECT * FROM CHECKOUT CHECK_NUM BOOK_NUM PAT_ID CHECK_OUT_DATE CHECK_DUE_DATE CHECK_IN_DATE 91001 5235 1165 2017-03-31 2017-04-14 2017-04-09 2 91002 5238 1209 2017-03-31 2017-04-07 2017-04-05 3 91003 5240 1160 2017-03-31 2017-04-14 2017-04-09 4 91004 5237 1160 2017-03-31 2017-04-14 2017-04-03 5 91005 5236 1202 2017-03-31 2017-04-07 2017-04-08 6 91006 5235 1203 2017-04-05 2017-04-12 2017-04-13 7 91007 5244 1174 2017-04-05 2017-04-12 2017-04-08 8 91008 5248 1181 2017-04-05 2017-04-12 2017-04-06 9 91000 5242 1170 2017-04-05 2017-04-19 2017-04-09 10 91010 5235 1161 2017-04-05 2017-04-19 2017-04-05 11 91011 5236 1181 2017-04-05 2017-04-12 2017-04-11 12 91012 5249 1181 2017-04-08 2017-04-15 2017-04-12 13 91013 5240 1100 2017-04-10 2017-04-24 2017-04-19 14 91014 5236 1204 2017-04-11 2017-04-18 2017-04-19 15 91015 5237 1204 2017-04-11 2017-04-18 2017-04-13 16 91016 5236 1183 2017-04-13 2017-04-27 2017-04-14 17 91017 5240 1184 2017-04-14 2017-04-21 2017-04-22 18 91018 5236 1170 2017-04-14 2017-04-28 2017-04-14 19 91019 5246 1171 2017-04-14 2017-04-21 2017-04-17 20 91020 5254 1185 2017-04-16 2017-04-23 2017-04-23 21 91021 5238 1185 2017-04-16 2017-04-23 2017-04-21 22 91022 5252 1171 2017-04-16 2017-04-23 2017-04-19 23 91023 5249 1207 2017-04-16 2017-04-23 2017-04-19 24 91024 5235 1209 2017-04-21 2017-04-28 2017-04-29 25 91025 5246 1172 2017-04-21 2017-04-28 2017-04-27 26 91026 5254 1161 2017-04-21 2017-05-04 2017-04-26 27 91027 5243 1161 2017-04 21 2017-05-04 2017-04-26 28 91028 5236 1183 2017-04 22 2017-05-05 2017-04-30 29 91029 5244 1203 2017-04-22 2017-04-29 2017-04-26 30 91030 5242 1207 2017-04-22 2017-04-20 2017-04-30 31 91031 5252 2017-04-23 2017-05-06 2017-04-30 32 91032 5238 1172 2017-04-23 2017-04-30 2017-04-26 33 91033 5235 1174 2017-04-23 2017-04-30 2017-04-23 34 91034 5240 1185 2017-04-23 2017-04-30 2017-05-01 35 91035 5248 1165 2017-04-24 2017-05-07 2017-04-25 36 91036 5237 1202 2017-04-24 2017-04-30 2017-04-28 &&&8*98**NXXSNNzE 1165 SELECT * FROM WRITES Cory 592 SELECT * FROM PATRON PAT_ID PAT_FNAME PAT_LNAME PAT_TYPE 1 1160 robert carter Faculty 2 1161 Kelsey Koch Faculty 3 1165 Cedric Baldwin Faculty 4 1166 Vera Alvarado Student 5 1167 Alan Martin FACULTY 6 1170 Barry faculty 7 1171 Peggy Marsh STUDENT 8 1172 Tony Mles STUDENT 9 1174 Betsy Malone STUDENT 10 1180 Nadine Blair STUDENT 11 1181 Alen Home Student 12 1182 Jamal Melendez STUDENT 13 1183 Helena Hughes Faculty 14 1184 Jimmie Love Student 15 1185 Sandra Yang student 16 1200 Lorenzo Torres Student 17 1201 Shelby Noble Student 18 1202 Holly Anthony Student 19 1203 Tyler Pope STUDENT 20 1204 Thomas Duran Student 21 1205 Clare Gomez student 22 1207 Iva Ramos Student 23 1208 Olle Cantroll Student 24 1209 Rena Mathis Student 25 1210 Cooley STUdont 26 1211 Jerald Gaines Student 27 1212 Iva McClain Student 28 1213 Desiree Rivas Student 29 1214 Marina King Student 30 1215 Maureen Downs Student 251 BOOK_NUM AU_ID 1 5235 273 2 5236 383 3 5237 185 4 5238 603 5 5230 229 6 5239 460 7 5239 8 5240 218 9 5241 460 10 5241 559 11 5242 581 12 5243 13 5244 262 14 5244 284 15 5245 394 16 5246 251 17 5247 394 18 5248 229 19 5249 262 20 5250 383 21 5250 438 22 5251 460 23 5252 262 24 5253 185 25 5254 550 24 N R & 8 8 8 8 8 8 Keith : Question 6 (4 points) -- 06. Write a query to display the author last name, first name, cost -- and title for each book. Sort the results by cost and then author's -- last and first name --07. Write a query to display the patron ID, last and first name of all patrons -- who have never checked out any book. Sort the result by patron first name descending -- and then last name ascending. --09. Write a query to display the book number and the number of times each book has -- been checked out. Do not include books that have never been checked out. Sort the results by the number of times checked out in descending order