We reduced entity sets and relationship set to a set of rela…

We reduced entity sets and relationship set to a set of relation schemas as illustrated in Figure 1. (a) ER diagram                                                                                                       (b) Relational diagram                 Figure 1. ER diagram (a) and associated relational diagram.   How can we further optimize relational database design?