Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

Design a Redis database to hold a list of ads and their attributes from statecollege.com auto listings.

Choose 4 ads. For example, consider the ad: http://www.statecollege.com/auto/dealers/stocker-chevrolet,9803/chevrolet/tahoe/cars/1GNSKAKC1FR254036/

This can be one.

Choose the attributes and information present in the ads. You must store at least the following attributes:

(a) Title: 2010 Toyota Prius

(b) Description: For example, http://www.statecollege.com/auto/dealers/stocker-chevrolet,9803/toyota/prius/cars/JTDKN3DU4A0064715// has the

DESCRIPTION: White 2010 Toyota Prius FWD CVT 1.8L 4-Cylinder DOHC 16V VVT-i 1.8L 4-Cylinder DOHC 16V VVT-i.We at Stocker Chevrolet appreciate your time and understand you have better things to do than shop for a new Chevrolet. That's why we price our online vehicles well below market averages! We want you to feel confident your not overpaying when you purchase your new Chevrolet at Stocker Chevrolet. Come in today and see why Stocker Chevrolet is the fastest growing Chevrolet dealerships in PA! Odometer is 53723 miles below market average! 48/51 Highway/City MPGAwards:* 2010 KBB.com Top 10 Green Cars * 2010 KBB.com Best Resale Value AwardsCall or email today to make an appointment with one of our GREAT GREAT sales professionals who will show you how easy it is to buy your new Chevrolet from Stocker Chevrolet!

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases DeMYSTiFieD

Authors: Andy Oppel

2nd Edition

0071747990, 978-0071747998

More Books

Students also viewed these Databases questions