Jared Capaldi

June $4,2024$

Already in $2NF$

STAFF Table

CUSTOMER Table

STAFF$($ staff id$,$ staff$\_$name, sales$\_$office, office$\_$manager, office$\_$phone $)$

CUSTOMER$($ customer id$,$ customer$\_$name, customer$\_$city, customer$\_$postal, staff$\_$id $)$

Convert to $3NF$ :

Eliminate transitive dependencies where non$-$key attributes are dependent on non$-$key attributes.

Convert tables to $3$NF and create relational schema in text format