Choosig and defining the subject and getting it accepted

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

You can freely choose the subject for the assignment. For example, transforming the assignments of the courses C++ Programming (Ohjelmointi++) or Microcomputer Applications (Mikrotietokoneiden ohjelmistot) to relational databases are recomended. It is also possible to use the example subject.

The subject cannot be any of the examples discussed on the lectures or exercises (Company (Yritys), Recording (Äänite), Student (Opiskelija), Company (Yritys), Soccer (Futis))

1. Description

   Write a short description of the subject you have chosen. Explain what kind of an organization or user the database is designed for and which activities does it facilitate. Describe briefly what the application should do.

2. Defining requirements

   Describe verbally the most important operations associated with the database. Remember to mention who are the users or user groups that make the operations and how do they do that. Also consider what kind of a reports or summaries the users want to make of the data.

   Some examples of possible operations on a database containing study attainments:

   • Constructing student-spesific, exam-spesific or study attainment-spesific reports.
   • The lecturer checks an exam or an exercise of a student and marks the course as passed.
   • The lecturer creates a new course.

3. ER-modelling

   On the base of the requirements described above draw an ER-diagram that describes the structure and contents of the database.

   The diagram should show the entity types, relation types, attributes, keys and cardinalities.

   The ER-diagram should have at least seven entities.

4. Getting the subject accepted

   Write and print a document that includes the following:

   • The name of the assignment
   • Your name
   • Your e-mail address
   • Your date of birth
   • Your major subject
   • Description of the assignment
   • Requirement definitions
   • the ER-diagram

   Hand-written or -drawn plans will not be accepted. Show your plan to a supervisor to get it accepted. You can show your plan to the instructor of your own exercise group. In case you do not attend exercises make an appointment! Use the kuukkeli system for making an appointment. The supervisor will sign an accepted plan.

   The accepted and signed plan must be handed to the supervisor when delivering the actual assignment.

   The plan for the assignment must be accepted at latest April 12th 2002.