Q$3.$

$($a$)(6\%)$ Use examples to explain why transitive dependencies and partial dependencies are considered bad in a relational schema.

$($b$)(3\%)$ Discuss the problem of spurious tuples and how we may prevent it$.$