please solve this problem and take into consideration all the given statements in the question.

Assignment Tasks 1) Construct the Entity Relationship Diagram (ERD) for the above given scenario. Include all the entities, attributes of each entity including primary key, not null, relationship between the entities and cardinality constraints. State any assumptions necessary to support your design. (50 Marks) Cyber Academy conducts Certification Exams organized by the various certification councils. The Academy operates as below: MEC_AMO_TEM_035_04 Page 1 of 10 Fundamentals of Relational Database Management Systems (COMP 20002.1) - Spring - 22-CW1 (Assignment) - ALL-QP A scholar has to register to take up the examination of a module. A scholar is identified by unique id, name, specialisation and designation. A Scholar can register one or more certification courses and similarly a course can be registered by one more scholar. The academy identifies a Course by its code, name, provider and council name. When a scholar registers for a course, the number of attempts is tracked by the academy. Once the scholars are registered for their respective courses, the academy allocates one or more rooms for each course to conduct the seminars. A room is identified by its no, name, building name and capacity. A course can be scheduled in at least one room or more and a room may be scheduled for a particular course or may not be scheduled whenever a room is scheduled for a course. The Cyber Academy also allocates instructors to every room for conducting seminars. Each instructor is identified by his instructor ID, name and specialization. An instructor is allocated to exactly one room and a room will have atleast one or more instructors. Note: It is mandatory to include the student id with all the entity names and attribute names. Similarity issues arising out of this not being followed, will be dealt as per the MEC policy