Skip to content

Instantly share code, notes, and snippets.

@ypacheco
ypacheco / db_exam
Last active August 24, 2023 12:01
db_exam2023
group: Exam
Student = {
name, sid
'Peter Verbeeke',1
'Jan Degreef',2
'Natacha Nisez',3
'Tine Vercauteren',4
@ypacheco
ypacheco / db_exam2
Last active August 18, 2022 17:07
exam
group: ExamII
Tank = {
tname, capacity, numberSpecies
'Tank1', 300, 40
'Tank2', 500, 90
'Tank3', 800, 80
'Tank4', 900, 50
'Tank5', 1200, 30
'Tank6', 2200, 140
'Tank7', 700, 90
@ypacheco
ypacheco / db_exam
Last active August 18, 2022 16:48
exam
group: Exam
Branch = {
bcity, bcountry
'Moscu','Rusia'
'Berlin','Alemania'
'Paris','Francia'
'Roma','Italia'
'Bruselas','Belgica'
'Lyon','Francia'
'Hamburgo','Alemania'
@ypacheco
ypacheco / WPO4slides
Created March 13, 2022 20:46
WPO4slides
group: slides
Logins = {
loguinID, name, dateTime, device, duration
1, 'Maxim Van de Wynckel','2020-03-01 12:12', 'Android',5
2, 'Yunior Pacheco Correa','2020-03-01 13:58','iOS',10
3, 'Maxim Van de Wynckel', '2020-03-02 10:01','Windows',8
4, 'Maxim Van de Wynckel', '2020-03-02 10:12','macOS',3
5, 'Bas Ketsman', '2020-03-03 06:04','Windows',20
6, 'Yunior Pacheco Correa', '2020-03-04 10:58','macOS',9
}
@ypacheco
ypacheco / WPO3exercices
Last active March 10, 2023 16:14
WPO3exercices
group: WPO3exercices
-- Ex 1 and 2
R = {
name, degree
'Anne', 'MSc Computer Science'
'Anne', 'Highschool'
'Anne', 'MSc Mathematics'
'Katja', 'MSc Computer Science'
'Katja', 'MSc Mathematics'
'Katja', 'Highschool'
@ypacheco
ypacheco / WPO3slides
Last active March 6, 2022 00:20
db_slides
group: WPO3slides
Employee = {
employeeNr, firstName, lastName, empType
1, 'Maxim','Van de Wynckel', 'BAAP'
2, 'Yunior', 'Pacheco Correa','BAAP'
3, 'Beat', 'Signer','ZAP'
4, 'Bas', 'Ketsman','ZAP'
}
Students = {
studentNr, firstName, lastName
@ypacheco
ypacheco / WPO4exercises
Last active March 13, 2022 20:45
WPO4exercises
-- this is an example
group: Exercise4
Employee = {
person_name, street,city
'Daisy', 'Dictum Av','Chicago'
'Angela', 'Arcu St', 'Philadelphia'
'Lucy', 'Viverra Avenue', 'Detroit'
'Valentina', 'Tortor Street', 'Dallas'
'Rose', 'Proin Road', 'Denver'
'Alexis', 'Tortor Street', 'Dallas'