Homework DB

homework-db.txt

group: homework example
description[[
Example student database as a running example in our lecture.
]]

exercises = {
cat:string, eno:number, topic:string, maxpt:number
'H', 1, 'Relational Algebra', 10
'H', 2, 'SQL', 10
'M', 1, 'SQL', 14
'H', 3, 'Tuple Relational Calculus', 20
'H', 4, 'Functional Dependencies', 16
'H', 5, 'Normal Forms', 14
'H', 6, 'SQL - Advanced Concepts', 20
'H', 7, 'OLAP', 10
'H', 8, 'Exam Preparation', 20
}

results = {
sid:number, cat:string, eno:number, points:number
101, 'H', 1, 10
101, 'H', 2, 8
101, 'M', 1, 12
102, 'H', 1, 9
102, 'H', 2, 9
102, 'M', 1, 10
103, 'H', 1, 5
103, 'M', 1, 7
}

students = {
sid:number, first:string, last:string, email:string
101, 'Ann', 'Smith', '...'
103, 'Richard', 'Turner', '...'
104, 'Maria', 'Brown', '...'
102, 'Michael', 'Jones', NULL
105, 'John', 'Doe', 'john.doe@uni-konstanz.de'
}