Suppose we are given a dataset and need to design a database…

Suppose we are given a dataset and need to design a database from it. In other words, we begin with a single relation schema containing all relevant attributes. Instead of developing an ER diagram, we decided to break this schema into multiple smaller, well-structured schemas based on functional dependencies. What is the process called when we break single schema into multiple smaller, well-structured schemas? 

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?