Implement the missing TODO entries in the “querySqlite()” function. Use the supplied “querySqliteAndPrintResults()” function to query the database. The queries should be as follows: 1. Count the total...

1 answer below »

Implement the missing TODO entries in the “querySqlite()” function. Use the supplied “querySqliteAndPrintResults()” function to query the database. The queries should be as follows: 1. Count the total number of JSON documents in the database. 2. Count the total number of Images, Labels, Landmarks, Locations, Pages, and Web Entities in the database, listing the count for each separately. 3. List the URLs of all Images tagged with the Label with mid “/m/015kr” (which has the description “bridge”), ordered by the score of the association between them from highest to lowest. 4. List the 10 most frequent Web Entities that are associated with the same Images as the Label with an id of "/m/015kr" (which has the description "bridge"). List them in descending order of the number of times they appear, followed by their entity_id alphabetically. 5. Find all Images associated with any Landmarks that are not “New York” or “New York City”, ordered alphabetically by landmark description and then by image URL. 6. List the 10 Labels that have been applied to the most Images along with the number of Images each has been applied to. 7. List the 10 Pages that are linked to the most Images through the webEntities.pagesWithMatchingImages JSON property along with the number of Images linked to each one. Sort them by count (descending) and then by page URL. 8. List the 10 pairs of Images that appear on the most Pages together through the webEntities.pagesWithMatchingImages JSON property. List them in descending order of the number of pages that they appear on together, then by the URL of the first image. Make sure that each pair is only listed once regardless of which is first and which is second.

005_lyxejo-2fcorc1o.py 005_gibejo-obojipz4.pdf 005_xibejo-zlsvatrz.json 005_bcfejo-ow3ak5xa.png

Answered 165 days After May 18, 2022

Solution

Aditi answered on Oct 31 2022

62 Votes

SOLUTION.PDF

Implement the missing TODO entries in the “querySqlite()” function. Use the supplied “querySqliteAndPrintResults()” function to query the database. The queries should be as follows: 1. Count the total...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment