1. Introduction

The development environment is

  • Linux (ubuntu)
  • emacs(1) (with home-grown extensions)
  • snippets(1) tool (templating)
  • terminal/shell/make
  • python 2.x/3.x

Although it is possible to use editors other than emacs for the current task, the missing highlighting support and tag navigation make comprehension and work quite hard.

The task can be completed in a terminal with ssh(1) access to sw-amt.ws. It is perfectly possible to use PuTTY under windows.

A more comfortable graphical environment is available with a VNC viewer (e.g. UltraVNC) via SSH-Tunnel.

2. Task

  1. Create a project directory workpackage in your home directory.

  2. Initialize documentation according to Documentation Standard:

    sda init 'Workpackage'
    
  3. Create a python file with the snippets tool:

    snn workpackage.py
    
  4. Create a sqlite3 database from an SQL file workpackage.sql, with tables person (see table 2.1) and car (see table 2.2):

    Note

    Do not declare the foreign key relation for driver_id explicitely.

    table 2.1 person
    column type attributes
    _id INTEGER AUTOINCREMENT, PRIMARY KEY
    name TEXT  
    first_name TEXT  
    table 2.2 car
    column type attributes
    _id INTEGER AUTOINCREMENT, PRIMARY KEY
    manufacturer TEXT  
    model TEXT  
    driver_id INTEGER