Using https://erdplus.com, let's redesign it into two or more tables in the third normal form. You are asked to: a) (8 marks) Present your entity-relationship diagram (ERD). b) (3 marks) Present the generated relational schema. The primary key and possible foreign keys of each table should be shown. c) (3 marks) Present the generated SQL statements to create the tables with the appropriate data type set for each attribute.