AB Tuition Centre is located in Pahang, offering tuition classes for secondary school students. Excerpts from the

Fantastic news! We've Found the answer you've been seeking!

Question:

AB Tuition Centre is located in Pahang, offering tuition classes for secondary school students. Excerpts from the class timetable is shown below:

The tuition centre has hired a consultant to develop a database system for the company. The consultant has identified three relational tables that should be developed to store the class data, namely teaching staff table, subject table, and class-time table. Unfortunately, the consultant has fallen sick and unable to complete the task.

Required:

(a) Construct a set of relational tables, as recommended by the consultant. For each table create or identify the appropriate primary keys for each table.

(b) Recommend two additional attributes related to the subjects offered that you think should be recorded by the tuition centre.