(i) Create the basic ERD for the following description Each professor advises many students. A student gets advice from at least 1 professor. (4 marks) (ii) Suppose that you have the ERM shown below During some time interval, a DRIVER can drive many TRUCKs and any TRUCK can be driven by many DRIVERs How would you convert this model into an ERM that displays only 1:M relationships? (4 marks) (iii) The table below is an example of a database table called "Courses". Assume all information is stored within this table. (a) Identify at least one position in the table where a deletion anomaly could occur. (state row values and column headings to sufficiently identify an area). (3 marks) (b) Give an example of a deletion anomaly from the user's point-of-view (i.e. a user's bad experience). Use the following outline for your answer. State an example userquery before the anomaly occurs. (e.g. a user gets a list of ...). (3 marks) (c) Give an example deletion which could cause the anomaly. (3 marks) (d) State an example user-query, after the deletion, showing the effect of the anomaly. (e.g. a user gets the same list, but now ...)