---
# System prepended metadata

title: Untitled

---


**Customer**
PK= unterstrichen, FK=rekursiv
| $\underline{Customer ID}$ | Name | Adresse | ZIP_Code | Discount |
| ----------- | ---- | ------- | -------- | -------- |
|             |      |         |          |          |

**Order**

| $\underline{Order Nr}$ | Order_Date | Due_Date | *Customer_ID*   |
| ---------------------- | ---------- | -------- | --- |
|                  |       |     |     |




PK= unterstrichen, FK=rekursiv
**Student**

|$\underline{StudentID}$  |    Name      |    *MID* |     
| --- | -------- | --- |  
| 1   | Egon     | M01 |     |
| 2   | Wolfgang | M02 |     |
| 3   | Helmut   | M02 |     |
| 4    |  Heinz   |M01
| 5          | Felix | M03  |     

**Major**

| $\underline{MID}$ | Name             | *FID*    |
| ----------------- | ---------------- | --- |
| M01               | Computer Science |   F01  |
| M02               | Biology          |   F01  |
| M03               | Mathematics      |   F01  |

**Faculty**

| $\underline{FID}$ | Faculty |
| -------- | -------- |
| F01     | Faculty of Mathematics and Natural Sciences     |



| $\underline{StudentID}$ | $\underline{Courses}$|
| -------- | -------- |
| 1         |  Data Science        |
| 1         |   Information Retrieval       |
| 2         |    Information Retrieval      |
| 2         |      Linear Algebra    |
| 3     |    Introduction to Social Psychology  |
