Question

Which of the following is not a process of generating a good relational schema?

(a) Converting ER diagrams to relational schema

(b) Decomposing the relational schema while satisfying functional dependencies

(c) Joining multiple relations together to form a single relation containing all the attributes

(d) A design of relations which is then tested and modified to satisfy given normal forms

This question was addressed to me in class test.

My doubt stems from Normal Forms in section Relational Database Design of RDBMS

Answer 1

Correct option is (c) Joining multiple relations together to form a single relation containing all the attributes

Explanation: Joining multiple relations together to form a single relation containing all the attributes is not a method for the development of good relational schema because it might violate the normal forms if it is combined.