Eduvos Database System

Eduvos is a Higher Education Institute which has significantly grown over the years. The Institute has recruited you to implement an efficient database consisting of students, lecturers, subjects, exam, and department for its day$-$to$-$day administrative purpose. The complete Entity Relationship Diagram $($ERD$)$ for the proposed database model comprising of all entities involved and their respective attributes are presented in the Figure $1$ as shown below.

Figure $1$: Entity Relationship Diagram $($ERD$)$

The implementation of the above database design will facilitate efficient management of students, subject allocation, exams schedule, and departmental operations, supporting academic excellence and administrative processes within the institution.

Source: Obaro Adewale $(2023)$

List the primary and foreign keys associated with each table in the above scenario.

For example: EntityA $-$ attribute$1($PK$)$ and attribute$2($FK$)$