Question $5$

EduVarsity, a university which prides itself in its efforts to provide their students with the academic support, has just

hired you to develop the information system they will be using to keep track of the students that have signed up for extra

classes at the university.

They have brought you in to specifically help them design the database their information system will be using. As part

of your design job, the EduVarsity managers asked you to provide an Entity Relationship Diagram to show the structure

of the database.

They would like the database to keep track of the students who have used the system to register for extra classes.

Details such as their student number, first name, last name, and date of birth are to be stored for every student that

registers.

The university has lecturers involved in their academic support programme. The designed database should be able to

store details on the lecturers such as first name, last name and highest qualification.

Each lecturer can provide many extra class sessions, although according to university policy, each of the extra class

sessions should only be conducted by a single lecturer. For each extra class session, the database should store the

subject of the class $($e$.$g$.$ Geography, Maths, Informatics, etc.$),$ the level of the module $($e$.$g$.1$A$,2$B$,3$A$,$ etc.$),$ and the

date in which the extra class sessions started.

The students at EduVarsity may register to attend extra class sessions at any time during the semester. The managers

at the university would like to know the date at which each student registers to attend extra class sessions. An extra

class session can be registered for by multiple students, and each of the students may register to attend the different

extra class sessions they want.

Given the information above, draw an ER Diagram showing the following:

Entities,

Attributes,

All key attributes,

Data types for each attribute, and

All relationships between the entities

NB: You may use one of the standardised ERD notations.