Q$1)$ Apply and illustrate the process of normalizing the data shown in this table $1$ to first normal

form $(1$NF$)?$

Table $1($not in $1NF)$ Q$2)$ Apply and illustrate the process of normalizing the data shown in this table $2$ to second

normal form $(2$NF$)?$

Table $2($Not in $2$NF$)$

Composite

primary key

Values in branchAddress column can be worked

out from only branchNo, so table not in $2$NF

Values in branchNo column can be worked out from branchAddress

Values in name and position columns can be worked out from only staffNo, so table not in $2$NF

Values in hoursPerWeek column can only be worked out from staffNo and branchNo Q$3)$ Apply and illustrate the process of normalizing the data shown in this table $3$ to third normal form $(3$NF$)?$

Table $3($Not in $3$NF$)$

StaffBranch $($Not $3$NF$)$

$\backslash$table$[[$staffNo$,$name,position,salary,branchNo,branchAddress,telNo$],[$S$1500,$Tom Daniels,Manager,$46000,$B$001,8$ Jefferson Way, Portland, OR $97201,503-555-3618],[$S$0003,$Sally Adams,Assistant,$30000,$B$001,8$ Jefferson Way, Portland, OR $97201,503-555-3618],[$S$0010,$Mary Martinez,Manager,$50000,$B$002,$City Center Plaza, Seattle, WA $98122,206-555-6756],[$S$3250,$Robert Chin,Supervisor,$32000,$B$002,$City Center Plaza, Seattle, WA $98122,206-555-6756],[$S$2250,$Sally Stern,Manager,$48000,$B$004,16-14$ th Avenue, Seattle, WA $98128,206-555-3131],[$S$0415,$Art Peters,Manager,$41000,$B$003,14-8$th Avenue, New York, NY $10012,212-371-3000]]$

Primary

key

Values in all non$-$primary$-$key columns can be worked out from the primary key, staffNo

Values in branchAddress and telNo columns can be worked out from branchNo, so table not in $3NF$

Values in branchNo and telNo columns can be worked out from branchAddress, so table not in $3NF$

Values in branchNo and branchAddress columns can be worked out from tellNo, so table not in $3NF$