Assignment 4 SQL Total points: 50 All problems are worth 5 points unless otherwise specified For each problem, submit your SQL statements and a screen shot of the SQL results in a single Word document or pdf file. Submit the file via eLearning. I recommend creating a new user and workspace named after your netid, log in as that user and load the database script facts.sql (provided in this week's assignment folder). Before you attempt to write any SQL queries, familiarize yourself with the database structure and data. I have provided a relational diagram and sample data for this database Write queries to address each of the problems below. Submit both the SQL statements and the screen prints of the outputs from Oracle. (2 points for the screen shots). Be sure the workspace name (your id) is included in your screen shots!!! Workspace: FACTUSER User: FACTUSER CHECKOUT PK Check Num FK1 Book Num FACT Description and ERD PATRON PK Pat ID The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT) library of eBooks. FACT is a collection of current technology eBooks 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 BOOoK and PATRON is maintained (FA0 out Date Pat FName Pat LName Check Due Date Pat Type Check In Date BOOK AUTHOR PK Au ID Book Title Book Year Book Cost Book_Subject Au FName Au LName Au BirthYear FK1 Pat ID WRITES PK,FK1 Book Num PK,FK2 Au ID