• DUE DATE: Wed. June 19 by 11:59:59pm
  

This set of problems will give you some practice using MongoDB queries. You may create and submit your solution as a Java program.

Here is a sample JSON record that defines a restaurant. The definition includes an embedded document for the address of the restaurant, and an array of documents representing grades, consisting of a date the restaurant was graded, a letter grade, and a numeric score.

{
  "address": {
     "building": "1007",
     "coord": [ -73.856077, 40.848447 ],
     "street": "Morris Park Ave",
     "zipcode": "10462"
  },
  "borough": "Bronx",
  "cuisine": "Bakery",
  "grades": [
     { "date": { "$date": 1393804800000 }, "grade": "A", "score": 2 },
     { "date": { "$date": 1378857600000 }, "grade": "A", "score": 6 },
     { "date": { "$date": 1358985600000 }, "grade": "A", "score": 10 },
     { "date": { "$date": 1322006400000 }, "grade": "A", "score": 9 },
     { "date": { "$date": 1299715200000 }, "grade": "B", "score": 14 }
  ],
  "name": "Morris Park Bake Shop",
  "restaurant_id": "30075445"
}

Your individual Github repositories "2019S1CS5200SV/assignment-7-ccsid" contain a file "restaurants.zip" with several thousand records for restaurants. Download and unzip this file as "restaurants.json".

Create a Mongo database "restaurantDB" and a container "restaurants". Use the Mongo tool to load these records into the "restaurants" container. Here is the command:

mongoimport -d restaurantDB -c restaurants retaurants.json

Be sure to include the path to the file if it not in your current directory. You should see output simiar to the following.

connected to: localhost
imported 3772 documents

You should inspect the container to ensure that the data was properly loaded. Once you have done that, create queries that answer the following questions. You may use Java, NodeJS/Javascript, or MongoDB shell. Turn in a Java file "Assignment_7.java" or a Javascript file "assignment_7.js".c

1. Write a MongoDB query to display the fields restaurant_id, name, borough and cuisine for all the documents in the collection restaurant.
2. Write a MongoDB query to displays the the first 5 restaurants in the borough of the Bronx.
3. Write a MongoDB query to find the restaurant ID, name, borough and cuisine for those restaurants that contain 'Reg' as three letters somewhere in its name.
4. Write a MongoDB query to find the restaurants that are located at longitude value west of -74 degrees.
5. Write a MongoDB query to find the restaurants that do not prepare any 'American' cuisine and achieved a grade point 'A' (at least one 'A') not belongs to the borough Brooklyn. The document must be displayed according to the cuisine in descending order.
6. Write a MongoDB query to find the restaurant Id, name, borough and cuisine for those restaurants which belong to the borough of Staten Island or Queens or Bronx or Brooklyn.
7. Write a MongoDB query to find the restaurant Id, name, borough and cuisine for those restaurants which achieved a score which is not more than 10 (some score of 10 or less).

• DUE DATE: TBD by 11:59:59pm.
  

Chambers Twentieth Century Dictionary

Create a Java program that reads dictionary entries from a volume of Chamber's Twentieth Century Dictionary, and adds documents for each entry from "SAB to "SYZYGY" to a MongoDB collection named "chambers_20th_c_dictionary".. The dictionary file is located at: http://www.gutenberg.org/cache/epub/38700/pg38700.txt.

Dictionary entries are separated by empty lines, and may span multiple lines. A definition begins with a the word followed an optonal pronounciation, followed by definitions, followed by an optional derivation.

Documents have the following fields:

1. word: the word being defined
2. pronouciation: the ponenetic pronounciation of the word (optional).
3. derivation: the derivation of the word (optional).
4. definitions: an array of definition strings
5. note: definition note; usually a "see" reference in lieu of a definition.

If the word is terminated by a '.', the remaining text becomes a note and no further parsing is required for the entry:

SACRE. Same as SAKER.                
                

Otherwise, the word is terminated by a ', ' and a pronounciation follows.

If the pronounciation is terminated by a '.' the remaining text becomes a note and no further parsing is required for the entry:

SACQUE, sak. See SACK (1).
                

Otherwise the pronounciation is terminated by a ',' and one or more definitions and an optional derivation follows.

The derivation always appears at the end of the definition withing spare brackets:

SACODES, s[=a]-k[=o]'d[=e]z, _n._ a genus of beetles of the family
_Cyphonidæ_. [Gr. _sakos_, a shield, _eidos_, form.]
                

Remove the brackets around the derivation.

Definitions are separated by two dashes ("--"), provided the are preceeded by a period ('.') terminating the previous definition. Break the these into separate definitions, and add them to the document as an array. For example, the following has two definitions following the pronounciation:

SABURRA, s[=a]-bur'ä, _n._ a foulness of the stomach.--_adj._
SABURR'AL.--_n._ SABURR[=A]'TION, sand-baking: the application of a hot
sand-bath.      

Add the word, the definitions, and the derivation fields to the text index for the container. Also create a separate index for the word.

Develop a reasonable set of tests that query the definitions to demonstrate that the database is properly constructed. This might involve querying for a list of words and comparing the results to expected values or definition counts. It might also involve quering for certain alternate forms of words contained in the definitions (e.g. "SABURR'AL" in the definition for 'SUBURRA' shown above). Please come up with other tests as well that demonstrate that the database is properly constructed.

In the class GitHub repository 2018FACS5200SV/assignment-8 repository, you will find a Java class NewWorldDictionaryReader whose main funciton parses dictionary entries and sets variables for the fields. In the interest of time, you are welcome to use this as a starting point, but you may also write your own if you wish. If you find errors in the code, please feel free to make fixes, and to share your fixes with others in the class via Piazza.