Delivering the assignment

1. Choosig and defining the subject and getting it accepted at latest April 12th 2002
   • An example subject
   • An example assignment
2. Creating the database by SQL
3. Delivering the assignment at latest May 3the 2002
• Blank document (HTML-source)
• Creating the figure of relations

Documentation

Write a simpe web page about your assignment. Include all the material you've made in the previous steps. At least the following must be included:

• The name of the assignment
• Your name, e-mail and major subject
• The description of the assignment
• Requirement definitions
• ER-diagram
• Figure of relations showing the relations transformed from the ER-diagram, their fields, keys and referential integrities ("Relationships" figure in Access or similar). dbVisualizer tool can be used for creating the figure.
• A table showing the attributes of the relation, their datatypes, if they are required, default values, restrictions and secondary indexes
• Explanation of the possible changes in the structure of the original ER-diagram after normalization.
• The SQL statements used for creating the database
• The SQL statements needed for inserting the test data
• The SQL queries required
• The time used for doing the assignment
• Comments on doing the assignment
• Link to the home page of the course (<http://appro.mit.jyu.fi/tietokannat/>).

There is a blank WWW page for the documentation (source).

If needed, study creating a WWW page and locating it on a server by using the exercises of the Utilizing Information Networks -course.

Make sure your pages accord the W3C recommendations and validate without errors in the most common validators.

Delivering the assignment

To pass the assignment you have to meet the supervisor personally in an appointment at latest May 3th 2002.

Delivering the assignment is comparable with an exam as passing the assignment means passing the course. Therefore, at the time of the appointment, be there!. If you cannot arrive in time, inform the supervisor well before.

After May 3th 2002 the assignments can be delivered only on certain days announced later (like examination days).

To the appointment you have to bring:

• Your personal ID
• The accepted plan

The supervisor will:

• Check your ID.
• Read and check the documentation on WWW.
• Ask some questions to make sure you understand the solutions you have used in your assignment.
• Use the SQL in the documentation to create the database.
• Use the SQL in the documentation to put in test data.
• Test the queries in the document.
• Give instructions for further work and make a new appointment in case there is something to correct in the assignment.
• Archieve th document and the plan.

In case of minor problems ask the supervisor for help by e-mail. The instructors of the exercise groups can always help. You can also use the mailing list of the course or the IRC channel. In case of major difficulties, make an appointment with the supervisor.

The supervision and delivery of the assignments is divided as follows

• University Studens in alphabetical order (by last name) A - K : Pauli Kujala (pjkujala@mit.jyu.fi, AgC434.1)
• University Students L - P and all Open University Students : Tommi Lahtonen (tommi.j.lahtonen@jyu.fi, AgC431.2)
• University students R - Ö : Annemari Auvinen (annauvi@cc.jyu.fi, Avotila Ag C433.1)

Use the Kuukkeli system for making the appointments for supervision od delivering the assignment