Question: Please I need help with this assignment The following questions refer to the Sakila database that comes preloaded with some MySQL installation. Refer to the

Please I need help with this assignment

The following questions refer to the Sakila database that comes preloaded with some MySQL installation. Refer to the documentation at: http://dev.mysql.com/doc/sakila/en/sakila.html.

The XML file in this assignment is based on the Sakila database. You will also need a good XML editor to execute XPath and XQuery expressions. A free version of 2010 Editix can be find here. It is good enough for our course.

(1) For filmActor.xml, provide the XPath expressions for the following queries. Provide also the SQL queries to obtain the same result from Sakila directly.

(a) The title elements of all films with a rating of R. For example, result in Editix should contain 195 elements:

Please I need help with this assignment The following questions refer to

(b) The film elements with a rating of R and having eight or more copies. For example, result in Editix should contain 12 film elements:

the Sakila database that comes preloaded with some MySQL installation. Refer to

the documentation at: http://dev.mysql.com/doc/sakila/en/sakila.html. The XML file in this assignment is based (d) The film elements with a length longer than that of the film 'SONS INTERVIEW'. For example, result in Editix should have 10 film elements:

on the Sakila database. You will also need a good XML editor

(2) Use XQuery to output XML of actor information in the following format.

PENELOPE GUINESS ACADEMY DINOSAUR ANACONDA CONFESSIONS ANGELS LIFE BULWORTH COMMANDMENTS CHEAPER CLYDE COLOR PHILADELPHIA ELEPHANT TROJAN GLEAMING JAWBREAKER HUMAN GRAFFITI KING EVOLUTION LADY STAGE LANGUAGE COWBOY MULHOLLAND BEAST OKLAHOMA JUMANJI RULES HUMAN SPLASH GUMP VERTIGO NORTHWEST WESTWARD SEABISCUIT WIZARD COLDBLOODED NICK WAHLBERG ADAPTATION HOLES APACHE DIVINE BABY HALL BULL SHAWSHANK ... VIRGINIAN PLUTO WARDROBE PHANTOM WRONG BEHAVIOR

film (5)16 film (5) 17 film (5) 18 film (5) 19 o-O film (5) 20 efilm (5) 21 42 rating PG rating 3 numCopies 6 numCopies> 44 specialFeatures Deleted Scenes specialFeatures> 45 film> 46 film id-"7" 7 title AIRPLANE SIERRA title 48 length 62 length 9 rating PG-13 rating 50 numCopies>5 inumCopies 51 specialFeatures>Trailers,Deleted ScenesspecialFeatures 52 film From root | | From current 01.0 . 2.0 Result Variable Namespace History Node Value AIRPORT POLLOCK ALONE TRIP AMELIE HELLFIGHTERS AMERICAN CIRCUS ANACONDA CONFESSIONS ANALYZE HOOSIERS ANYTHING SAVANNAH APOCALYPSE FLAMINGOS ite ite me tite ite tite tite ite tite itle ite tite 8 title AIRPORTPOLlockstit 55 length 54 length 56 R rating BADMAN DAWN BANGER PINOCCHIO BEAR GRACELAND BEAST HUNCHBACK BEVERLY OUTLAW BOOGIE AMELIE numCopies 4 numCopies> 58? specialFeatures-Trailers!Features- 59 film 60 film id"g 61 title ALABAMA DEVIL title 62 length 114length ite film (5)16 film (5) 17 film (5) 18 film (5) 19 o-O film (5) 20 efilm (5) 21 42 rating PG rating 3 numCopies 6 numCopies> 44 specialFeatures Deleted Scenes specialFeatures> 45 film> 46 film id-"7" 7 title AIRPLANE SIERRA title 48 length 62 length 9 rating PG-13 rating 50 numCopies>5 inumCopies 51 specialFeatures>Trailers,Deleted ScenesspecialFeatures 52 film From root | | From current 01.0 . 2.0 Result Variable Namespace History Node Value AIRPORT POLLOCK ALONE TRIP AMELIE HELLFIGHTERS AMERICAN CIRCUS ANACONDA CONFESSIONS ANALYZE HOOSIERS ANYTHING SAVANNAH APOCALYPSE FLAMINGOS ite ite me tite ite tite tite ite tite itle ite tite 8 title AIRPORTPOLlockstit 55 length 54 length 56 R rating BADMAN DAWN BANGER PINOCCHIO BEAR GRACELAND BEAST HUNCHBACK BEVERLY OUTLAW BOOGIE AMELIE numCopies 4 numCopies> 58? specialFeatures-Trailers!Features- 59 film 60 film id"g 61 title ALABAMA DEVIL title 62 length 114length ite

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Please can anyone explain this assignment for me. I really need help in this. This question refers to the Sakila database that comes preloaded with MySQL installation. Refer to the documentation at:...

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

GRADUATE CERTIFICATE IN PROJECT MANAGEMENT PROJ5010: PROJECT PROCUREMENT AND STRATEGIC SOURCING. CASE STUDIES CONTENTS 1. Proj5010: The World Bank RFP Case Study covers 1. Assignment 1: Marks = 5 2....

Willowbrook Case Study question: Design the monthly billing statement for a family using a printer spacing chart or graph paper. Include a mock-up report and a report analysis form for each report ....

THE BRITISH JOURNAL OF CRIMINOLOGY Vol. 17 January 1977 No. 1 NILS CHRISTIE (Oslo) f Abstract CONFLICTS are seen as important elements in society. Highly industrialised societies do not have too much...

please I need help for my project ACC 112 Project 1B The below represents the comparative financial statements of Kamla Corporation. Kamla Corporation Comparative Income Statement For the Years Ended...

QUESTION ONE [40] Joe Soap is studying for his exams however in struggling with IAS 38. He is writing next week and trying to cram in the work however It does not seem to be working out. Please can...

please can someone help me to answer the follow Questions for the group project . the questions the group project How does the Group give a clear audience for their Group Project? How does the Group...

AutoSave OFF W AGG ... 2 1-1C Periodic Trends Assignment SCI102B_ STUDENT NAME HERE - Saved to my Mac OP Home Insert Draw Design Layout References Mailings Review View Tell me Comments Editing LE...

Please, Please, I need help with why am I getting these errors Please, Please Next, you must develop a Python module in a PY file, using object-oriented programming methodology, to enable CRUD...

A piston/cylinder contains 2 kg water at 5 MPa, 800C. The piston is loaded so pressure is proportional to volume, P = CV. It is now cooled by an external reservoir at 0C to a final...

Consider a multiple linear regression with n observations and p predictors. Y=X8+e, where Y = (Y1,.Y) is the nx 1 vector of responses: X is the nx(p+1) matrix of predictors, including a column of l's...

When a broker - dealer executes a stock trade on an ogency basis, which of the following must appear on the trade confirmation? A Commission Morkuptnorkdown Accrued interest EDCAR's web address

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

5. Benchmark current training practices.

4. Describe the components of the change model and how they can be used to introduce a new training method.

9. Are work-family programs the same as work-life programs? Explain.