Exercise - the Rostlab!
Werbung
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
