Homework_06 - Spring 2010: ISAM 5331 / ACCT 5333 Homework...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Spring 2010: ISAM 5331 / ACCT 5333 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 06 For the following questions please provide the answers using the Courier New font in Microsoft Word, or optionally in a plain text (TXT) file. Please refer to Homework 3 for re-installing the STU database and spooling output. Remember to include your Full Name, Class Number, and Date at the top of the file. You must submit this homework assignment by email to the Instructor and the Teaching Assistant. Provide the Oracle SQL Statements , and a copy of the output , that provide the best solution to the following: 1. Using equality joins: select the students, the names of their majors, and their grades 2. Using an outer join: select all of the students and the names of their majors (if available) 3. Using an outer join: select all of the students and their grades (if available)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

Homework_06 - Spring 2010: ISAM 5331 / ACCT 5333 Homework...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online