Part A: MCQs and True$/$False

i$.$ Database redesign is fairly easy when $\_\_\_\_\_\_\_\_.$

A$)$ information systems and organizations influence each other

B$)$ the design was done correctly the first time

C$)$ there is no data in the database

D$)$ good backups of the database are available

ii$.$ In the database redesign process, an SQL tool that is useful for testing whether or not certain conditions or assumptions are valid is $\_\_\_\_\_\_\_\_.$

A$)$ UPDATE

B$)$ DROP TABLE

C$)$ CREATE TRIGGER

D$)$ NOT EXISTS