7. ADVERTISEMENT
<pre>
CREATE TABLE OUTLETADVERTISEMENT
(
OutletID PropertyID NUMBER(46), OutletID OutletName VARCHAR2NUMBER(404) NOT NULL, OutletPhone VARCHAR2(15) NOT NULLAdvDate DATE, OutletType CHARAdvCost NUMBER(16) NOT NULL, CONSTRAINT outlet_outletid_pk ad_adid_pk PRIMARY KEY(PropertyID, OutletID), CONSTRAINT outlet_outlettype_ck CHECKad_propertyid_fk FOREIGN KEY(OutletType INPropertyID) REFERENCES PROPERTY('N'PropertyID),'M','W','F' CONSTRAINT ad_outletid_fk FOREIGN KEY(OutletID) REFERENCES OUTLET(OutletID), CONSTRAINT outlet_outletname_type_uk UNIQUEad_advcost_ck CHECK(OutletName, OutletTypeAdvCost > 0)
);
</pre>
8. CLIENT
<pre>
