داتا بيز: اسئلة على سلايدز المحاضرة 7, 8, 9, 10 متجاوبة
This means a table should not contain repeating columns
Anonymous Quiz
42%
Atomic Values
58%
No Repeating Groups
Every column of a table should contain only atomic values
Anonymous Quiz
12%
No Repeating Groups
88%
Atomic Values
is based on the concept of full functional dependency.
Anonymous Quiz
22%
(1NF)
61%
(2NF)
11%
(3NF)
2%
(4NF)
4%
(BCNF)
A relation with a single-attribute primary key is automatically in at least …
Anonymous Quiz
11%
0NF
37%
1NF
46%
2NF
6%
3NF
Second Normal Form (2NF) is based on the concept of … functional dependency
Anonymous Quiz
26%
Partial
74%
Full
If the proper subset of candidate key determines non-prime attribute, it is called … dependency
Anonymous Quiz
89%
Partial
11%
Full
A relation that is in First Normal Form and every non-primary-key attribute is fully functionally dependent on the primary key, then the relation is in
Anonymous Quiz
16%
(1NF)
84%
(2NF)
Non-prime attribute COURSE_FEE is dependent on a proper subset of the candidate key, which is a partial dependency and so this relation is in 2NF
Anonymous Quiz
61%
F
39%
T