354.3-08.Solution2

354.3-08.Solution2 - CMPT-354 D1 Fall 2008 Instructor:...

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

View Full Document Right Arrow Icon
CMPT-354 D1 Fall 2008 Instructor: Martin Ester TA: Gustavo Frigo Solution Assignment 2 Total marks: 100 (10 % of the assignments) Due date: September 26, 2008 Introduction This is a practical assignment using SQL Server 2005 Management Studio. Please, submit your solutions in electronic form by email to the TA. Here is a very useful online book that contains a lot of practical hints: Paul Nielsen: „SQL Server 2005 Bible“, John Wiley & Sons, 2007 Available online at http://library.books24x7.com/toc.asp?bookid=17098 SQL Server comes with some sample databases, of which we are using the AdventureWorksLT database in this assignment. The following diagram shows the schema of that database:
Background image of page 1

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

View Full DocumentRight Arrow Icon
Tasks Formulate each of the following queries in SQL. a) Find the FirstName, LastName and the City of all Customers in British Columbia. SELECT FirstName , LastName , City FROM SalesLT . Customer C , SalesLT . CustomerAddress CA , SalesLT . Address A WHERE A . StateProvince = 'British Columbia' AND
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

354.3-08.Solution2 - CMPT-354 D1 Fall 2008 Instructor:...

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

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