Skill Building Exercise #$8$

$$

Part A$.$ Identify and Explain Which Normal Form, using Functional Dependency Principles

$$

$$

$1.$ CUSTOMER relation:

Customer No$.$

Customer Name

Sales Region

Region Sales

$1073043$

Jones

West

$670,000$

$1076443$

Smith

South

$735,000$

$1034875$

Allen

East

$723,400$

$1098744$

Carpenter

West

$670,000$

$$

Using functional dependency principles, assess the normal form of CUSTOMER.

$($circle one:$)$

None$1$NF$2$NF$3$NF

Explanation:

$$

$$

$$

$2.$ Using functional dependency principles, assess the normal form of STUDENT.

STUDENT relation:

STUDENT $($Student ID$,$ Student Name, Major, Advisor$)$

$[$Assume that each major has exactly one advisor.$]$

$$

$($circle one:$)$

None$1$NF$2$NF$3$NF

Explanation:

$$

$$

$$

$3.$ Using functional dependency principles, assess the normal form of MOVIE.

MOVIE relation:

MOVIE$($Movie ID$,$ Copy No$,$ Movie Name, Movie Type, Status$)$

$$

$($circle one:$)$

None$1$NF$2$NF$3$NF

Explanation: