A turnin account was created for you when you registered for this course. But you need a CS account to access it. If you already have a CS account from a course that you took last semester and you remember your password then your turnin account should work for you. If you have forgotten your password, then you can reset it. However, if you took a CS course more than two semesters ago then your account has probably expired and you need to apply for a new CS account.
Please submit the answers to the following questions by 11 p.m. on Wednesday (08 Feb 2012). Use the turnin system to submit your homework electronically. The problems are taken from Oracle SQL by Example.
You will be running your SQL queries in SQL Developer against the database that you created. The link Populating Your Database with Data gives you the necessary steps to create the tables that you need.
For the best learning experience, look at the problem statement in the book and then run your query in SQL Developer. If it does not work, try several times. When you have finished the questions save your work in a .sql file. You may later edit the file and remove the wrong answers.
We want your answers in a .sql. A .sql file is basically a text file with a .sql extension. You can save whatever you type in a worksheet in the SQL Developer in a .sql file. You can write comments in two ways:
/* File: Assignment1.sql Student's Name: Student's UT EID: Course Name: CS 327E Unique Number: 52885 Date Created: Date Last Modified: */You should give the question number as a comment, followed by the SQL statement. There should be at least two blank lines between answers.
-- Chapter 3 Workshop, Ques 1: SELECT FROM WHERE