What is the correct order to CREATE the tables? Think about referential integrity.

a$.$ Owner, Pet Appointments, Treatment, Treatment$\_$Appt

b$.$ Pet, Treatment, Appointments, Owner, Ttreatment$\_$appt

c$.$ Treatment, Owner, Pet, Appointments, Treatment$\_$appt

The Appointments table was not created with a primary key. What is the correct SQL to create a primary key for the table and which field should be the primary key?

a$.$ ALTER TABLE Appointments

Add Primary Key $($APPOINTMENT$\_$ID$))$;

b$.$ CREATE PRIMARY KEY TABLE Appointments APPOINTMENT$\_$DATE;

c$.$ Modify Appointments

PRIMARY KEY PET$\_$ID;

The OWNER$\_$ID in the Pet table should be NOT NULL. What SQL corrects this?

a$.$ CHANGE TABLE Pet

MODIFY OWNER$\_$ID NOT NULL:

b$.$ MODIFY TABLE Pet

ADD NOT NULL TO OWNER$\_$ID;

c$.$ ALTER TABLE Pet

MODIFY OWNER$\_$ID INT NOT NULL;

All owners reside in Nevada. What SQL makes NV the default when a row is entered?

a$.$ ALTER TABLE Owner

STATE $={?}^{\text{'}}NV$

b$.$ ALTER TABLE Owner

MODIFY OWNER$\_$STATE CHAR $(2)$ DEFAULT $\text{'}$NV$\text{'}$;

c$.$ ALTER TABLE Owner

OWNER$\_$STATE $=\text{'}$NV$\text{'}$;

$0=$ Icon Key