To design simple and develop a three tier database-driven web site.

  • Posted:
  • Proposals: 0
  • Remote
  • #1808
  • Archived
  • 0


Experience Level: Intermediate

To design and develop a three tier database-driven web site.


A system is required that allows students to maintain an account for purchasing
educational items from "A-Software stores". The account can be topped up by cash
payment to stores. Educational items such as DVDs, software and course notes are
identified by their barcode number, and can be associated with any number of
modules. Students can access a web-based catalogue of these items, and add
any of interest to their shopping basket. When they wish to complete the purchase they
must visit stores where they may collect these items %u2013 provided they are in stock, and
provided there is sufficient money in the student%u2019s account. The technicians in stores
manage this system also using a web-based interface.


Students using this system can

S1. View all educational items in the catalog, including the amount in stock.
S2. View all relevant items %u2013 those which are associated with modules the student is actually taking %u2013 including the amount in stock.
S3. Add an item to their shopping basket.
S4. Remove an item from their shopping basket.
S5. View their basket and account balance.

Technicians in stores can

T1. Allow students to top up their account with a cash payment
T2. Complete a purchase by providing a given student with the items in their
shopping basket %u2013 and the system will deduct the total from their account, and
reduce the amount of these items in stock accordingly.
T3. Add new items to the stock as they arrive
T4. Associate an item with a module code.

To reduce the need for repetitive coding, you are required to implement just three of these requirements: S2, S3, and T2,.

database should include tables with the following information only:

%u2022 Item(barCode, description, amount);
%u2022 user(userID);
%u2022 Account(userID, money);
%u2022 Basket(userID, barCode, amount);
%u2022 Associated(barCode, moduleCode); and
%u2022 Taking(userID, moduleCode).

Here Item gives the description and amount in stock of each item, Associated shows
which module or modules a given item is relevant to, and Taking shows which modules a
user is registered as taking. You should (manually or automatically) fill these tables with a dozen or so entries for testing purposes.

Please do not implement a password protected login system as these would make your
web site harder to test. Instead, each user logs in by providing just their Student ID. Note that, as there is no barcode reader available for your use, system
must allow item codes to be entered manually.

implementation must be in PHP, HTML and MySQL. Please make sure software is compatible with xp.

You need include a suitable interface; for example an opening page which contains a link
to a student page and a link to the technician%u2019s page, etc. Note that the user interface must be easy to use. Also note that simple implementing requirement of the above only other than the three given above. I realise that a fully working retail site would include
many additional features, but these would require far more time than I have available
to work on this assignment. Simple system only as above only

a short A4 report explaining the architecture of your system %u2013
not longer than 2 pages. Include, in an appendix, a print out of your SQL create table statements and a printout showing the content of each table. Please do not include
screen-shots, UML diagrams, nor any other graphical material.

a report should summarise the structure of your implementation, and in particular
which source code files I must read to find where you have made use of
%u2022 sessions to maintain the logged in user%u2019s ID;
%u2022 a multi-table SQL select or join query to look up the list of relevant items.

You should expect to spend around 10 hours on this assignment.

other Requirements

1) A short A4 report (hardcopy) explaining the architecture of the system %u2013
not longer than 2 pages. Include, in an appendix, a print out of your SQL create
table statements and a printout showing the content of each table.

2) A CD ROM containing HTML pages, PHP files and the contents of your
Mysql folder. The CD Rom content must work under Windows XP, tested using the Apache web server.

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.