Dataset Structure & Job Classification Quiz

Normalization is the process of evaluating and correcting table structures to minimize data ______.

First normal form (1NF) assigns attributes to tables based on ______.

Denormalization produces a ______ normal form.

Higher normal forms are ______ than lower normal forms.

Normalization is used while designing a new ______ structure

Normalization improves the existing data ______ and creates an appropriate database design

The objective of the normalization process is to ensure that each table conforms to the concept of well-formed ______

The normalization process progressively breaks the relation up into a new set of ______

StudentAdvisor is fully functionally dependent on ______

A partial dependency occurs when an attribute depends on only part of the ______

The Grade depends on both StudentID and ______

The ProductName only depends on the ______

Knowing the PROJ_NUM and EMP_NUM values will let you find the job classification and its ______.

HOURS attribute represents the number of hours an employee worked on a specific project and CHG_HOUR is the amount ______ per hour.

Normalization should be part of the ______ process.

Normalized tables help minimize data ______.

Entity names: Should be nouns that are familiar to ______

Should document abbreviations, synonyms, and ______ for each entity

Should be unique ______ the model

Attribute names: Should be unique ______ the entity

Should use suffixes such as _ID, _NUM, or _CODE for the ______ attribute

Entities: Each entity should represent a single ______

Functional dependence (generalized definition) Attribute A determines attribute B (that is, B is functionally dependent on A) if you look at all the rows in a table and see that they have the same value for attribute A, they will also have the same value for attribute ______.

Fully functional dependence (composite key) 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 ______.

This dataset is not in 1NF because the ______ column contains multiple authors separated by commas.

Conversion to First Normal Form (1NF) (1 of 3) Repeating group: group of multiple entries of same type can exist for any single ______ attribute occurrence.

1NF describes tabular format in which: All key attributes are defined There are no multi-valued ______ in the table All attributes are dependent on the primary key All relational tables satisfy 1NF requirements

Conversion to 2NF occurs only when the 1NF has a composite primary key If the 1NF has a single-attribute primary key, then the table is automatically in ______

"BookID" is the primary key. However, "Author" depends on both "BookID" and "Title." To achieve 2NF, we create two tables: "Books" and ______.

The data anomalies created by the database organization shown in Figure 6.4 are easily eliminated Make new tables to eliminate ______ dependencies Reassign corresponding dependent attributes Table is in 3NF when it: Is in 2NF Contains no transitive dependencies