C170 WGU ALREADY PASSED

An entity is said to be X -dependent if it can exist in the database only when it is associated with another related entity occurrence. - existence 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 X. - 1nf A determinant is any attribute whose value determines other values within a column. - F X is a process that is used for changing attributes to entities. - Normalization Any attribute whose value determines other values within a row is known as a X. - determinant Data redundancy produces data anomalies - T Normalization is a very important database design ingredient and the highest level is always the most desirable. - T A table that is in 2NF and contains no transitive dependencies is said to be in X. - 3NF An attribute that cannot be further subdivided is said to be X. - atomic In the X no row may contain two or more multivalued facts about an entity. - 4NF (fourth normal form) When a table contains only one candidate key X are considered to be equivalent. - 3nf and bcnf