Using the Oracle SQL*Plus editor, develop a database based on your data model.
The database should contain all the tables and attributes discussed in the project specifications. Be sure to use your data dictionary when creating your tables.
To submit this task you need to create a file in notepad called TASK2.TXT. In this file create a heading called CREATE STATEMENTS and then develop the CREATE TABLE statements required to create your database tables. Be sure to include the DROP TABLE statements at the top of your file so that you can reuse the file. If you will include the wording CASCADE CONSTRAINTS as part of each DROP TABLE statement then the order of the DROP statements will not make a difference. For example, to drop a table named customer you would state:
DROP TABLE CUSTOMER CASCADE CONSTRAINTS;
After testing and verifying that all of your create statements work, create a spooled output file with the SET ECHO ON session command set so that your code and the results will show.
Deliverables for this task:
Task 2 comprised of the CREATE TABLE script file and the output file showing that it works.
