Question 2 [30 marks] 2. The company has extended the amount of information they store. Evidence is stored in different electronic stores depending on what type of evidence it is - e.g. video evidence is always kept in the Video Store. Incident Key: In 123 Incident Description: Low-speed collision between bus and car. Car passengers claim to suffer ongoing nain as a result. Car has some damace. Neither driver admits responsibilitv. Table 1 Progress report on claims arising from incident with key In123 (a) Represent the information supplied in Table lin unnormalized form. (5 marks) (b) Represent the information in first normal form. (5 marks) (c) Represent the information in second normal form. (5 marks) (d) Represent the information in third normal form. (5 marks) (e) Draw a fully normalized ERD to represent the entities derived by the normalization process, showing primary and foreign keys, attributes and relationships. (10 marks)