Assignment 2 Page 1 of 5 CS 490 W2022 UW
Lab 6: Three-tier Client/Server Architecture
Instructions:
1. This is an individual homework. Each student must submit his/her solution using the
dropbox.
2. All submissions are to be via the LEARN Submission System; no other way of
submission is accepted.
3. All submissions must be submitted through the dropbox by the due date or by the closure
date, Clouse Date allows 3 days for late submissions.
Purpose and Objective
The purpose of this assignment is to demonstrate an implementation Transaction Processing
System.
Success Criteria
Demonstration of multitier client/server architecture.
Keywords
The ACID Properties, Web server, application server, database server, InnoDB. Distributed
databases, blockchain.
Readings
- Chapter 6.
- Chapter 7.
- You should submit an assignment report as well as copies of the scripts in Word File
Format or Acrobat Reader File Format.
Resources:
- PHP Documentation: https://www.php.net/docs.php.
- MySQL Documentation: https://dev.mysql.com/doc/
- Apache Documentation: https://httpd.apache.org/docs/
Software Download:
- XAMPP 5.6.4 for Windows:
https://sourceforge.net/projects/xampp/files/XAMPP%20Windows/5.6.40/
- XAMPP 5.6.4 for Mac
https://sourceforge.net/projects/xampp/files/XAMPP%20Mac%20OS%20X/5.6.40/
Assignment 2 Page 2 of 5 CS 490 W2022 UW
Part 1: Server-side Interaction
1. Install version 5.6.4 XAMPP platform. Start the Apache server, the MySQL server, and test
PHP by parsing the info.php script at the localhost.
2. Implement the data retention script and test it by inserting suitable data:
- The script captures your name (first and last), username, and password; the script should
also display those values.
Lab 6 Page 3 of 5 CSI 3140 S2023 UOTTAWA
Part 2: Datastore and Database Interaction
3.1 Write a script that validates user credentials that are stored in a datastore of type array
- Test the script for a valid user as well as an invalid user.
3.2 Create a database “auth” that would store credentials of users; also, create the table
“credentials” as per the following SQL statement:
CREATE TABLE `credentials`.`auth` ( `email` VARCHAR(50) NOT NULL ,
`password`VARCHAR(10) NOT NULL , `salt` INT NOT NULL , `comments` INT NOT
NULL ) ENGINE= InnoDB;
Lab 6 Page 4 of 5 CSI 3140 S2023 UOTTAWA
3.3 populate the table with the following data:
INSERT INTO `auth` (`email`, `password`, `salt`, `comments`) VALUES
('abdul@uottawa.ca', 'abc123', '10', '');
INSERT INTO `auth` (`email`, `password`, `salt`, `comments`) VALUES
('dave@uottawa.ca', 'pqr123', '20', '');
INSERT INTO `auth` (`email`, `password`, `salt`, `comments`) VALUES
('john@uottawa.ca', 'aaa123', '30', '');
3.4 Connect to the auth Database by creating the script a1.php:
3.5 Modify lines 14 and 19 through 25 in section 3.1 so that the user is authenticated using
the database credentials rather than the array values:
3.6 Add one additional record in the database that represents your email address and a
password.
3.7 Test the authentication scheme using your email address and a password.
3.8 Provide a screen snapshot of the your database record and testing of the credentials using
Lab 6 Page 5 of 5 CSI 3140 S2023 UOTTAWA
screen snapshots. Parse all of the scrips on the localhost and document the outputs.