assignment6

assignment6 - CIS 111 Section 1004 Intro to Relational...

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

View Full Document Right Arrow Icon
CIS 111 - Section 1004 – Intro. to Relational Database Management Systems Strayer University, Anne Arundel Campus, Room 118 Prof. Reggie Haseltine Assignment #6 – Advanced SELECT Queries/APA Writing Assignment 10 points (There are 15 extra points available so LATE WORK EARNS NO CREDIT!) This assignment builds on Assignments #4 and #5 and assumes that you've fully built and populated your Mom and Pop Video Store database with the four tables (i.e. CUSTOMERS, RENTALS, RENTAL_LINES, and DVDS_VIDEOS), and four rows of data per table (i.e. 16 total rows). Therefore you must successfully complete the items in these Assignments #4 and #5 before beginning this one. Remember that there are suggested solutions posted by the instructor in Doc Sharing in the eCompanion classroom for these two assignments you can review. In this assignment you'll do some advanced SQL SELECT queries that include various WHERE clause operators, compound conditions, table joins, grouping, subqueries, and the UNION operator. There is an example of the SQL for a UNION query on page 353 of the text. In addition, example queries of this type are posted in Doc Sharing in the eCompanion classroom. For all queries you'll be graded on the proper SQL syntax and setup, not the actual
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.

This note was uploaded on 09/25/2011 for the course CIS 111 taught by Professor Pourciau during the Spring '09 term at Strayer.

Page1 / 3

assignment6 - CIS 111 Section 1004 Intro to Relational...

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