Term Project Solution

Description

In this term project, you are going to setup a fake online bookstore system, with MySQL as the backend database. In summary, What you need to do:

1. Setup your database with the provided data;

2. Create a web interface interacting with the backend database;

3. Correctly Implement the queries in SQL.

Interface

Three UI components are required, all other things are optional.

As shown on the figure right:

1. info area 10 points, where you should print all the tables in the database

2. input form 35 points, where I could input SQL statement and submit it to the server to execute. Note: your input form should NOT accept “DROP” operation.

3. result area 5 points, where either error message or the results show here

The layout of the UI is all up to you and you don’t have to make it nice looking. The three components may not be on the same page if you like.

Data and Queries

In the data.zip, there are csv and txt files. The csv files are the data you need to put into your database, while the query.txt contains 20 queries you need to implement in SQL language, which I will test through your webpage.

Data.zip file can be downloaded in canvas.

Deliverable

What you need to turn in is a zip file, named like your_auburn_username.zip which should contain:

1. url.txt contains the URL to your webapge

2. sql.txt contains all your sql statements, one per line

3. src/ a folder containing your source code

Request the SQL database

1. To request for access to the SQL database, please fill in the request form here. Remember you will need to wait for 2-3 daysfor your account to be activated.

2. To access your database through SSH, open an SSH session or application (SecureCRT is recommended)

mysql -h acadmysql.duc.auburn.edu -u username -p

replace the username with one specified in your confirmation email.

When you got a mysql> prompt, type following:

use name;

replace the name with database name in your confirmation email.

3. All OIT web development instructions could found here.

Login to Mallard

Note that you could only login to Mallard on campus using AU_Wifi or lab computers.

1. Download PuTTY if on Windows.

2. Type in ssh username@mallard.auburn.edu

3. The folder public_html is the root of your web server.