Homework_05 - Spring 2010: ISAM 5331.01 / ACCT 5333.01...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Spring 2010: ISAM 5331.01 / ACCT 5333.01 Copyright © 2010 Richard Meyer. All rights reserved. This material may not be reproduced, displayed, modified or distributed without the express prior written permissions of the copyright holder. Homework Assignment 05 For the following questions please provide the answers using the Courier New font in Microsoft Word and be sure to disable smart quotes . It is also recommended that the answers be submitted using a plain text (TXT) file. Important: Remember to include your Full Name, Class Number, and Date at the top of the file. Provide the Oracle SQL Statements , and a copy of the output , that provide the best solution to the following: 1. Display the current date by using the DUAL table. 2. Display the schools and their deans 3. Display the majors that belong to the School of Business 4. Display the majors that belong to the School of Science and Computer Engineering 5. Display the names of students who have selected a major 6. Display the names of students who have not selected a major
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.
Ask a homework question - tutors are online