Question No. 45: ERD Construction Question. 18 marks) Consider a database that consists of three entities and two relationships joining them. The entities are lecturer and lecture have the relationship teaches and the course and lecture have the relationship is about Your job is Construct the ERD for this database showing all relations with cardinalities. Identify the primary, foreign keys and at least two attributes for each entity