Below describes the general procedure for grading the projects this semester. I hope this help you in terms of the ways to work at your SQL code.
- Your project (SQL script file) will be downloaded to a local project folder.
- The SQL script will be inspected to make sure it will not cause any damage on my system. I did experience some code that caused some significant problem on my system, which took me many hours to recover.
- Correct obvious syntax problems and save the file.
- Run the script on SQL Plus in my database system.
- Correct errors if possible.
- Rerun the SQL script until errors are all resolved. This is under the assumption that the code is workable. If the code is totally a mess (sometimes I cannot follow the logics), I will have to give up debugging.
- Run my test script to make you have accomplished all the specified tasks. I have a test script for each project to be efficient and consistent across the whole class.
- Award (partial) points according to what you have accomplished against the specification in the project description.
- Write comments if needed.
|
