Task #$5$: Updating Rows

Staff

Which of the following SQL statement properly adjusts an in the table above?

A$.$ UPDATE Staff SET bAddress $="195$ Post Rd$.,$ Glasgow" WHERE staffNo $=$

$"$SG$37"$;

B$.$ UPDATE Staff SET bAddress $="195$ Post Rd$.,$ Glasgow";

C$.$ UPDATE Staff SET bAddress $="195$ Post Rd$.,$ Glasgow" WHERE branchNo

$={?}^a\frac{B}{O}O3"$;

Task #$6$

Updating Rows

Staff

Based on a close reading of the choices in Task #$5,$ name one anomaly $($mistake$)$

that could rise when updating records?

Task #$7$

Deleting Rows

Which of the following SQL statement properly deletes a staff record. Additionally

explain the rationale for each of the choices $($correct and wrong ones$)?$

A$.$ DELETE FROM Staff WHERE staffNo $="$SA$9"$;

B$.$ DELETE FROM Staff;

C$.$ DELETE FROM Staff WHERE position $=$ "Assistant""