Exercise No. 35: LPIS
Transfer the following verbal description into an ERM
a) A student (immatr.-nr.) can register for several courses (course-#). The student can`t register for a course when he has a positive grade, this information is in the examination protocol (EP-#).
b) The examination protocol has a specific state (S-#), for example: to be signed.
c) The courses are taught by university staff. (staff-nr.). Each course can be held by one or more people.
d) All staff members belong to a specific institute (I-Nr.), which belongs to one department (D-Nr.).
e) A student studies a degree program (DP-#). It`s possible that a student is in more than one degree programs.
f) Each degree program consists of several curriculum points (CP-#). A curriculum point can belong to more than one degree program.
g) Each course belongs to a curriculum point, the relationship is named ECTS.
h) Each course is located in an auditorium/pc-lab (room-nr.). A course can take place in more than one room.
i) The rooms are coordinated by the staff. Each staff member can give his preference. The examination protocols are signed by the staff. Each protocol must be signed by more than one staff member.