Write 1 sql query and 1 xquery

1) PHP + SQL Database: [login to view URL]

A web page is required that shows the average number of bikes available at TFL bike stations at a particular time of day as a proportion of the station capacity. The page connects to the online tflBikes database and generates HTML content in real time using PHP and MySQL. It must contain a table with rows representing each station that is within a square cell with sides of length 1050m that is centered on the bike station at Emperor's Gate, South Kensington over a 11 hour period commencing at 6am.

Each row of the table must show four items of data from left to right in this order:

the average number of bikes available at the specified time of day;

this number as a percentage of station capacity;

the station name;

the postcode.

The average number of bikes and the percentage of capacity must be presented to a precision of 1 decimal place.

The table must be ordered by percentage of capacity so that stations with the most bikes available on average are at the top.

The page must be robust enough to accommodate updates to the database as time progresses, such as changes in the locations (but not names) of the stations and continue to return correct information.

Accordingly the MySQL query can contain the focus station name, and the times of day but no coordinates and no names of other stations.

2) XML db: [login to view URL]

Live data about bike station status are scraped from the TFL web site in an XML document. An XQuery is required to generate HTML output from the XML documents that are streamed from the TFL site.

Use this file to generate an XQuery that processes data of this format. You can use the XQuery system BaseX we've used in the lectures.

The HTML that is generated must contain a list of all stations that have ...

the same number of bikes currently docked, and

at least as many empty docks

...Emperor's Gate, South Kensington.

Each list element in your output must contain the number of empty docks, the number of bikes, and the station name.

The list itself must be ordered by the number of empty docks and then alphabetically by station name where numbers of empty docks are equal.

The list you generate must use exactly the HTML format shown below.

<li>## empty, ## bikes @ STATIONNAME</li>

Graphic Design HTML PHP Website Design

Project ID: #13581109

About the project