Exercise - the Rostlab!

 Prof. Dr. B. Rost Dr. L. Richter J. Reeb Bioinformatics Resources Exercise Sheet 5 due on June 19 th, 9 a.m. Total number of points: 13P Task 1 Implement the following ER in SQL: Funktionalitäten
MatrNr
Name
Semester
voraussetzen
Nachfolger
Vorgänger
N
Studenten
N
N
hören
M
Fachgebiet
1
Assistenten
N
arbeitenFür
N
SWS
Titel
lesen
prüfen
PersNr
Name
Vorlesungen
M
Note
M
VorlNr
1
1
Professoren
PersNr
Name
Rang
Raum
20
There are more than one way to solve these. Implementation here means to write the respective create statements. (9P) Task 2 Use: hyper-­‐db.com/interface.html Write and execute the following queries: ∏Name, Titel (σ PersNr = gelesenVon ∧ Titel =' Mäeutik' (Professoren×Vorlesungen)) 1P Which students attend (hören) which lectures? 1P Which professor has how much lecture hours per each professor? 2P Good luck, J. Reeb & L. Richter