Open main menu

CDOT Wiki β

Changes

J.Y.S

1,098 bytes added, 14:22, 27 November 2010
no edit summary
|}
=Assignment 3 (worth 9%)=
==Due Date==
Thursday, December 2nd, 3:00pm
Normal 0 false false false EN-US KO X-NONE MicrosoftInternetExplorer4 Printout of all TIC charts and DDL / DML statements
 
==Solution==
==== DDL Statements (CREATE TABLE) ====
1. AREA
<pre>
CREATE TABLE AREA
(
AreaID NUMBER(4) CONSTRAINT area_areaid_pk PRIMARY KEY,
AreaName VARCHAR2(30) NOT NULL CONSTRAINT area_areaname_uk UNIQUE,
ElmSchool VARCHAR2(40),
MidSchool VARCHAR2(40),
HighSchool VARCHAR2(40),
Comments VARCHAR2(100)
);
</pre>
2. AGENCY
<pre>
</pre>
3. PROPERTY
<pre>
</pre>
4. SINGLE
<pre>
</pre>
5. CONDO
<pre>
</pre>
6. OUTLET
<pre>
</pre>
7. ADVERTISEMENT
<pre>
</pre>
8. CLIENT
<pre>
</pre>
9. DEED
<pre>
</pre>
=Assignment 1=
==Due Date==