Could you answer the question "d"? Convert your ERD to a set of relation. MySQL. Thanks a lot!

SECTION A - TWO QUESTIONS TO BE ATTEMPTED QUESTION1 Amswer all parts The following narrative describes an IT training office's course schedules: The IT training office would like to record all data on the IT courses they deliver and the teachers who deliver the courses. Each teacher could give many courses and each course could be delivered by many teachers. Data stored on teachers are employee number, name, address, area of speciality and date hired. For each course, they store a course Id, course title and the award level. This level can be 4. 5. 6. 7 or 8. No teacher would deliver the same course twice. Each course can be given three to four times a year. Thus each time a course is delivered, a new course schedule is created. Each course schedule has a date, time and duration. The duration is recorded as the number of months the course will be delivered for. This can range from six to 24 months. The location ID where the course would be delivered is also stored. Each course schedule is delivered by only one teacher. Each course would have only one location associated with it regardless of who is teaching it or when it is taught. Other data stored on location are the location name, address and room size of room. This room size is described as small, medium or large. List the entities present in the above specification. (Son Tables) Course, teacher, schedule, location (2.5 marks) (b) List the relationships that exist between these entities? schedule office records dala on Courses Course has a courses delivery by Teachers Course has a location. (2.5 marks) (c) Draw an Entity Relationship (ER) diagram to represent the above scenario. (10 marks) 11 (d) llo Convert your ERD to a set of relations. (10 marks) office ID Title Total (25 marks) 11 (10 marks) Title Convert your ERD to a set of relations, IS Level Total (25 marks) Course cmc Teacher! hi room Size has Specialty date duration Schedule name Time Location acaress office (officeid, name, location ) Couse (Courseid, tetle) Teacher (Teacherid, address, Area, data) Location (beationid, name, address,room) shedule I scheduleid, duration, date, time)