(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).

(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 ).

(c) Give an example deletion which could cause the anomaly.

(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 ...).

(e) Suppose that the above table uses {StudentNo,CourseName} as the primary-key. Explain, from a user's point-of-view, what an insertion anomaly is. Use the following outline for your answer: Give an example of an insertion which the RDBMS will not allow

(iii) The table below is an example of a database table called Courses. Assume all information is stored within this table. StudentNo 02356 02356 02111 02356 StudentName CourseName Scott Fowler Poetry Scott Fower Prose Rob Lowe Poetry Scott Fowler History Teacher Martyn Porfirio Martyn Ricksen Teachers Office 12B 12B 12B 25C