Project 3 MIS - FROM faculty fac, faculty, super WHERE...

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

View Full Document Right Arrow Icon
Project 3 MIS Faculty first name, last name, student first and last name SELECT f_last, f_first, s_last, s_first FROM faculty, student WHERE faculty.f_id= student.f_id (join) Find out last name, first name of faculty who had taught a course in summer 2007 SELECT f_last, factulty.f_id, FROM faculty, course section, term WHERE faculty.f_id= course_section.f_id and course_section.term_id= term.term_id Find out course # and grade for student “Sarah Miller” SELECT call_id, grade FROM course, course_id.section, enrollment, student WHERE course.course_id= course.section.course_id and entrollment.s_id=student.s_id and s_last = “Miller” and s_first= “Sarah”; SELECT fac.f_last, fac.f_last, super.f_last, super.f_first
Background image of page 1

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

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

Unformatted text preview: FROM faculty fac, faculty, super WHERE fac.f_id= super.f_id; Find last name, first name of those students who are taking the same class as Daniel black SELECT s_class FROM student WHERE s_last= Black and s_first= Daniel SELECT s_last, s_first FROM student WHERE s_class = (SELECT s_class FROM student WHERE s_last= Black and s_first= Daniel); SELECT f_last, f_first, f_phone FROM faculty union Select s_last, s_first, s_phone From student Name of courses taken only by students who are not seniors during term 6 SELECT DISTINCT course.name FROM course, course.section, enrollment, student WHERE course.course_id= course_section.course_id AND course_section.c_sed...
View Full Document

This note was uploaded on 10/03/2011 for the course MIS 235 taught by Professor Sunrro during the Fall '08 term at Miami University.

Page1 / 2

Project 3 MIS - FROM faculty fac, faculty, super WHERE...

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