UChoose Project

This year's project is to create a PHP/MySQL application for an online club membership and ticketing agent.

The draft specification is contained in the linked document below. This will be evolving an evolving document for about a week or so, as student queries will likely result in tighter specifications. Please post (and definitely view) any queries on help3240.

• UChoose System Specification (released Wed 7 May)

Submission

Your submission should consist of the following items, all to be submitted through csmarks by 3 pm on Wednesday June 4.

1. The URL(s) of your working UChoose system contained within the file named README.
2. A zip or tar archive of your entire system.
3. A 5-7 page group report (one for the whole group)

Submitted through the CSSE front office with a signed cover sheet (by the same deadline)

1. A 1 page personal report (one for each person)

The URL(s) should be the location of the main page(s) of your system which will be located somewhere under http://db3240X.csse.uwa.edu.au; there will probably be a main administrators page and a main public page. Put these details in the README file, along with any specific instructions or warnings about incomplete features etc.

You should archive all your working files on the file system and submit them to as a single archive so that they can easily viewed for assessment.

The 5-7 page group report should describe the design of your system, and the design process. This should include an ER diagram, a description of how the ER diagram was implemented as tables, brief discussion of the database structure and any interesting points of your design. Part of this discussion will be the major issues you confronted in the schema design, and how and why you came to your chosen solution. Do not just list the database schema (I can read that for myself from your archive submission).

The 1-page personal report should consist of your personal experience of how the group worked, what you learned and the relative contributions that you made and that the others in your group made. The relative contribution will be measure in the following way. The group has 100 points for every member, and you should distribute the total number of points between the members according to contributions. For example one person's point of view maybe, in their team of 4, 3 people on average each covered the same one person for 5% of effort and so they would report 105 points for 3 people, and 85 for the 4th. There will always be variations in time and effort, but this declaration of contribution assists me in identifying problem cases.

Submit the report to the CSSE office, and ensure that your name is clearly on it, you do not need a signed cover page.

Groups

You will each have your own group area on the db3240 server. You will each be given password protected space on the MySQL server. To establish the permissions etc for the project you need to form yourselves in to groups of NO MORE that 4 people. Then ONE member of this group will email me with the Subject: "CITS3240 Project Group" the following information

Full name 1 (student number) Username **
Full name 2 (student number) Username
  .... (for as many needed)

The ** is important because it will identify the ONE person who will take responsibility for submitting the group's project through csmarks. As the groups form I will add to the list below.

db3240a:*::ondrap01,diazs01,tsenv01,bowent02
db3240b:*::dunnep01
db3240c:*::weyy01,yangc04
db3240d:*::nachmo01,miyams01,kimt01
db3240e:*::varmad01,gopals02,tanm24,amoakr01
db3240f:*::taherb01,salams01,kauls03
db3240g:*::santoa01,limy19,chooy02,laiw02
db3240h:*::mrkicg01,hotchl01,mailoj01
db3240i:*::ngk06,thiom01,tangj04,singhk01
db3240j:*::percis01
db3240k:*::duncaz01,kingm02,butleb01
db3240l:*::kiongs01,chaug01,loyw02
db3240m:*::geoghs02,davieb04,atking02
db3240n:*::partib01,vonhol01,lyonb0,stewad01
db3240o:*::rakshs01,jansas01,bhudij01,yoshis01
db3240p:*::mudiec01,maguij01
db3240q:*::thukrr01,sundah01
db3240r:*::davieg05
db3240s:*::seey05,coffml01,maheds01,tany13
db3240t:*::jacobj01
db3240u*::huanga02,rowec01
db3240v*::chestj01
db3240w*::davids01
db3240x*::kuruvo01,khalaa01

Configuration

Each group will be distinguished by a letter - a, b, c etc. If you are group X then the following things have been set up

• A directory called /home/projects/db3240/db3240X on the Linux machine db3240.csse.uwa.edu.au.
• Two subdirectories called public_html (for your HTML and PHP code) and weblogs (where the access and error logs from the webserver will be saved).
• A database called db3240X on the MySQL server on db3240 - your password will be mailed to each group member.

You should log in to db3240.csse.uwa.edu.au with your own username, but any files that you create can be assigned "group ownership" according to your group, meaning that the other group members can read them. To do this the person who first creates any particular file (for example project.php) would type the following commands in a terminal window.

chgrp db3240X project.php

chmod g+w db3240X project.php