solve this q1 both parts data dictionary and ERD

Question 1 The teaching & learning centre at Global Institution is managing trainings for all the employees: academicians and admin staff. There are three faculties: Computing Faculty Business Faculty and Engineering Faculty and five departments: Bursary Department, Student Affairs Department and Registrar Department available at the Institution. Each employee must attend at least five trainings a year. Trainings can be from internal parties or external parties. Each training duration can be half day or full day depending on the topics and training parties. The Institution will email to the employees the available trainings every three months. The employees may register if they wish to attend the trainings relevant to their field and interest. The employee must login to the Employee Training System to register for a training session they wish to participate. The system will display the title of the trainings. the date, day, start time and end time and duration in days (half day, full day). The employee will click the submit button available on each displayed training titles and the system will update the database. From the business requirements described above, you as a DBA are responsible to study the data requirements and do the following: - Create a Data Dictionary (table schema) to show all the entities identified (12 marks) b) Draw the Entity Relationship Diagram (ERD) from the answers obtained in Qla) with the relevant attributes and constraints added, relationship names and multiplicities. (13 marks) at is the purpose of con currency control Dinatran saction processing system? IN KEKAL SELAMAT-... 2:10 PM 77%