Passing data from the browser to PHP using Ajax POST or
GET methods, and included the data as variables in the
SQL query.
Using 3
rd
party JavaScript library/package to display the
processed database results on the browser.
Using database results to update a specific browser content
without reloading the whole web page.
Setting and converting the time zone among the 3-tier
systems – the customer delivery address, vendors, and the
system web and database servers.
Displaying the results from the database on the browser for
users to select or change the content and save the changes
back to the original records in the database.
Understanding the data flow and client/server relationship
among the 1
st
tier, 2
nd
tier and 3
rd
tier.
Identifying and utilizing the different time among the 3-tier
programs.
V. METHODS OF ASSESSMENTS
It is important to assess students’ studying, identify their
weak spots and adjust the teaching pace. The assessments
include 3 parts – written exams, homework, and projects. The
exams should be around 60% of total final points. Homework
and project assignments should be 20% each.
There should be two quizzes (10 points/each), one
midterm (25 points) and one final assignment (25 points)
with two phases, or two different smaller projects. Students
are expected to spend total 40 - 60 hours on studying. It is
very import that instructors review answers with students.
The exams should include the conceptual questions,
hands-on skills, analysis, design and development of the
projects.
B. Projects
There should be one project assignment with three phases,
or three different smaller projects. The projects should
involve with 3-tier design and development – an interactive
user interface and display on the front-end browser as the
1
st
-tier, 2
nd
-tier programs run on the web server to receive
data from the browsers, process the data, interact with the
server, save data into the 3
rd
-tier database, receive the data
from the database and display the processed results on the
browser. The total points for all the projects will be 30 points.
Students are expected to spend total 40 - 60 hours on the
projects. Here are some examples:
Design and develop a mini-online store allows customers,
vendors to sign up, login, add products, place orders on
multiple products, and view the order history and sales
report. Students need to convert the time zones that could
be different among these entities.
Design and develop a web password reset system that users
can sign up, login, and securely reset the encrypted
password on the database through the web browser. The
system should send email to users to reset the password and
confirm the password is changed. The activities should be
logged.
Design and develop a web system that allows users to sign
up, login, enter the travel information (trip name, date,
multiple cities, states, countries, notes) on the browser and
save the data into the database. Then, users can select the
trip name to display the trip information and locations on
the Google Maps.
Design and develop a web cybersecurity data visualization
system that allow users to upload secure or Apache log
files, process the files to extract the IP address, date and
time, and other data, and save the information into the
database. Then, users can select and visualize the data on
the browsers in Google Charts – Table, Line Chart, and Pie
Chart formats, and view the data on the Google Maps.
Design and develop a web image management system that
allow users to upload images, save and move the image to
specific folders, shrink the images into thumbnail, and save
the image information (name, path, upload date, owner
name) into the database. Then, users can select and view
the image on the browser.
Design and develop a web system that users can copy/paste
or upload a Java source code, save the code into a file,
compile and run the program. The system should show the
error message on the browser if there is any compile or run
time error. If there is no error, the system should show the
results of running the Java program on the browser.
Design and develop a web system that can ping and detect
whether the given server names are alive or not, and
display the status in different colors [9] on the browser.
C. Extra Study
If students wish to do the project on a 2 or 3-tier
architecture on 2 different operating systems, they can
consider to use the virtual machine. Oracle Virtualbox [10] is
a virtual machine that can host different kinds of Operating
Systems, such as Ubuntu [11], which is a popular Linux
Operating System. A Shell prompt is shown in Fig. 9 with
Virtualbox version 5.2.18 and Ubuntu Linux server
18.04.1-live. The Linux system is a better Operating System
than MS-Windows for students to learn the server
environment in the following topics:
Process status
Scheduling – cron job
Permission mode
Context switch
File systems
Fig. 9. The Ubuntu Linux system is installed on the Virturalbox. The $ is the
Linux command shell prompt.
Fig. 10. The Linux “top” command can show the process and system running
information.
International Journal of Information and Education Technology, Vol. 9, No. 5, May 2019
322
A. Exams