Revise the ERD below based on the following criteria:

- Advisor ID will be a FK in Student. Not the other way round. The FK will always live on the many side of a relation.

- lease/invoice relation is not shown

- the M:N between staff and inspection needs to be broken into two 1:m relations

- instructor ID is shown in courses, yet I see no instructor entity

INVOICE Invoice Number Payment Date Payment Mode First Remainder Date Second Remainder Date Student ID (FK) Lease Number (FK) LEASE Duration Enter Date Leave Date Student ID (FK) Place Number (FK) STUDENT Student ID First Name Last Name Mobile Phone Street City Zip Code Ema Date of Birth Status Maio Minor Category HALL OF RESIDENCE Name Address Manager Room Number Place Number Rent Rate Student Assigned (FK) COURSES Course Title Instructor Telephone Room Number Department Number Course Instructor (FK) ADVISOR Name Position Department Telephone Number Room Number Ema Student ID (FK) NEXT-OF-KIN Name Relationship Address Telephone Number Student ID (FK) INSPECTION Date of Inspection Condition Comments Place Number Room Number Staff Number (FK) STAFF Name Address Gende Position Location Office