Database design and optimisation Undergraduate

Written Assignment 1

Attached file: LoadDB.sqlPreview the document

Download the script file, LoadDB.sql to C:CIS4210
Run sqlplus SYSTEM/Oracle11
Enter START C:CIS4210LoadDB.sql
Enter SPOOL C:CIS4210M1spool.txt
DESCRIBE iggy.part;
SELECT * FROM iggy.part;
DESCRIBE iggy.supplier;
SELECT * FROM iggy.supplier;
DESCRIBE iggy.quote;
SELECT * FROM iggy.quote;
SPOOL OFF;
QUIT;

Submit your text document with the file name c:cis4210M1spool.txt . You now can run sqlplus iggy/oracle in order to try the various examples in the book.