e) Consider figure 2 to answer this question. 1) Write the field name with the longest character length. [01 mark] ii) Write field names which are used as primary keys with their data types and table name. [06 marks) iii) Draw an Entity-Relationship (ER) diagram to illustrate the relationships between given 3 entities. [09 marks) course Column c code (Primary) c title ccredit c level Type Null Default Links to varchar(7) No varchar(40) Yes NULL int(1) Yes NULL int(1) Yes NULL marks Column Type st_reg no (Primary) int(4) c_code (Primary) varchar(7) reg year (Primary) date marks int(3) Null Default Links to No student->st reg no No course->c_code No Yes NULL student Column st_reg_no (Primary) st name st dob st_gender st address st tele Type Null Default Links to int(4) No varchar(45) Yes NULL date Yes NULL char(1) Yes NULL varchar(60) Yes NULL int(10) Yes NULL figure 2