Hello again George!
Please download the files here:DOWNLOAD
This is everything that you need for this assignment. Of course, you still have to run it on your school server.
If you are going to run with SQL*Plus, then you will upload the three sql files to your school account and run it in SQL*Plus with the command:@project2.sql
This will automatically create a spool file for you called MY_SPOOL.TXT
I have sent you my copy of the spool file to show you that everything works fine. But you still need to run this stuff on your school's server.
If you are going to use iSQL*Plus, then you cannot create a spool file like this (as mentions din the assignment). I this case, you will run all of the code in p2_step1.sql and then p2_step2.sql and redirect your output to an HTML file, as mentioned in the assignment. I'm note entire sure how you go about doing that, as I never use iSQL. I use SQL*Plus. It is easier that way, as you can run everything instantly with a single command. You just need to make sure the three SQL files are in the write place. All the information about connecting to SQL*Plus and where to upload your files should all have been provided to you in your course. Unfortunately, I cannot log into your school account and run this stuff for you. But I can promise that it all works and meets all of the requirements. You can review the spool file I sent to see the results of me running it.
Please keep in mind that the first time you run this stuff, you WILL get errors. That is because you are required to include drop tables in your scripts. The first time you run them, there will be no tables to drop. Therefore, you will get errors. You can simply ignore them. They're are normal.
Let me know if you have any questions. I'm here to help.
Please remember to rate my answer. Thank you so much and have a wonderful day!