$6.($a$)$ Consider an unnormalized "Employees" table that includes the following columns:

Emp$\_$id $($which serves as the primary key$),$ Emp$\_$name, Dept, and Dept$\_$location.

Your task is transforming this table into the third normal form $(3$NF$).$

$[5]$

Emp$\_$id

$1$

Emp$\_$name

John

Dept

HR

Dept$\_$location

New York

$2$

Jane

HR

New York

$3$

Mark

IT

San Francisco

$4$

Sarah

IT

San Francisco

$5$

David

IT

San Francisco

$($b$)$ Normalize the following unnormalized table "Orders" to the second normal form

$(2$NF$).$ Identify the functional dependencies and primary key.

$[5]$

Order$\_$id

Cust$\_$Name

Cust$\_$City

Product$\_$id

Product Name Quantity

$1$

John Smith

New York

$100$

Laptop

$2$

$2$

John Smith

New York

$101$

Printer

$1$

$3$

Mary

Los Angeles

$102$

$4$

Mary

Los Angeles

$100$

Smartphone

Laptop

$3$

$1$