IT 214

normalization

Database ______________ is the process of modifying the structure of a database based on a sequence of normal forms, from first normal form to higher level normal forms

Right

In a relational database, a transitive dependency (X determines Z) exist if and only if there is an attribute or set of attributes Y (Y does not determine X) such that X determines Y and Y determines Z

completeness

The _________ constrains specifies whether each super type entity occurrence must also be a member of at least one subtype

normalization

Database ___________ process reduces data redundancy

Right

A functional dependency is a relation between attributes

UNF

A table in _________ form has either repeating groups, composite data cells, multi-value data cells or lacks a valid primary key

Right

A table is 1NF if it has proper primary key, all data cells have single elementary line value and and does not have repeating groups.