FSST 4

Course Overview

Agile Software Development

Introduction to Linux

Introduction to Databases

1st week
Database Management Systems
Download and install the available sqlite databases and tools as described in this README. These databases are designed to match the examples in the SQL tutorial.
2nd week
Complete the SQL Tutorial up to and including aliases. Instead of relying on the website, execute the examples in your local database (use the "Execute SQL" tab of DB Brower for SQLite).
Accept the first database assignment on SQL SELECT.

SQL Exercises

Sample Code

For interacting with a database, there are many possible APIs. All large C++ libraries offer interaction with SQLite, but there are also many small, independend libraries focused on SQLite interaction. For example

The following are minimal examples for interacting with SQLite from other programming languages

Prior Exams

Notes

Grading

>87.5: 1, >75: 2, >62.5 : 3, >50: 4, ≤50: 5

Please note that the above schema MAY be subject to a grading curve for individual tests or assignments.

40% written test (computer (offline)) - must be passed
40% programming assignments
20% participation and performance during coding dojos (≥2)
participation contributions are rewarded with a "+"
for students with a positive grade, each "+" improves the average term grade by 0.1 (10 + improve one full grade)

To avoid plagiarism and prevent cheating, all grades (including tests, projects and assignments) require a short oral defense to be valid.

Late assignment policy: the points for each assignment filed after its due date are multiplied by 0.8 for each started week after the due date.
For example: a student files an assigment one day late and would receive 97 points if filed before the due date. The student gets 97 * 0.8 = 77.6 points instead. Another student files an assignment with 100 points 16 days after the due date. 16 days means the third week after the due date has started. Hence the student is awarded 100 * 0.8 * 0.8 * 0.8 = 51.2 points.

Content of the Curriculum (4th Grade)

Curriculum in the Legal Information System (see Attachment 1.5)

Module 7+8