C170 WGU, Data assessment. Questions and answers. VERIFIED.

C170 WGU, Data assessment. Questions and answers. VERIFIED. 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 All relational tables satisfy the X requirements. - -1NF (first normal form) BCNF can be violated only if the table contains more than one X key. - -candidate All relational tables satisfy the 1NF requirements. - -T When designing a database you should X. - -make sure that the table entities are normalized before table structures are created Using the X command SQL indexes can be created on the basis of any selected attribute. - -CREATE INDEX A table can be deleted from the database by using the X statement. - -DROP TABLE