hi i need answers to the questions as instructed. My school uses oracle 11g to do the queries. 

 

Assignment 3/4 SQLTotal points: 100This assignment should be completed individually.For each problem, submit yourSQL statements and a screen shot of the SQL results in a single Word documentor pdf ±le.Submit the ±le via eLearning.I recommend creating a new userand workspace named after your netid, log in as that user and load thedatabase script facts.sql (provided in this week's assignment folder). Before you attempt to write any SQLqueries, familiarize yourself with the database structure and data.I have provided a relational diagramand sample data for this database.Write queries to address each of the problems below.Submit both the SQL statements and thescreen prints of the outputs from Oracle.(2 points for the screen shots).Be sure the workspacename is included in your screen shots!!!FACT Description and ERDThe CIS Department at Tiny College maintains the Free Access to Current Technology (FACT) library ofeBooks.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 themexclusive access to the book online through the FACT website, but only one patron at a time can haveaccess to a book.A book must have at least one author but can have many.An author must havewritten at least one book to be included in the system, but may have written many.A book may havenever been checked out, but can be checked out many times by the same patron or di±erent patronsover time.Because all faculty and sta± in the department are given accounts at the online library, apatron may have never checked out a book or they may have checked out many books over time.Tosimplify determining which patron currently has a given book checked out, a redundant relationshipbetween BOOK and PATRON is maintained.1

• 1494475360-4300ASSIGN_34_SQL_FA161.docx

ComputerScienceExpert

(11)

Status NEW Posted 11 May 2017 04:05 AM My Price 9.00

-----------

Attachments

file 1494475364-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer