Remaining Time: $3$ hours, $20$ minutes, $50$ seconds.

Question Compietion Status:

$10$

$20$

$3Q$

$4$

$5\sqrt[\phantom{2}]{1}$

$6$

$70$

$8$

$9$

$10C$

$11$

$12$ L ${?}^2$

$130$

$14$

$15$

$16$

$17$

Question $22$

Consider the following database.

Relation Schemas:

Relation Schemas:

Suppliers$($sID CHAR$(5),$

sName VARCHAR$(15),$ address VARCHAR$(30),$ city VARCHAR$(20),$ state CHAR$(2),$ PRIMARY KEY$($sID$))$;

Cntnlog$($sID CHAR$(5),$

pID VARCHAR$(5),$

qty SMALLINT,

cost FLOAT$(10,2),$

PRIMARY KEY$($sid$,$ pid$),$

FOREIGN KEY$($sid$)$ REFERENCES Suppliers$($sID$),$

FOREIGN KEY$($pid$)$ REFERENCES Parts $(p(D))$;

The meaning of these relations is straightforward; for example, the Catalog relation lists the prices charge

Instances of the relations:

Suppliers

$\backslash$table$[[$sID$,$sName,address,city,state$],[$A$3001,$At$,123IT$ St$.,$Greensboro,NC$],[$A$2002,$Harold Goods,$456ET$ St$.,$Greensboro,NC$],[$A$3010,$Robert Computers,$789$ CT Rd$.,$Charlotte,NC$],[$A$0501,$Brown Brothers,$323$ BE Rd$.,$Charlotte,NC$]]$

Parts

$\backslash$table$[[$pID$,$type,pName,color$],[$M$305,$Mouse,Wireless Optical Mouse,Black$],[$KB$010,$Kevboard,Logitech Cordless Desktop,White$],[$M$111,$Mouse,Wireless Optical Mouse,Pink$]]$

Parts$($pID VARCHAR$(5),$ type VARCHAR$(15),$ pName VARCHAR$(35),$ color VARCHAR$(20),$

PRIMARY KEY$($pID$))$;

Suppose that "Delete FROM Suppliers WHERE sName $=$ 'Harold Goods';" is applied directly to the a

A$.$ Accept, there are no constraint violations.

B$.$ Reject, it violates both the key constraint and referential integrity constraint.

C$.$ Reject, it violates the referential integrity constraint.

D$.$ Reject, it violates the key constraint.