$4.$ Page $4$ of this handout contains three tables. One contains data on suppliers, one contains data on parts, and one contains data on shipments. The SHIPMENT table contains data on parts shipped by suppliers. For example, supplier S$1$ ships a quantity of $300$ units of part P$1.$ Likewise, supplier S$1$ ships a quantity of $200$ units of part P$2.$ The following six questions pertain to these three tables$\mathrm{.}5.5.$ Describe the nature of the referential integrity constraint$($s$)$ that involve the SUPPLIER and SHIPMENT tables.SUPPLIER Table $($S#$,$ SNAME, STATUS, CITY$)$ PART Table $($P#$,$ PNAME, COLOR, WEIGHT$)$

P# PNAME COLOR WEIGHT

S# SNAME STATUS CITY $------------------$

$---------------------------$ P$1$ Nut Red $12$

S$1$ Smith $20$ London P$2$ Bolt Green $17$

S$2$ Jones $10$ Paris P$3$ Screw Blue $17$

S$3$ Blake $30$ Paris P$4$ Screw Red $14$

S$4$ Clark $20$ London P$5$ Cam Blue $12$

S$5$ Adams $30$ Athens P$6$ Cog Red $19$

SHIPMENT Table $($S#$,$ P#$,$ QTY$)$

S# P# QTY

$--------------$

S$1$ P$1300$

S$1$ P$2200$

S$1$ P$3400$

S$1$ P$4200$

S$1$ P$5100$

S$1$ P$6100$

S$2$ P$1300$

S$2$ P$2400$

S$3$ P$2200$

S$4$ P$2200$

S$4$ P$4300$

S$4$ P$5400$