Question: Using the movies.xml shown below I need to create an xslt to show two tables; (1) Only movies made before 2005, and (2) Movies made

Using the movies.xml shown below I need to create an xslt to show two tables; (1) Only movies made before 2005, and (2) Movies made from 2005 onward.

In each table, I have to display the list of genres in a single cell as a comma-delimited list.

I also need to append a bulleted list of directors below each of the existing tables. The names should be sorted, but may list duplicate names.

I need to add a footer row to each table that says "Number of movies", followed by a count of the number of movies in the XML file for that table.

In each movie table, I need to add a hyperlink to each movie title for movies containing a uri element.

---------------------------------------------------------------------------------------------------

123456789 Spirited Away Hayao Miyazaki 2001 Animation Adventure Family http://www.imdb.com/title/tt0245429/

234567891 Pan's Labyrinth Guillermo del Toro 2006 Drama Fantasy War http://www.imdb.com/title/tt0457430/?ref_=nv_sr_1

345678912 WALL-E Andrew Stanton 2008 Animation Adventure Family http://www.imdb.com/title/tt0910970/?ref_=nv_sr_1

456789123 12 Years a Slave Steve McQueen 2013 Biography Drama History http://www.imdb.com/title/tt2024544/

567891234 Inception Christopher Nolan 2010 Action Adventure Sci-Fi http://www.imdb.com/title/tt1375666/

678912345 Artificial Intelligence: A.I. Steven Spielberg 2001 Adventure Drama Sci-Fi http://www.imdb.com/title/tt0212720/

789123456 The Pianist Roman Polanski 2002 Biography Drama Music http://www.imdb.com/title/tt0253474/

891234567 Ratatouille Brad Bird 2007 Animation Comedy Family http://www.imdb.com/title/tt0382932/

912345678 Signs M. Night Shyamalan 2002 Drama Mystery Sci-Fi http://www.imdb.com/title/tt0286106/?ref_=nv_sr_1

102345610 Men in Black Barry Sonnenfeld 1997 Adventure Comedy Family http://www.imdb.com/title/tt0119654/?ref_=nv_sr_2

1123456711 Ace Ventura: Pet Detective Tom Shadyac 1994 Comedy http://www.imdb.com/title/tt0109040/?ref_=nv_sr_1

1234567812 Iron Man Jon Favreau 2008 Action Adventure Sci-Fi http://www.imdb.com/title/tt0371746/?ref_=nv_sr_2

1324567813 Mad Max: Fury Road George Miller 2015 Action Adventure Sci-Fi http://www.imdb.com/title/tt1392190/

1423567814 Man on Fire Tony Scott 2004 Action Crime Drama http://www.imdb.com/title/tt0328107/?ref_=nv_sr_1

1523467815 Pulp Fiction Quentin Tarantino 1994 Crime Drama http://www.imdb.com/title/tt0110912/?ref_=nv_sr_1

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!

Q:

Question: COP4814 Assignment 2 (60 Points in total) Step 1 - Selectively Displaying Movies (20 points) Continue the XSLT you wrote for Assignment 1 by doing the following: There must be two tables:...

Q:

CASE 11 Netflix in 2012: Can It Recover from Its Strategy Missteps? Arthur A. Thompson The University of Alabama hroughout 2010 and the first six months of 2011, Netflix was on a roll. Movie...

Q:

Report Format: Your report should include: II. Executive Summary (1 page in length). The Executive Summary is a concise overview of the report. The Case Study Report should be written from the...

Q:

6 | Consumer Choices Figure 6.1 Investment Choices Higher education is generally viewed as a good investment, if one can afford it, regardless of the state of the economy. (Credit: modification of...

Q:

Read the following sample life insurance policies: Universal Life Whole Life Complete the worksheets for each sample policy. Universal Life Policy Worksheet FIN/428 Version 1 University of Phoenix...

Q:

Answers must be between 200-250 words only. Need for the answer to stay within the guidelines and not be copied directly from another source. Universal Life Policy Worksheet FIN/428 Version 1...

Q:

Hi, I was wondering if you can help me with some financial accounting work? I need help in computing the numbers for Forecast Values for 2024 for Humana using the information below. I have a sample...

Q:

Jones & Bartlett Learning, LLC. NOT FOR RESALE OR DISTRIBUTION CHAPTER Hot Spot Analysis 10 LEARNING OBJECTIVES C A R R Provide a working definition of a \"hot spot.\" , Be able to explain different...

Q:

1) What are Netflix's resources, capabilities, and core competencies in this case based on the VRIO framework? 2) Conduct a SWOT analysis based on the case. It's not Netflix that's making the...

Q:

MiniCase 15: Disney: Building Billion-Dollar Franchises Disney: Building Billion-Dollar Franchises This activity is important because, as a manager, you must be able to identify the growth and...

Q:

Photons of energy E = 4.000 keV undergo Compton scattering. What is the largest possible change in photon energy, measured as a fraction of the incident photon's energy (E E) / E?

Q:

Suppose that when a string of English text is encrypted using a shift cipher f (p) = (p + k) mod 26, the resulting ciphertext is DY CVOOZ ZOBMRKXMO DY NBOKW. What was the original plaintext string?

Q:

In the earlyCommon equity refers to the sum of which of the following balance sheet accounts? Question 5 options: a) Common stock and retained earnings b) Book value, retained earnings, and common...

Q:

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

Q:

Teamwork. Global. Technology. Form teams of three students. Choose a culture you are not totally familiar with but would like to learn more about. Research (through the Internet or interviews) the...

Q:

Teamwork. Bring a newspaper,magazine, or book to class. a. Working in a group of four, have one member read aloud for five minutes while the other three members listenone using cautious listening,...

Q:

Global. Teamwork. Conduct an in-class debate on whether ineffective listening is strictly an American problem or whether it exists worldwide. Do the secondary research necessary to support your or...