The development environment is
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.
Create a project directory workpackage
in your home directory.
Initialize documentation according to Documentation Standard:
sda init 'Workpackage'
Create a python file with the snippets tool:
snn workpackage.py
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.
column | type | attributes |
---|---|---|
_id | INTEGER | AUTOINCREMENT, PRIMARY KEY |
name | TEXT | |
first_name | TEXT |
column | type | attributes |
---|---|---|
_id | INTEGER | AUTOINCREMENT, PRIMARY KEY |
manufacturer | TEXT | |
model | TEXT | |
driver_id | INTEGER |