A exists when there are functional dependencies such that Y

A exists when there are functional dependencies such that Y is functionally dependent on X and Z is functionally dependent on Y. and X is the primary key. partial dependency repeating group atomic attribute transitive dependency A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key. is said to be in. 1NF 2NF 3NF 4NF If you have three different transitive dependencies, different determinant(s) exist. one two three four The most likely data type for a surrogate key is. Character Date Logical Numeric From a strictly database point of view, attribute values can be calculated when they are needed to write reports or invoices. derived atomic granular historical For most business transactional databases, we should normalize relations into 1NF 2NF 3NF 6NF BCNF can be violated only if the table contains more than one key. primary candidate foreign secondary Most designers consider the BCNF as a special case of the 1NF 2NF 3NF 4NF

Solution

3.d.transitive dependency

4.2NF
5.c.three
6.Date
7.atomic

8.c.3NF

9.b.candidate key

10. c.3NF