Database design

You are approached by an on-line training business to develop a database design for their instructor-led training in English or Chinese. They deal with more than fifty technical subjects which are for either students or professionals. A subject may be offered under one or more categories. The business contracts with various instructors who are assigned one or more specific time-slots to teach the courses. The same course can be offered by more than one instructor at the same time. Each course lasts for four to six weeks. The students and professionals can register for the course on-line and once they are registered for one course, they can attend the classes by any instructor who teaches the same course on-line at the same time.                                                          

Sample Solution