INFS 614-003 – Dr. Ken Smith - George Mason University

GTA’s Electronic Submission Guide

1.    Prepare your submission: Create a script file by putting all the commands (SQL statements, without sqlplus prompts and outputs) in ONE file, then run it in sql*plus. Send the script file in text format. Note that text file means only ASCII code is allowed (so it can be executed easily). If you use a word processor, make sure you save the file in ASCII format. No other formats are acceptable (e.g. Word).

If you are using Windows, make sure to use Notepad, or save as text file. If you are using Unix lab, try the editor "pico" if you are not familiar with any other text editors.

About how to create a script file and run it in sql*plus, please refer to the Oracle user guide. Before you submit, please run your script file to make sure it is executable. Un-executable script files will receive zero for the part of script file! No exceptions.

Please name your script file in this way: Initial letter of your first name + your last name + ".sql". For example, if your name is John Smith, your script file should be JSmith.sql.

If you have to use more than one text file to submit, you must talk to the GTA or instructor to get permission.

2.    First few lines: As the first few lines of the text file, put your name, , G#, the assignment number the instructor’s name and the section you are attending (Section 003 – Thursday). You need also put your email address in these few lines.
Be sure to add comment symbol before and after them.  

Here is an example:

// Student: John Smith 

// Your G#

// Assignment #1

// Section 003 – Thursday

// Instructor – Dr. Ken Smith

// Email: jsmith@gmu.edu

 

3.    Send the text file as an attachment to: lockejudy@gmail.com

Please name your email subject in this way: Homework title + “-” + your first name + your last name. For example, if your name is John Smith, and you are submitting your homework 1c, your email subject should be “Homework 1c – John Smith”.

4.    Always submit a paper copy in class for all your electronic submissions. The due time is the same as the electronic submission and in-class submission. Please note that there will be a strictly enforced 10% penalty per day for late submissions.

 

5.    Do not double send the same script file.

Any violation may cause a loss of points!