DOC PREVIEW
SJSU CMPE 226 - Travel Information System

This preview shows page 1-2-3 out of 8 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 8 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 8 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 8 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 8 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

Binbin Lai and Tong LiCMPE226 Project#1 Problem StatementTitle: Travel Information SystemBinbin Lai and Tong LiDescriptionThe objective of our project is to find the information of restaurants, shopping centers, gas stations, hotels, cities near the highway for the convenience of travelers. W provide a map of roads I-101, I-280, I-680, I-880 and locations of exits, cities, restaurants, shopping centers, hotels, gas stations on the road.Suppose that we are currently driving north on I-880, and we know about thecurrent location of our car from GPS (Global Point System). We have the following entities defined:Current_Pos(road, x, y)This table is used to store the current location of the traveler.The attribute "road" represents the current highway we are driving on.The current location on the map is indicated by the values of the attributes "x", "y". Route(road, x, y)This table is used to store the map of road I-101, I-280, I-680, I-880. The map of each road is represented by tuples of constraints.The value of the attribute "road" is one of the following: 101, 280, 680, 880.The attributes "x", "y" are used to represent the location of any points on theroad on the map.Binbin Lai and Tong LiExit(road, id, x, y )This table is used to store the location of exits on the roads.The attribute "road" could be used to refer to the Route table.The value of the attribute "road" is one of the following: 101, 280, 680, 880.The attribute "id" means the exit number, whose value is unique for each road.The attributes "x", "y" are used to represent the location of the exit on the map.Note: Since the MLPQ system wouldn't accept such design, we used four relations instead, which includeExit_101(ex, x, y)Exit_280(ex, x, y)Exit_680(ex, x, y)Exit_880(ex, x, y)The attribute "ex" means the exit number, whose value is unique for each road.The attributes "x", "y" are used to represent the location of the exit on the map.Restaurant(code, x, y, rating, price_from)This table is used to store the information of restaurants including location, rating and lowest price.The value of "code" is unique for each Restaurant.The location of the restaurant is represented by the attributes "x", "y".The value range of the "rating" attribute is from 1 to 5, of which 5 is the bestrating.The attribute "price_from" is used to describe the lowest price of a lunch for two in the restaurant.Note: Since the MLPQ system wouldn't accept such design, we used two relations instead, which include:Restaurant(code, x, y )This table is used to store the key information of restaurants including location.The value of "code" is unique for each Restaurant.The location of the restaurant is represented by the attributes "x", "y".Rate_Rst(code, rating , price_from)Binbin Lai and Tong LiThis table is used to store the detailed information of the restaurant including the rating and the lowest price of a lunch for two.The value of "code" is the foreign key referring to the Restaurant table.The value range of the "rating" attribute is from 1 to 5, of which 5 is the bestrating.The attribute "price_from" is used to describe the lowest price of a lunch fortwo in the restaurant.Shoppingcenter(center, x, y, rating, size )This table is used to store the information of shopping centers including location, rating, and size of the center.The value of attribute "center" is unique for each Shoppingcenter.The value range of the "size" attribute is from 1 to 10. And 10 is the largest.The location of the shopping center is represented by the attributes "x", "y" .The value range of the "rating" attribute is from 1 to 5, of which 5 is the bestrating.The value range of the "size" attribute is from 1 to 10. And 10 is the largest.Note: Since the MLPQ system wouldn't accept such design, we used two relations instead, which include:Shoppingcenter(center, x, y)This table is used to store the information of shopping centers including the location .The value of attribute "center" is unique for each Shoppingcenter.The value range of the "size" attribute is from 1 to 10. And 10 is the largest.The location of the shopping center is represented by the attributes "x", "y" .Size_Shop(center, rating, size )This table is used to store the information of shopping centers including the rating and size .The value range of the "rating" attribute is from 1 to 5, of which 5 is the bestrating.The value range of the "size" attribute is from 1 to 10. And 10 is the largest.Gasstation(station, x, y, service, price_from)This table is used to store the information of gas stations including the location, service, and lowest price.The value of attribute "station" is unique for each Gasstation.The location of the gas station is represented by the attributes "x", "y".The value range of the "service" attribute is from 1 to 3. And 3 is the best.Binbin Lai and Tong LiThe attribute "price_from" describes the lowest price for oil.Note: Since the MLPQ system wouldn't accept such design, we used two relations instead, which include:Gasstation(station, x, y)This table is used to store the information of gas stations including the location.The value of attribute "station" is unique for each Gasstation.The location of the gas station is represented by the attributes "x", "y".Service_Gas(station, service, price_from)This table is used to store the information of gas stations including the service, and the lowest price of oil per gallon.The value of attribute "station" is the foreign key referring to the Gasstation table.The value range of the "service" attribute is from 1 to 3. And 3 is the best.The attribute "price_from" describes the lowest price for oil.Hotel( htd, x, y , rating, price_from)This table is used to store the information of hotels including the location, rating, and lowest price.The value of attribute "htd" is unique for each Hotel.The location of the hotel is represented by the attributes "x", "y".The value range of attribute "rating" is from 1 to 5. And 5 is the best.The attribute "price" means the price of one standard room per day of stay.Note: Since the MLPQ system wouldn't accept such design, we used two relations instead, which include:Hotel( htd, x, y )This table is used to store the information of hotels including the location.The value of attribute "htd" is unique for each Hotel.The location of the hotel is represented by the attributes "x", "y".Rate_Hotel(htd, rating, price_from)This table is used to store the information of hotels including the rating and price.The attribute "htd"


View Full Document

SJSU CMPE 226 - Travel Information System

Documents in this Course
SQL-99

SQL-99

71 pages

XML

XML

52 pages

XML

XML

14 pages

Chapter 9

Chapter 9

45 pages

Load more
Download Travel Information System
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Travel Information System and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Travel Information System 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?