Consider the relation R(A, B, C, D, E, F, G) with the following types of attributes:-
Total No of Keys = 1 = {A}
Set of Simple (or) Atomic (or) Single Valued Attributes = {B, C}
Set of Multivalued Attributes = {D, E}
Set of Composite Attributes = { F, G}
What would be the minimum no of tables that exists after decomposing relation R into 1NF?
(A) 3 (B) 2 (C) 4 (D) 5
My attempt:
We needed different table for each multivalued attributes with given key(A), total = 2
Similarly, we needed different table for each composite attributes, total = 2.
There are total 4 such attribute. I give 4 tables with given key(A) in each(4) tables. I'm allowed to insert atomic attributes(B,C) to any one of given 4 tables. So, I concluded that 4 tables are sufficient to represents relation in first normal form.
Can you explain in formal way, please?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…