Consider the following database.

Relation Schemas:

Relation Schemas:

Suppliers$($SID CHAR$(5)$

sName VARCHAR$(15),$

Parts$($pID VARCHAR$(5),$

address VARCHAR$(30),$

aity VARCHAR$(20),$

type VARCHAR$(15),$

state CHAR$(2),$

pName VARCHAR$(35)$

PRIMARY KEY$($sID$))$:

PRIMARY KEY$($pID$))$;

Catalog$($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 charged for parts by Suppliers.

Instances of the relations:

Suppliers

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

Part

$\backslash$table$[[$ID$,$type,PVame,color$],[M305,$Mouse,Wireless Optical Mouse,Black$],[$KB$010,$Keytroard,Logitech Cordless Desktor:,White$],[M111,$Mouse,Wireless Optical Mouse,Pink$]]$

Catalog

$\backslash$table$[[$SID$,$FID,gty$,$cost$],[$A$3001,$M$305,2,20\mathrm{.}00],[$A$2002,$K BB$010,3,35\mathrm{.}90],[$A$3001,$KB$010,4,30\mathrm{.}50]]$

integrity constraint violations?

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

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

C$.$ Reject, it violates the domain constraint.

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