Student
| Student_No | Name | Total_Units | Coord_No |
|---|---|---|---|
| 12345678 | Donald Duck | 230 | 23 |
| 98765432 | Mickey Mouse | 120 | 45 |
| 56321478 | Mother Goose | 40 | 23 |
Total_Units is an unlikely attribute in a fully-fledged database.
A database that recorded information about grades could work this out.
Coordinator
| Coord_No | Name | Employee_No |
|---|---|---|
| 23 | Fred Flinstone | AS1234 |
| 45 | Pluto | AS5678 |
Course
| Course_No | Name | Units |
|---|---|---|
| HIT232 | Relational Database Systems | 10 |
| HIT999 | Project | 20 |
Grade
| Student_No | Course_No | Grade |
|---|---|---|
| 12345678 | HIT232 | HD |
| 12345678 | HIT999 | P |
| 98765432 | HIT232 | HD |
| 56321478 | HIT232 | D |
| 56321478 | HIT999 | C |