CSc 8711. Databases and the Web (Programming Project 2)

CSc 8711. Databases and the Web
Spring 2005, Programming Project 2 (Multi-Dimensional Database Search Interface)
Due: 18 February, 2005

Consider the database schema is available at db-schema.sql. This database stores information about a large number of entities in a "fact" table. Each entity is described by a number of properties and the information about these properties are also recorded in the database.

The system has users signing in (through a simple sign-in screen) and performing searches in the database. They have the ability to "bookmark" a particular search that they would like to return to in a later session.

The search interface should have 3 separate sections (you may use frames or some other technique): A bookmarks section that displays the users bookmarks, a workspace section where at any time 3 properties are displayed for the user to choose from, and a results section where the results of a search are displayed.

The bookmarks section should display each bookmark as a hyper-link. Upon clicking the bookmark, the corresponding selections should be displayed in the workspace area (starting with the first 3 properties). A "Remove" button placed next to the hyper-link would allow the user to delete a bookmark.
The workspace section should have 3 properties listed followed by a "Get Results" button, a "Start Over" button, a "Next Page" button, a "Previous Page" button, and a "Bookmark" button.
The results area should display the hyper-links of "entities" that satisfy the search conditions. These results should be displayed only when the user clicks the "Get Results" button in the workspace.

You should implement the "Search Interface" in such a way that the programs will not need any modification when we change the entities and their properties in the database. Besides the "Search Interface" each of you will build a data entry page for the fact table. Using this data entry page, each of you will generate 10 rows in the fact table. We will accumulate all these facts and generate a large enough data set. Please place this data file (containing at least 10 SQL insert statements) in your public_html directory under file name data.sql.

Consolidated data is available at data.sql

Data Entry Assignments:

adhawan1: Alabama
gbays1: Arizona
krana1: California
mpandya1: Florida
smetikurke1: Georgia
vrangaswamy1: Illinois
asadanandan1: Indiana
hbotadra1: Iowa
lyu2: Kansas
nviswanath1: Kentucky
sabedi2: Louisiana
tle3: Maryland
ycho4: Michigan
dbrinza1: Minnesota
ifaridi1: Missouri
mbajpai1: Nevada
ouli: North Carolina
schevuru1: New Jersey
vbhardwaj1: New Mexico
yqiu2: New York
dchen2: Ohio
jjoshi1: Pennsylvania
mgopalan1: South Carolina
rgupta3: South Dakota
sjandhyala1: Tennessee
vjain2: Texas
bthakker: Utah
jpamplin1: Vermont
htian1: Virginia

CSc 8711. Databases and the Web Spring 2005, Programming Project 2 (Multi-Dimensional Database Search Interface) Due: 18 February, 2005

CSc 8711. Databases and the Web
Spring 2005, Programming Project 2 (Multi-Dimensional Database Search Interface)
Due: 18 February, 2005