Case Study: ABC International Training Center (ABCITC) is a training organization located in Sydney, Australia. It is establishing the most comprehensive learning resource for multiple training programs, such as Language Program, IT Program, Art Program and the like. Over the past two decades ABCITC has helped tens of thousands of trainees all around Sydney transform their lives through provided trainings which have a presence across 7 locations (in different suburbs). ABCITC continues to recruit overseas instructors with trained pedagogy and experience and offers a couple of academic programs. It features state-of-the-art learning environments and resources. ABCITC trusts in your database ability. They hire you as an individual to set up a database system that helps them to effectively store and manage data regarding their employees, programs, locations, rooms, technologies, courses, training schedules, and events, etc. After several interviews with the ABCITC, you have come up with the following notes of entities, attributes, and business rules, which are all very important to ABCITC: ABCITC is a multi-program training center (e.g., Language Program, IT Program, Art Program and other programs). Program can be identified by ProgramID and has other attributes called ProgramName, ProgramDescription, and Establishing Time. ABCITC is a multi-location training center. Location can be identified by LocationID and has other attributes called LocationName, Address and LastMaintainance Time. For each location, ABCITC has more than one room. Room can be identified by LocationID and RoomNumber. A room can be either a Lab, a Lecture Room, or an Office. If it is an office, it has an additional attribute called RoomTelephone (e.g., +610481000000). If it is a lab or a lecture room, it has attributes of Layout and Occupancy. Employee has identifier of EmployeeID and has attributes of EmployeeName, Salary, DOB, and CountryOfOrigin. An employee can be an instructor or an Administrative Staff. Instructor has an additional attribute called EducationLevel. Administrative staff has an attribute called AdminType, AdminLevel, Department and Type. Timeslot has identifier of TSID and has attributes of DayofWeek, StartTime, and EndTime. TrainingCourse has identifier of TrainingCourseID and other attributes of TrainingCourseName, Description, Training Level (e.g., Intro, Master and Professional Level), Hours and Price. A Training Course can have one or more sections for a given month. A Training Course can be provided repeatedly each month. Section has identifier of SectionID, and attributes of Month, and Section Type (e.g., 4-hour or 2-hour).ABCITC uses technological tools (e.g., Oracle, Pycharm, Visio) to facilitate course delivery. Technological Tools is identified by ToolTypelD and has attribute of Description. Events are recorded for each training section and have the identifier of EventlD and other attributes of EventName, PlannedBudget, RealBudget and EventDescription. With further briefing, the following business rules are identified. 0 ABCITC makes training schedules on a month basis. An instructor can be scheduled to lecture more than one section of a training course in a given month. while a section can only be scheduled to one and only one instructor in a given month. A lecture room can participate in many schedules, one schedule, or no schedules; however, given a time slot, a lecture room can be scheduled for no more than one section. One timeslot can participate in many schedules, one schedule, or no schedules; one section can participate in only one schedule. A training course has one and only one Coordinator; an administrative staff can be assigned as the coordinator for zero. one or many training courses. An instructor species herfhis preferred session and time slots. Instructors are trained to use one, none, or many types of technological tools. A room can be either a lecture room, a lab, or an office. A lab can be equipped with more than one type of technological tool. A location can hold training sessions from one program or more than one program; a program only uses one location to host training sessions. A iocation may have many rooms. A room can be used by more than one program. A program can use one or more rooms. ABCITC keeps a record of events. An administrative staff can be assigned to be in charge of zero, one or more than one event. An event only has one and only one employee in charge. A room can be scheduled in zero, one or many events, while an event can use more than one room