Answer the questions in each assignment
Sheet1 TRUE BELIEVERTHE DA VINCI CODETHE WORLD IS FLATMY LIFE SO FARTHE TAKINGTHE KITE RUNNERRUNNY BABBITHARRY POTTER U115 3 35 U254 321 U33 1225 U43413 U524322 U653131 U7145524 U821451 U9 3225 U1035144 U11 2123 U12442114 U13 2445 U14 533211 U152332 U16321144 U17151244 U185 43345 U19 42515 U202511534 NU1354235 NU2522413 Sheet1 inst#Actual ResponseCumm. Pos. Response 1YES1 2NO1 3YES2 4NO2 5NO2 6NO2 7NO2 8YES3 9NO3 10YES4 11NO4 12YES5 13NO5 14NO5 15NO5 16NO5 17NO5 18YES6 19YES7 20NO7 21NO7 22NO7 23YES8 24NO8 25NO8 26NO8 27NO8 28NO8 29YES9 30NO9 31NO9 32YES10 33NO10 34NO10 35NO10 36YES11 37NO11 38NO11 39NO11 40NO11 41NO11 42NO11 43YES12 44NO12 45YES13 46NO13 47NO13 48NO13 49NO13 50NO13 51NO13 52YES14 53YES15 54NO15 55NO15 56NO15 57NO15 58NO15 59NO15 60NO15 61YES16 62NO16 63YES17 64NO17 65NO17 66NO17 67NO17 68NO17 69NO17 70NO17 71YES18 72NO18 73NO18 74YES19 75NO19 76NO19 77NO19 78NO19 79NO19 80NO19 81NO19 82YES20 83NO20 84NO20 85NO20 86YES21 87NO21 88YES22 89NO22 90YES23 91NO23 92YES24 93NO24 94NO24 95NO24 96NO24 97YES25 98YES26 99NO26 100NO26 101NO26 102NO26 103NO26 104NO26 105NO26 106NO26 107YES27 108NO27 109NO27 110NO27 111YES28 112YES29 113NO29 114NO29 115NO29 116NO29 117NO29 118NO29 119NO29 120NO29 121YES30 122NO30 123NO30 124NO30 125NO30 126NO30 127NO30 128NO30 129NO30 130NO30 131YES31 132NO31 133YES32 134YES33 135YES34 136NO34 137NO34 138YES35 139NO35 140NO35 141NO35 142NO35 143NO35 144NO35 145NO35 146YES36 147NO36 148NO36 149YES37 150NO37 151NO37 152NO37 153NO37 154YES38 155YES39 156NO39 157NO39 158NO39 159NO39 160NO39 161NO39 162YES40 163NO40 164YES41 165NO41 166YES42 167YES43 168NO43 169NO43 170NO43 171NO43 172NO43 173YES44 174NO44 175NO44 176NO44 177NO44 178NO44 179NO44 180NO44 181NO44 182YES45 183NO45 184YES46 185NO46 186YES47 187NO47 188NO47 189NO47 190NO47 191YES48 192NO48 193NO48 194YES49 195NO49 196NO49 197NO49 198YES50 199NO50 200NO50 DS 220: Assignment 3 1. Install Redis on your machine. Mac OS: After downloading, open a terminal (click on Go and then on Utilities and then on terminal). Then, follow the following instructions: http://jasdeep.ca/2012/05/installing-redis-on-mac-os-x/ and http://redis.io/topics/quickstart Windows: Download executable from here: https://github.com/rgl/redis/downloads and http://stackoverflow.com/questions/6476945/how-do-i-run-redis-on-windows New versions come out all the time. So, you will have to figure out what is not working on your machine. For example, if your machine does not have XCode on Mac, you may have to download it. 2. Design a Redis database to hold a list of ads and their attributes from statecollege.com auto listings. 3. Choose 4 ads. For example, consider the ad: http://www.statecollege.com/auto/dealers/statecollegemotors-com,6547/audi/a4/cars/WAUENAF40HN029405/. This can be one. 4. Choose the attributes and information present in the ads. You must store at least the following attributes: (a) Title: 2017 Audi A4 at StateCollegeMotors.com (b) Description: For example, http://www.statecollege.com/auto/dealers/sutliff-buick-gmc-cadillac,55999/buick/regal/cars/2G4GM5EX2H9116237/ has the Description: BLUETOOTH!!!, REAR BACK UP CAMERA, 8 COLOR TOUCHSCREEN RADIO, ALL-WHEEL-DRIVE, NAVIGATION, HEATED LEATHER SEATS, and POWER SUNROOF. 2.0L 4-Cylinder DGI DOHC VVT Turbocharged, 6-Speed Automatic, AWD, Light Neutral With Cocoa Interior Accents, 2-Way Adjustable (Up/Down) Front Head Restraints, 2-Way Power Driver Lumbar Seat Adjuster, 4-Wheel Disc Brakes, 7-Speaker Audio System Feature, 8-Way Power Driver Seat Adjuster, ABS brakes, Alloy wheels, Brake assist, Dual front side impact airbags, Electronic Stability Control, Four wheel independent suspension, Front dual zone A/C, Front fog lights, Heated door mirrors, Heated front seats, Leather-Appointed Seat Trim, Outside temperature display, Overhead airbag, Power passenger seat, Power Tilt-Sliding Moonroof w/Sunshade, Radio: Buick IntelliLink AM/FM Stereo w/Navigation, Remote keyless entry, Single-Slot CD/MP3 Player, SiriusXM Satellite Radio, Speed control, Speed-sensing steering, Split folding rear seat, Steering wheel mounted audio controls, Telescoping steering wheel, Traction control, and Turn signal indicator mirrors.Be the talk of the town when you roll down the street in this wonderful 2017 Buick Regal. This spirited machine can turn the everyday driver into a gearhead as they experience a whole new kind of acceleration and exceptionally potent power.We are a Franchised BUICK Dealership for warranty, parts and service. For ads where there are no descriptions, update your database accordingly. At least choose one ad with a description. If you cannot store very large text, make some assumptions and design decisions, and adjust accordingly. Let us know in your report what design decisions you had to make. (c) Location of the seller (d) Year of the Car (e) Number of miles (f) An attribute called seller with sub-attributes name, address and phone number Report: (a) A design document telling us your database design and what choices you made and why, (b) Print out your program/screen shot of what you did and submit. Homework 4: MongoDB Run MongoDB Locally Run a MongoDB instance on localhost so you can connect from a client Task 1. Install MongoDB for you platform 1. Go to https://www.mongodb.org/downloads 2. Find you platform 3. Download 4. Follow the installer Task 2. Run a server If you are using windows and MongoDB is installed in Program Files you’d need to use Administrative role 1. Open command prompt as administrator 2. Navigate to MongoDB root 3. Create a folder “data” 4. Run “mongod –dbpath ../data” Additional Information: Here are some resources for installing mongodb on mac: 1) install homebrew (http://brew.sh/index.html) 2) install mongodb with home-brew (http://treehouse.github.io/installation-guides/mac/mongo-mac.html) 3) import restaurant data (https://docs.mongodb.com/getting-started/shell/import-data/) 4) I have tried the top 5 queries, and they look good. To install mongodb on Windows: https://docs.mongodb.com/manual/tutorial/install-mongodb-on-windows/#install-mongodb-community-edition To log what you are doing on Unix, please use the script command. Do a “man –k script” to learn more about the script command. The default filename is typescript that is created in the current working directory. You can get the output of script going to a different file by using the command line option. For logging scripts on windows use powershell: http://sharepointjack.com/2013/simple-powershell-script-logging/ I do not care which logging script or screenshot you use, but, I need some evidence that all the tasks identified below are done. Task 3. Practice all of the following exercises http://www.w3resource.com/mongodb-exercises/ Submit the screenshot. You should do the exercise first and only if you cannot do it, look at the answers. Task 4. Insert the data that you inserted in your redis database in Hw3 into this MongoDB database. Task 5. Upsert data (e.g., one record from the car sales website) into your MongoDB database. Perform the same data into your redis database. Task 6. Query your data from both databases. Task 7. Query aggregate data for a query of this type. Find me Audis that are under 50,000 miles being sold by a dealer in State College for under $20,000 on both queries. Feel free to change “Audis” to whatever car makes are in your database. Perform the query for one car make in your database and for one car make not in your database. Submission: Submit a log of your work. Include a short writeup (if necessary) to help us understand what you did.