UTA INSY 3304 EXAM QUESTIONS AND ANSWERS LATEST UPDATE (ALREADY GRADED A+)

UTA INSY 3304 EXAM QUESTIONS AND ANSWERS
LATEST UPDATE (ALREADY GRADED A+)
Normalizations (3)

-evaluating and correcting table structures to minimize data redundancies
-1nf
-2nf
-3nf

1NF (First Normal Form)

Table Format. No repeating groups and a primary key identified.

2NF (Second Normal Form)

1NF and no partial dependencies

3NF (Third Normal Form)

2NF and no transitive dependencies

Dependencies (4)

-Functional Dependency
-Full Functional Dependency
-Partial Dependency
-Transitive Dependency

Functional Dependency

The attribute B is fully functionally dependent on the attribute A if each value of A determines one and
only one value of B.

Full Functional Dependency

If attribute B is functionally dependent on a composite key A but not on any subset of that composite
key, the attribute B is fully functionally dependent on A.

Partial Dependency

functional dependence in which the determinant is only part of the primary key

Transitive Dependency

attribute is dependent on another attribute that is not part of the primary key

DDL (Data Definition Language)