undefined

Q1(a) ii. At Malaysia Science University, a lecturer may be assigned as the academic advisor of several students. Every year, the academic advisor assignment may change. The entity relationship diagram (ERD) to store this information is as shown below. LECTURER STUDENT PK LEC_ID PK STUD_ID LEC_NAME STUD_FNAME LEC_LNAME advises-od STUD_LNAME LEC_OFFICE STUD_YEAR LEC_PHONE FK LEC_ID Modify the given ERD to track changes to the academic advisor assignment over the years. (4 marks) Additional Instructions: You are allowed to draw the ERD by hand on a piece of paper or create the ERD using diagrams.net You need to write/include your index number beside the diagram before uploading the image file on eLearn Image file format should preferably be in JPEG or PNG Upload the ERD image in the Files box (Max. size is 4 GB)