1
edit
Changes
→DDL Statements (CREATE TABLE)
CREATE TABLE SINGLE
(
PropertyID NUMBER(6) , LotSize NUMBER(8,2) NOT NULL, CONSTRAINT single_propertyID_pk PRIMARY KEY(PropertyID), CONSTRAINT single_propertyID_fk FOREIGN KEY(PropertyID) REFERENCES PROPERTY(PropertyID), LotSize NUMBER(8,2) NOT NULL CONSTRAINT single_lotsize_ck CHECK(LotSize > 0)
);
CREATE TABLE CONDO
(
PropertyID NUMBER(6) , Fee NUMBER(8,2) NOT NULL, CONSTRAINT condo_propertyID_pk PRIMARY KEY(PropertyID), CONSTRAINT condo_propertyID_fk FOREIGN KEY(PropertyID) REFERENCES PROPERTY(PropertyID), Fee NUMBER(8,2) NOT NULL CONSTRAINT condo_fee_ck CHECK(Fee > 0)
);
</pre>
=Assignment 1=
==Due Date==
