Assignment Instructions

ITECH3108 Dynamic Web Programming Assignment 1 Watch Basement Overview This is an individual assignment in which you are required to develop a dynamic web application as described below..

ITECH3108 Dynamic Web Programming

Assignment 1 – Watch Basement


This is an individual assignment in which you are required to develop a dynamic web application as described below.

Important: This assignment specification is generated just for student id 000000. Do not distribute this specification.
Timelines and Expectations

Percentage value of task: 20%

Due: Refer to Course Description

Learning Outcomes Assessed

The following course learning outcomes are assessed by completing this assessment:

K3. Detect opportunities for increasing security and privacy of web applications

S1. Develop client/server web applications using client-side and server-side code

S2. Connect to and manipulate a database management system programmatically using server-side code
A1. Design, develop, test, and debug client/server web applications to provided specifications

Assessment Details

For this assignment, you will create an online marketplace – a bit like Facebook Marketplace or eBay.

Your marketplace, Watch Basement is dedicated to community members selling or exchanging watches with other local members.

Users can create accounts, browser watches that are up for sale or exchange, make an offer, and message the winner to arrange the exchange.

You must implement this platform using PHP and MySQL or MariaDB, with some JavaScript for validation.

Database Structure

The web application uses a relational database. The database has the following structure:

User ( id, name, email, password, location )

Watch ( id, user_id, title, description, seeking, submitted )

Offer (id, user_id, watch_id, offer, accepted, submitted)

Message (id, from_user_id, to_user_id, offer_id, sent, text)

CRICOS Provider No. 00103D Page 1 of 6



PK id





PK id

FK user_id

FK watch_id





PK id

FK from_user_id

FK to_user_id

FK offer_id




PK id

FK user_id





Primary keys are indicated with underlines or bold formatting, and foreign keys are italicized.

Each record in the User table represents a member of the site. Members can add watches to the site, and review and make offers on the watches added by others.

Each record in the Watch table represents a watch that a user has put up for sale or exchange. The seeking field is free text and indicates what the user is willing to accept in exchange for the item.

The Offer table stores offers made by other users for a particular watch. Users may make multiple offers for a single item.

Finally, Watch Basement should allow members to send messages to each other to arrange the exchange. The Message table tracks messages sent between members about a particular offer, along with the date and time that the message was sent.

The following constraints should be applied when implementing the application:

The User password field should be a VARCHAR of 255 characters. The name, email, and location fields should be VARCHAR of a length that you determine to be reasonable and sufficient;
The Message.text and Offer.offer fields may be either VARCHAR or TEXT.

The Watch.submitted, Offer.submitted, and Message.sent fields should all be be MySQL

CRICOS Provider No. 00103D Page 2 of 6


The Offer.accepted field can be either a Boolean indicating whether this offer was successful, or a nullable TIMESTAMP indicating when the offer was accepted.
Only one offer may be accepted per watch – this is not enforced by the database design but must be enforced by the application. You may change the schema to make it enforced by the database if you prefer.

Please note that you are free to extend this database schema if required.

Initial Data

When the database is created, it should be populated with data of your own invention, appropriate to the theme (keep it clean).

You should have at least:

5 users;

3 watches;

5 offers, at least one of which is submitted by the tutor user, and accepted by the seller; and

3 messages about a single accepted offer

One of the users must be you (even if you are not interested in watches). Use your student id – 000000 – for the username, and your real name and email address.

One of your users must have the username tutor and the password guest.

Invent other users as necessary – perhaps use characters from your favourite movie or band.

Include this data as part of your written report.

Database creation DDL

Create a single SQL file that creates the MySQL database, creates the four tables above, and populates them with your initial data.

Use your student id and course code as the database name as follows:


Passwords should be hashed using, at minimum, the crypt() PHP function. Prefer to use the PHP password_hash() function to generate password hashes.

For the password ‘guest’, the following hash may be used in your database:

PASSWORD = ‘$2y$10$123000000000099999999upbG63KDvHpam5TTLh.6xxCvYZFPYZcq’

It is acceptable for all initial users to share the same password for testing.

Use of MD5 or SHA1/2 for password hashes is not acceptable.

Write SQL queries that display all of the initial data using SELECT statements, and list these queries in your report.

CRICOS Provider No. 00103D Page 3 of 6

User accounts

Write PHP and HTML to allow new users to sign up. The form should request a username, email address and password. The password must be hashed before storing it in the database.

Using PHP, validate that the username is unique, and the password is at least 5 characters (before hashing).

Write PHP code to allow users to log in and log out. This will require the use of sessions and/or cookies.

Viewing items

Write PHP and HTML to allow users to view a list of all items currently offered, including any offers made for each. The list should be sorted so the most recent items are listed first.

Watches with accepted offers should still be displayed, but highlighted in some way, including highlighting the successful offer.

You may implement this using whatever User Interface approach makes sense to you.

Making and Accepting O ers

Write PHP and HTML that allows users to make an offer on a particular watch.

This should only work on items that don’t have accepted offers.

Users should be able to review offers made on their watches, and accept one.


Write PHP and HTML to allow the users in an accepted exchange to message each other.

Create a messages page that displays the messages sent and received by the logged-in user, including the date and time for each message.

Aggregate data

Create a page that displays the following information, using SQL aggregation such as COUNT and SUM, subqueries or nested SELECT statements, inner joins and (left or right) outer joins.

The total number of watches on the site;

The top 3 most-wanted watches, ordered in descending order by number of offers made;

Bonus challenge task (optional!) – Moderation

Extend the data model and write code to implement moderation features:

Users can report users for violating site rules (for example, by posting inappropriate offers);

A moderator can review reported users, sorted by number of reports, weighted by the reporting user’s reputation (descending order)
Users found to be in violation of site rules should have their accounts disabled, but should not be deleted

Users who incorrectly report users for being in violation when they are not should have reputation reduced, so their reports are less important in future
Users who correctly report other users should have their reputation increased, so their reports are more

CRICOS Provider No. 00103D Page 4 of 6

important in future

There are no partial marks awarded for this bonus task – you must complete all features to attain the bonus marks.

It is possible to attain full marks for this assignment without completing this challenge task.

Further details


Include a written report containing:

The SQL queries you used to test your database

A list of parts of the assignment you have completed or not completed.

Details of specific assistance you received from people other than your lecturer or tutor, and the names of those assisting.
Anything interesting or cool you’d like to draw your marker’s attention to.

Assignment support

This assignment is supported by the first 5 lectures and the first 6 labs. Work on the assignment should be spread over several weeks after the relevant lab has been mastered.

All files should be submitted to Moodle by the due date and time. Check with your tutor as to whether a hard copy is required in addition to the electronic submission.
Marking Criteria/Rubric

Refer to the attached marking guide.


Feedback will be supplied through Moodle. Authoritative marks will be published through fdlMarks


Plagiarism is the presentation of the expressed thought or work of another person as though it is one’s own

without properly acknowledging that person. You must not allow other students to copy your work and must

take care to safeguard against this happening. More information about the plagiarism policy and procedure

for the university can be found at

CRICOS Provider No. 00103D Page 5 of 6

Marking Guide: Assignment 1

Feature Criteria Maximum Obtained

Initial data Requirements satisfied 1
Creating the database Table structure, data types, field lengths, initial 1
data entry

Account sign-up 1

Validation that password meets complexity 1
requirements (at least 5 characters)
User accounts

Log in and Log out 1

Inappropriate password hashing (MD5, SHA1 or (-2)
plain-text passwords)

Viewing items List of all items 2

Unavailable and accepted offers indicated 1

Users can make an offer on an item 2

Making offers Offers only on available items 1

Users can review offers made on their items 2
Messages Send a message to a user 2

List messages from other users 2

Aggregate data Total items on the site 1

Top three most-wanted items 1

Bonus optional task – Meets specification (user report, moderator list, (+3)
Moderation reputation system) (no partial marks)

Initial data and test queries 1
Completion of tasks, Assistance statement (lose (-2)
1 mark each if not included)

Layout, structure, indentation (-1)

Quality of code Appropriate and consistent naming scheme (-1)

Valid HTML5 (-1)
Total: 20

CRICOS Provider No. 00103D Page 6 of 6

ITECH3108 Dynamic Web Programming Assignment 1 Watch Basement Overview This is an individual assignment in which you are required to develop a dynamic web application as described below.

Calculate Price

Price (USD)

Why Choose Us For Your Assignment?


We value all our customers' privacy. For that reason, all information stays private and confidential and will never be shared with third parties.


With our service you will never miss a deadline. We use strict follow-ups with our writers to ensure that all papers are submitted on time.


We have no tolerance for plagiarism. All papers go through thorough checking to ensure that no assignments contain plagiarism.

Money Back

You feel unsatisfied with your results? No worries. We offer refunds to our customers if any paper is not written according to the instructions.

Clients Love Us

Client #121678
Client #121678
Read More
This is by far the best I have ever scored in a custom essay. I am surprised the writer handled this assignment so well despite the short notice. I will definitely use your service next time.
Client #21702
Client #21702
Read More
When I was recommended to you by my friends, I wasn't sure you could deliver excellent results for Masters research papers until I submitted my first order. I am all yours now.
Client #20730
Client #20730
Read More
Excellent Services! You are the only assignment helper I can rely on. I have worked with many before and your services are exceptional. I have recommended you to my friends and the results are similar.
Client #20387
Client #20387
Read More
I rarely write reviews online but your services are worth promoting. My paper was so urgent I was sure I was gonna miss the deadline but you turned things around. You are awesome!
Client #20189
Client #20189
Read More
I am a satisfied customer. I know I should have given a 5 star because you deserve it but I will give 4.6 because I almost missed a deadline because of a revision. Luckily it was minor and the writer acted promptly.
Client #20187
Client #20187
Read More
Great paper but there is still some room for improvement. I am impressed by your fast responses and how you tacked my concerns professionally. Thank you for being among the few genuine essay writing service providers.
Client #19783
Client #19783
Read More
I can't thank you enough for being a great part of my college life. I recommended you to two more of my friends. I am sure they will be making their orders soon. I love the fact that you offer free pages for referrals. I will be referring a few more and maybe I won't have to pay for my next two paper, LOL.